Re: pgsql8b5 not launching on OSX system start; otherwise OK - Mailing list pgsql-general
From | OpenMacNews |
---|---|
Subject | Re: pgsql8b5 not launching on OSX system start; otherwise OK |
Date | |
Msg-id | F0691CCE1562BBFBA2A18458@tiedgar.internal.presence-group.net Whole thread Raw |
In response to | Re: pgsql8b5 not launching on OSX system start; otherwise OK (Tom Lane <tgl@sss.pgh.pa.us>) |
Responses |
Re: pgsql8b5 not launching on OSX system start; otherwise OK
(Alvaro Herrera <alvherre@dcc.uchile.cl>)
Re: pgsql8b5 not launching on OSX system start; otherwise OK (Tom Lane <tgl@sss.pgh.pa.us>) |
List | pgsql-general |
hi tom, -- On Thursday, December 2, 2004 12:33:48 PM PST -0500 Tom Lane <tgl@sss.pgh.pa.us> wrote: > OpenMacNews <pgsql-general.20.openmacnews@spamgourmet.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
pgsql-general by date: