Your name : Aaron Hillegass
Your email address : aaron (AT) bignerdranch (DOT) com


System Configuration
---------------------
Architecture (example: Intel Pentium) : PPC

Operating System (example: Linux 2.4.18) : Mac OS X 10.3.5

PostgreSQL version (example: PostgreSQL-8.0): PostgreSQL-8.0b4

Compiler used (example: gcc 2.95.2) : gcc version 3.3 20030304
(Apple Computer, Inc. build 1666)


Please enter a FULL description of your problem:
------------------------------------------------

I have a script that must start the postmaster before continuing, so I
do this:

But this always fails:

start............................................. ..................coul
d not start postmaster

But the postmaster is actually started:


template1=#

Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------

Note that the process's user name (postgres) is different from the
database's owner (nopali).


If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------

I suspect that the problem is that when I did initdb, I used 'nopali'
as the username, but pg_ctl is being run as 'postgres'. Because there
is no database user called 'postgres', I think that this line in
pg_ctl.c always fails:

if ((conn = PQsetdbLogin(NULL, portstr, NULL, NULL,

"template1", NULL, NULL)) != NULL &&
(PQstatus(conn) == CONNECTION_OK ||
(strcmp(PQerrorMessage(conn),
PQnoPasswordSupplied) == 0)))



---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org

Aaron Hillegass <aaron (AT) bignerdranch (DOT) com> writes:
This is not going to work very well because sudo doesn't update the
environment --- for example if PGUSER is set in your environment then
that's the username pg_ctl will try to use to connect with. Perhaps
try

sudo su -l postgres -c '/Library/PostgreSQL/bin/pg_ctl -w start'

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster