Re: [HACKERS] make check fails: user "postgres" doesn't exist
Markus Bertheau <[EMAIL PROTECTED]> 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 ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [HACKERS] make check fails: user "postgres" doesn't exist
В Втр, 01.07.2003, в 23:30, Tom Lane пишет: > Markus Bertheau <[EMAIL PROTECTED]> 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. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] make check fails: user "postgres" doesn't exist
Markus Bertheau <[EMAIL PROTECTED]> 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 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] 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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> To: Jeff <[EMAIL PROTECTED]> Cc: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749 ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [HACKERS] 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 <[EMAIL PROTECTED]> > To: Jeff <[EMAIL PROTECTED]> > Cc: [EMAIL PROTECTED] > 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 pgp0.pgp Description: PGP signature
Re: [HACKERS] 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. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] 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 <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > 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 ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[HACKERS] 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. ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
