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@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