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

-- 
Markus Bertheau.
Berlin, Berlin.
Germany.

01 Jul 2003 22:28:12 +0200
Markus Bertheau <twanger@bluetwanger.de>
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

Tue, 1 Jul 2003 16:53:28 -0400
Jeff <jam@zoidtechnologies.com>
Re: make check fails: user "postgres" doesn't exist
В Втр, 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.

01 Jul 2003 23:09:15 +0200
Markus Bertheau <twanger@bluetwanger.de>
Re: make check fails: user "postgres" doesn't exist
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
Tue, 1 Jul 2003 17:21:37 -0400
Jeff <jam@zoidtechnologies.com>
Re: make check fails: user "postgres" doesn't exist
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




Tue, 01 Jul 2003 16:23:26 -0500
Larry Rosenman <ler@lerctr.org>
Re: make check fails: user "postgres" doesn't exist
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

Tue, 01 Jul 2003 17:30:11 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: make check fails: user "postgres" doesn't exist 
В Втр, 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.

01 Jul 2003 23:37:54 +0200
Markus Bertheau <twanger@bluetwanger.de>
Re: make check fails: user "postgres" doesn't exist
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

Tue, 01 Jul 2003 18:03:04 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: make check fails: user "postgres" doesn't exist 