Re: pgsql8b5 not launching on OSX system start; otherwise OK

hi tom,

-- On Thursday, December 2, 2004 12:33:48 PM PST -0500 Tom Lane
<tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> OpenMacNews <pgsql-general(dot)20(dot)openmacnews(at)spamgourmet(dot)com> writes:
>> sudo -u testuser sh -c "nohup /usr/local/pgsql/bin/postmaster -n -i -h
>> 10.0.0.6 -D /var/data/pgsql -c config_file=/etc/pgsql/postgresql.conf
>> </dev/null >>/var/devlogs/postgres.log &"
>
> Hmm, isn't this letting postmaster stderr disappear into the bit bucket?

entirely possible, and probably probable.

(it actually was 'in there' at one point, per the distro's included startup
script ... damn that copy-n-paste!)

> Try adding "2>&1" after the ">>/var/devlogs/postgres.log" so you can see
> if anything interesting shows up.

ok, did that, and 'simplified' my cmd as much as possible ...

here's the exact c/p from my current script:

sudo -u testuser sh -c "/usr/local/pgsql/bin/postmaster -i -h 10.0.0.6 -D
/var/data/pgsql -c config_file=/etc/pgsql/postgresql.conf &"
>>/var/devlogs/postgres.log 2>&1

which i've tried to make 'as similar as possible' to the distro's example
script:

sudo -u $PGUSER sh -c "${DAEMON} -D '${PGDATA}' &" >>$PGLOG 2>&1

given my additions of:

-n do not reinitialize shared memory after abnormal exit
-i enable TCP/IP connections
-h HOSTNAME host name or IP address to listen on

, and the spec'd config file,

mine, all in all, _looks_ ok to me.

with the aforementioned startup string, here's the tail from my
'/var/devlogs/postgres.log' immediately after a reboot, b4 starting postmaster
from the cmd line:

LOCATION: PostmasterMain, postmaster.c:644
DEBUG: 00000: -----------------------------------------
LOCATION: PostmasterMain, postmaster.c:646
DEBUG: 00000: invoking IpcMemoryCreate(size=2547712)
LOCATION: CreateSharedMemoryAndSemaphores, ipci.c:87
DEBUG: 00000: max_safe_fds = 917, usable_fds = 951, already_open = 73
LOCATION: set_max_safe_fds, fd.c:360
LOG: 00000: logger shutting down
LOCATION: SysLoggerMain, syslogger.c:361
DEBUG: 00000: proc_exit(0)
LOCATION: proc_exit, ipc.c:95
DEBUG: 00000: shmem_exit(0)
LOCATION: shmem_exit, ipc.c:126
DEBUG: 00000: exit(0)
LOCATION: proc_exit, ipc.c:113

whereas the output starting *successfully* by executing the startup script from
the cmd line is just:

LOCATION: PostmasterMain, postmaster.c:644
DEBUG: 00000: -----------------------------------------
LOCATION: PostmasterMain, postmaster.c:646
DEBUG: 00000: invoking IpcMemoryCreate(size=2547712)
LOCATION: CreateSharedMemoryAndSemaphores, ipci.c:87
DEBUG: 00000: max_safe_fds = 917, usable_fds = 951, already_open = 73
LOCATION: set_max_safe_fds, fd.c:360

note, of course, _no_ 'proc exit'.

thoughts?

richard