=== 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
PostgreSQL will not start on System restart using files in
/Library/StartupItems/PostgreSQL (no longer below).
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.
If I shut down PG using
pg_ctl stop (no users connected)
it stops and subsequently starts using code above just fine, w/o the
warning.
---
I added the command:
date > /Users/showmefile
to appropriate portions of /Library/StartupItems/PostgreSQL/PostgreSQL
as seen below, and the script portions ARE appropriately being executed.
How come shutdown isn't clearing things up?
Or is the problem in the startup?
Thanks!
=== FIRST REPLY ===========================
Michael G wrote:
On Jul 30, 2007, at 16:14 , Ralph Smith wrote:
I'm using scripts in /Library/StartupItems/PostgreSQL
I haven't used a StartupItem for PostgreSQL since launchd was released.
I haven't looked too closely at your configuration, but you might
consider using a launchd plist instead. Here's one of mine (from
/Library/LaunchDaemons/org.postgresql.postgres.v824.plist). Note that if
you use one of the plist launchd configuration editors out there you'll
probably lose the comments when you save.
Hope this helps.
Michael Glaesemann
grzm seespotcode net
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple Computer//DTD PLIST 1.0//EN"
"http://www.apple.com/DTDs/PropertyList-1.0.dtd";>
<plist version="1.0">
<!--
This launchd.plist file is used by the launchd process (availabie on
Mac OS X 10.4 and later) to launch and shutdown a PostgreSQL server.
The launchd.plist is used instead of a StartupItem. For detailed
descriptions
of launchd parameters and launchd, refer to to the launchd.plist,
launchd, and
launchctl manpages.
launchd.plists are commonly named in a manner similar to preference
plist files,
so for consistency (and easy identification) launchd.plists for PostgreSQL
server instances should begin with org.postgresql.postgres. When running
multiple server instances on one machine, you may wish to distinguish
them. For
example, if one of your PostgreSQL servers is 8.0 and another 8.1, you
might
name the two launchd.plist files
org.postgresql.postgres.v80.plist
org.postgresql.postgres.v81.plist
Another alternative is to identify them by use. For example, when
running one
development server instance and a production server instance on the same
machine, you might name the two launchd.plist files
org.postgresql.postgres.dev.plist
org.postgresql.postgres.prod.plist
Note: While commments in launchd.plist files do not appear to interfere
with
launchd operation, editing and saving this file using Property List Manager
will *not* preserve comments (including these)!
-->
<dict>
<key>Label</key>
<!-- Set the Label parameter to a unique string identifying the
job to
launchd. This is commonly set to the naem of the
launchd.plist file
without the .plist extension.
-->
<string>org.postgresql.postgres.v824</string>
<key>OnDemand</key>
<false/>
<key>Disabled</key>
<!-- Set the OnDemand parameter to <true/> to prevent the server from
starting automatically on system start or when launched by
launchctl.
-->
<false/>
<key>ProgramArguments</key>
<!-- The elements of the ProgramArguments parameter array are the
command
line string used to start the server, exploded on white space. No
string should contain spaces.
The first element is the absolute path to the postmaster server
application binary, followed by the argments to be passed to the
postmaster server application. Add, delete, and update these
parameter strings as needed for your requirements. The example
includes
setting the database data directory (PGDATA) and sets the
redirect_stderr runtime parameter.
-->
<array>
<string>/usr/local/pgsql/pgsql-8.2.4/bin/postmaster</string>
<string>-D</string>
<string>/usr/local/pgsql/pgsql-8.2.4/data</string>
<string>-c</string>
<string>redirect_stderr=YES</string>
</array>
<key>ServiceDescription</key>
<!-- The ServiceDescription parameter is a human-readable string
to describe
the purpose of the service provided, in this case the
PostgreSQL dbms
server.
-->
<string>PostgreSQL Server v8.2.4</string>
<key>UserName</key>
<!-- Set the Username parameter string to the user who is to
owns the PostgreSQL
server process, typically "postgres".
-->
<string>postgres</string>
<key>GroupName</key>
<!-- Set the GroupName parameter to group of the user who is to
own the
PostgreSQL process, typically "postgres".
-->
<string>postgres</string>
</dict>
</plist>
=== COUNTER REPLY ===============================
Ralph Replies:
Thanks Michael.
But alas, auto-starting still doesn't work!
I renamed the file in the FORMERLY like-named DIR in
/Library/StartupItems/PostgreSQL to inactivate it.
Then I inserted your .plist text below into /Library/LaunchDaemons as
org.postgresql.postgres.v824.plist
Owner/Group root/wheel, 644 perms.
However... PostgreSQL still won't start at boot up!
In the system.log I get the errors you can see below.
Also there are my modifications to the .plist file -- to match my
install, and some debugging I added.
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
Or is startup too soon for these to help me here?
Thanks,
Ralph
---------------------------------------
Jul 30 17:11:40 swampmac lookupd[90]: lookupd (version 369.5) starting -
Mon Jul 30 17:11:40 2007
Jul 30 17:11:40 swampmac configd[52]: posting notification
com.apple.system.config.network_change
Jul 30 17:11:40 swampmac lookupd[91]: lookupd (version 369.5) starting -
Mon Jul 30 17:11:40 2007
Jul 30 17:11:40 swampmac configd[52]: setting hostname to
"swampmac.eplt.washington.edu"
Jul 30 17:11:40 swampmac loginwindow[83]: Login Window Started Security
Agent
Jul 30 17:11:42 swampmac
/System/Library/CoreServices/mcxd.app/Contents/MacOS/mcxd: DSOpenNode():
dsOpenDirNode("/Active Directory/All Domains") == -14002
Jul 30 17:11:43 swampmac configd[52]: target=enable-network: disabled
Jul 30 17:11:43 swampmac launchd: org.postgresql.postgres.v824: exited
with exit code: 1
Jul 30 17:11:43 swampmac launchd: org.postgresql.postgres.v824:
respawning too quickly! throttling
Jul 30 17:11:43 swampmac launchd: org.postgresql.postgres.v824: 8 more
failures without living at least 60 seconds will cause job removal
Jul 30 17:11:43 swampmac launchd: org.postgresql.postgres.v824: will
restart in 10 seconds
Jul 30 17:11:44 swampmac VersionCueCS2Daemon[198]: warning:
VersionCueCS2Daemon not started by mach_init process (parent pid: 1)
Jul 30 17:11:45 swampmac configd[52]: AppleTalk startup complete
Jul 30 17:11:53 swampmac launchd: org.postgresql.postgres.v824: exited
with exit code: 1
Jul 30 17:11:53 swampmac launchd: org.postgresql.postgres.v824:
respawning too quickly! throttling
Jul 30 17:11:53 swampmac launchd: org.postgresql.postgres.v824: 7 more
failures without living at least 60 seconds will cause job removal
Jul 30 17:11:53 swampmac launchd: org.postgresql.postgres.v824: will
restart in 10 seconds
Modifications to the .plist file:
<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>
===============================================
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
