On Jul 31, 2007, at 3:27 PM, Ralph Smith wrote:
How come shutdown isn't clearing things up?
Or is the problem in the startup?
There is a small package you can download from this page which will
install in StartupItems and handle things correctly:
http://www.entropy.ch/software/macosx/postgresql/
Direct link:
http://www2.entropy.ch/download/pgsql-startupitem-1.2.pkg.tar.gz
I have also included the script below.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
======
#!/bin/sh
. /etc/rc.common
##
# Start up the PostgreSQL database server on Mac OS X / Darwin
#
#
# History
# -------
#
# 2002-08-21 Marc Liyanage <liyanage@xxxxxxxxx>
# Changed startup to use pg_ctl
#
# 2002-08-19 Ed Silva <ed@xxxxxxxxxxxx>
# Modified startup script to conform
# to new SystemStarter format for Mac OS X 10.2
#
# 2001-04-02 Marc Liyanage <liyanage@xxxxxxxxx>
# First version
#
# 2001-12-02 Johan Henselmans <johanhenselmans@xxxxxxx>
# Enhanced after carefully studying the Frontbase
# startup sequence ;-)
# Now provides a stop procedure for a graceful shutdown
# and a hard kill if the clean shutdown doesn't work.
#
# 2001-12-02 Marc Liyanage <liyanage@xxxxxxxxx>
# Added localized startup messages in 7 languages
# by adapting the resources of the Apple-supplied
# "Sendmail" startup script.
#
#
# License
# -------
#
# The PostgreSQL BSD-style license applies to this file
#
StartService ()
{
if [ "${POSTGRES:=-YES-}" = "-YES-" ]; then
ConsoleMessage "Starting PostgreSQL database server"
su - postgres -c '/usr/local/bin/pg_ctl start -D /usr/local/
pgsql/data -l /usr/local/pgsql/logfile -o -i'
fi
}
StopService()
{
ConsoleMessage "Stopping PostgreSQL database services"
/usr/local/bin/pg_ctl stop -D /usr/local/pgsql/data
x=`/bin/ps axc | /usr/bin/grep postgres`
if /bin/test "$x"
then
set $x
kill -9 $x
fi
}
RestartService ()
{
StopService
StartService
}
RunService "$1"
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
