Thread: make check fails: user "postgres" doesn't exist
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.
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