From: | Michael Glaesemann <grzm(at)seespotcode(dot)net> |
---|---|
To: | smithrn(at)u(dot)washington(dot)edu |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Auto Starting +/or Shutdown on OS X |
Date: | 2007-07-31 23:01:41 |
Message-ID: | 3B36B5C7-0D9A-4C13-A3D0-CEDAEC080E5F@seespotcode.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Jul 31, 2007, at 14:27 , Ralph Smith wrote:
> === INITIAL POST ====================
> I'm using scripts in /Library/StartupItems/PostgreSQL
>
> PostgreSQL starts manually just fine via
> /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -l /usr/local/
> pgsql/logfile start
What user are you starting the server as? Is this the same user you
have specified in the StartupItem/launchd plist?
> If I execute the start command above just after a System start I get
> pg_ctl: another server may be running; trying to start server anyway
> server starting
> and then it starts and runs fine.
I'm speculating that the StartupItem is trying to start the server
but failing.
> I'm looking at getting that debugging to log where I can find it.
> Can someone help me config extended logging?
> log_destination, log_directory, log_filename
I believe you should be able to set these at startup, though I
haven't tried.
> <string>/usr/local/pgsql/bin/postmaster</string>
> <string>-D</string>
> <string>/usr/local/pgsql/data</string>
> <string>-l</string>
> <string>/usr/local/pgsql/logfile</string>
> <string>-c</string>
> <string>redirect_stderr=YES</string>
> <string>-c</string>
> <string>log_min_message=DEBUG5</string>
> <string>-c</string>
> <string>log_error_verbosity=VERBOSE</string>
Did you also change the user and group to what's appropriate for your
setup?
Michael Glaesemann
grzm seespotcode net
From | Date | Subject | |
---|---|---|---|
Next Message | Vyacheslav Kalinin | 2007-07-31 23:33:20 | Re: Polymorphic functions' weird behavior |
Previous Message | Richard Broersma Jr | 2007-07-31 21:59:41 | Re: plperl syntax highlighting for vi |