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

hi tom, After eyeballing that, I think I have no hope of reproducing your test conditions unless you show me the exact script and property list files you used. certainly easy enuf. thought *i'm* not certain *i* have hope of reproducing much after today's shenanigans ... jeeesh! fyi, the latest v

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

OpenMacNews <[EMAIL PROTECTED]> writes: > fyi: here's an O'Reilly blurb with way more info than you want to know ... > After eyeballing that, I think I have no hope of reproducing your test conditions unless you show me the exact scr

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

hi tom, however, if i place an identical startup string in my OSX's StartupItem for pgsql & reboot, pgsql does not start on boot. I was trying to reproduce this on my own machine, but couldn't get out of the starting gate. I put an executable shell script into "/System Folder/Startup Items", but I

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

i've a new install of pgsql8b5 running on OSX 10.3.6. ... however, if i place an identical startup string in my OSX's StartupItem for pgsql & reboot, pgsql does not start on boot. I was trying to reproduce this on my own machine, but couldn't get out of the starting gate. I put an executable shel

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

OpenMacNews <[EMAIL PROTECTED]> writes: > i've a new install of pgsql8b5 running on OSX 10.3.6. > ... > however, if i place an identical startup string in my OSX's StartupItem for > pgsql & reboot, pgsql does not start on boot. I was trying to reproduce this on my own machine, but couldn't get ou

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

OpenMacNews <[EMAIL PROTECTED]> writes: > stop postgres > touch PIDfile (if _not_ there) > reboot > --> NO launch, nothing in the logs > verify PIDfile exists ... it does But who is it owned by, and with what permissions? If you do the "touch" as some other user than the postm

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

OpenMacNews <[EMAIL PROTECTED]> writes: > note that my cmd line refers to the conf file, which has the external > PID id'd in it: > external_pid_file = '/var/run/postgresql.pid' Oh, now you tell us ;-) Still, I'm not sure what could be the problem. The only code that reacts to that setting

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

OpenMacNews <[EMAIL PROTECTED]> writes: > although i've seen nothing pid-related in my logs, preceding my startup file > launch cmd with a pid check/delete: >if [ -f /var/run/postgresql.pid ]; then >rm -rf /var/run/postgresql.pid >fi >(launch cmd) > seems to have done the tri

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

hi tom, LOG: 0: logger shutting down LOCATION: SysLoggerMain, syslogger.c:361 I should have twigged to that before --- if you're running the syslogger, then nothing except very early startup messages is going to go to stderr. Look in wherever you told it to put the log output. i thou

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

OpenMacNews <[EMAIL PROTECTED]> writes: > LOG: 0: logger shutting down > LOCATION: SysLoggerMain, syslogger.c:361 I should have twigged to that before --- if you're running the syslogger, then nothing except very early startup messages is going to go to stderr. Look in wherever you

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

On Thu, Dec 02, 2004 at 12:43:57PM -0800, OpenMacNews wrote: > 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 Why don't you use postgresql.conf

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

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 >/var/devlogs

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

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 > >/var/devlogs/postgres.log &" Hmm, isn't this letting postmaster stderr disappear into the bit bucket? Try