make check fails: user "postgres" doesn't exist

On Tue, Jul 01, 2003 at 10:28:12PM +0200, Markus Bertheau wrote:

Subject: [HACKERS] make check fails: user "postgres" doesn't exist
From: Markus Bertheau <twanger@bluetwanger.de>
To: pgsql-hackers@postgresql.org
X-Mailer: Ximian Evolution 1.4.0
Date: 01 Jul 2003 22:28:12 +0200

Hi,

make check fails, and I have absolutely no idea where to look:

running on port 65432 with pid 631
============== creating database "regression" ==============
createdb: could not connect to database template1: FATAL: user
"postgres" does not exist
pg_regress: createdb failed
make: *** [check] ???????????? 2

simply add the user. in a unix environment, and specifically Red Hat (though
it may apply in other places), you use the 'adduser' program, which has a
good man page. try 'man -k passwd' or 'man -k user' or something for hints
on your platform.

regards,
J
--
|| Jeff - http://zoidtechnologies.com/
|| GNUPG Fingerprint: A607 0F19 7C75 1305 67E4 BDFF 26BD 606E 3517 2A42

В Втр, 01.07.2003, в 22:53, Jeff пишет:

On Tue, Jul 01, 2003 at 10:28:12PM +0200, Markus Bertheau wrote:

make check fails, and I have absolutely no idea where to look:

running on port 65432 with pid 631
============== creating database "regression" ==============
createdb: could not connect to database template1: FATAL: user
"postgres" does not exist
pg_regress: createdb failed
make: *** [check] ???????????? 2

simply add the user. in a unix environment, and specifically Red Hat (though
it may apply in other places), you use the 'adduser' program, which has a
good man page. try 'man -k passwd' or 'man -k user' or something for hints
on your platform.

The user postgres exists, but that wouldn't help, because I'm running
make check as a user. And the postgres user that is meant is the
postgres user that has nothing to do with the system postgres user, I
think.

--
Markus Bertheau.
Berlin, Berlin.
Germany.

On Tue, Jul 01, 2003 at 11:09:15PM +0200, Markus Bertheau wrote:

Subject: Re: [HACKERS] make check fails: user "postgres" doesn't exist
From: Markus Bertheau <twanger@bluetwanger.de>
To: Jeff <jam@zoidtechnologies.com>
Cc: pgsql-hackers@postgresql.org
X-Mailer: Ximian Evolution 1.4.0
Date: 01 Jul 2003 23:09:15 +0200

?? ??????, 01.07.2003, ?? 22:53, Jeff ??????????:

On Tue, Jul 01, 2003 at 10:28:12PM +0200, Markus Bertheau wrote:

make check fails, and I have absolutely no idea where to look:

running on port 65432 with pid 631
============== creating database "regression" ==============
createdb: could not connect to database template1: FATAL: user
"postgres" does not exist
pg_regress: createdb failed
make: *** [check] ???????????? 2

simply add the user. in a unix environment, and specifically Red Hat (though
it may apply in other places), you use the 'adduser' program, which has a
good man page. try 'man -k passwd' or 'man -k user' or something for hints
on your platform.

The user postgres exists, but that wouldn't help, because I'm running
make check as a user. And the postgres user that is meant is the
postgres user that has nothing to do with the system postgres user, I
think.

ah, ok in that case you need to configure pg appropriately.. maybe you need
to 'map' your current username to 'postgres'.. I dunno :)

just trying to be helpful is all.. I shall step aside and let others
respond.

regards,
J
--
|| Jeff - http://zoidtechnologies.com/
|| GNUPG Fingerprint: A607 0F19 7C75 1305 67E4 BDFF 26BD 606E 3517 2A42

Are you looking for:

gmake installcheck

LER

--On Tuesday, July 01, 2003 17:21:37 -0400 Jeff <jam@zoidtechnologies.com>
wrote:

On Tue, Jul 01, 2003 at 11:09:15PM +0200, Markus Bertheau wrote:

Subject: Re: [HACKERS] make check fails: user "postgres" doesn't exist
From: Markus Bertheau <twanger@bluetwanger.de>
To: Jeff <jam@zoidtechnologies.com>
Cc: pgsql-hackers@postgresql.org
X-Mailer: Ximian Evolution 1.4.0
Date: 01 Jul 2003 23:09:15 +0200

?? ??????, 01.07.2003, ?? 22:53, Jeff ??????????:

On Tue, Jul 01, 2003 at 10:28:12PM +0200, Markus Bertheau wrote:

make check fails, and I have absolutely no idea where to look:

running on port 65432 with pid 631
============== creating database "regression" ==============
createdb: could not connect to database template1: FATAL: user
"postgres" does not exist
pg_regress: createdb failed
make: *** [check] ???????????? 2

simply add the user. in a unix environment, and specifically Red Hat
(though it may apply in other places), you use the 'adduser' program,
which has a good man page. try 'man -k passwd' or 'man -k user' or
something for hints on your platform.

The user postgres exists, but that wouldn't help, because I'm running
make check as a user. And the postgres user that is meant is the
postgres user that has nothing to do with the system postgres user, I
think.

ah, ok in that case you need to configure pg appropriately.. maybe you
need to 'map' your current username to 'postgres'.. I dunno :)

just trying to be helpful is all.. I shall step aside and let others
respond.

regards,
J

--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

Markus Bertheau <twanger@bluetwanger.de> writes:

make check fails, and I have absolutely no idea where to look:

running on port 65432 with pid 631
============== creating database "regression" ==============
createdb: could not connect to database template1: FATAL: user
"postgres" does not exist

(scratches head...) make check should automatically adopt your current
username as the postgres superuser name, AFAIK. Perhaps there is some
conflict in your environment settings? Do you have PGUSER defined, and
if so is it different from your login name?

You can dig around in the logs left in src/test/regress/log/ to see
what make check was doing. initdb's report of the username it thought
it was using would be worth looking at, in particular.

regards, tom lane

В Втр, 01.07.2003, в 23:30, Tom Lane пишет:

Markus Bertheau <twanger@bluetwanger.de> writes:

make check fails, and I have absolutely no idea where to look:

running on port 65432 with pid 631
============== creating database "regression" ==============
createdb: could not connect to database template1: FATAL: user
"postgres" does not exist

(scratches head...) make check should automatically adopt your current
username as the postgres superuser name, AFAIK. Perhaps there is some
conflict in your environment settings? Do you have PGUSER defined, and
if so is it different from your login name?

Exactly that was the case, thanks.

--
Markus Bertheau.
Berlin, Berlin.
Germany.

Markus Bertheau <twanger@bluetwanger.de> writes:

make check fails, and I have absolutely no idea where to look:

(scratches head...) make check should automatically adopt your current
username as the postgres superuser name, AFAIK. Perhaps there is some
conflict in your environment settings? Do you have PGUSER defined, and
if so is it different from your login name?

Exactly that was the case, thanks.

Hmm, seems like a misfeature in pg_regress. I guess adopting PGUSER
from the environment is a good thing to do in the "make installcheck"
case, but maybe it should drop it (along with the other environment
variables that could affect connections) in the "make check" case.
Peter, any thoughts about that?

regards, tom lane