Your name : Aaron Hillegass Your email address : [EMAIL PROTECTED]
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:
> sudo -u postgres /Library/PostgreSQL/bin/pg_ctl -w start
But this always fails:
> sudo -u postgres /Library/PostgreSQL/bin/pg_ctl -w start
waiting for postmaster to start...............................................................coul d not start postmaster
But the postmaster is actually started:
> /Library/PostgreSQL/bin/psql -Unopali template1 Welcome to psql 8.0.0beta4, the PostgreSQL interactive terminal.
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 [EMAIL PROTECTED]
