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

[OpenMacNews]

hi tom,
-- On Thursday, December 2, 2004 12:33:48 PM PST -0500  Tom Lane 
<[EMAIL PROTECTED]> wrote:

OpenMacNews <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
     subscribe-nomail command to [EMAIL PROTECTED] so that your
     message can get through to the mailing list cleanly