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 versions (as you might suspect, they've been rather dynamic of late ...) are:
% vi /Library/StartupItems/PostgreSQL/PostgreSQL ------------------------------------------ #!/bin/sh
. /etc/rc.common
StartService () {
if [ "${POSTGRESQL:=-NO-}" = "-YES-" ]; then
ConsoleMessage "Starting PgSQL"
if [ -f /var/run/postgresql.pid ]; then
ConsoleMessage "clearing PgSQL PIDfile"
rm -f /var/run/postgresql.pid
fi
sudo -u testuser sh -c "/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 2>&1
fi }
StopService () {
ConsoleMessage "Stopping PgSQL"
sudo -u testuser $POSTGRE_DAEMON stop -D /var/data/pgsql -s -m fast
}RestartService ()
{
if [ "${POSTGRESQL:=-NO-}" = "-YES-" ]; then
ConsoleMessage "Restarting PgSQL"
sudo -u testuser /usr/local/pgsql/bin/pg_ctl restart -D /var/data/pgsql -s -m fast
else
StopService
fi
}
RunService "$1" ------------------------------------------
and,
%vi /Library/StartupItems/PostgreSQL/StartupParameters.plist
------------------------------------------
{
Description = "PgSQL DatabaseServer";
Provides = ("PgSQL", "DatabaseServer");
Requires = ("Disks", "Resolver");
Uses = ("NFS", "NetworkTime");
OrderPreference = "Late";
Messages =
{
start = "Starting PgSQL";
stop = "Stopping PgSQL";
};
}
------------------------------------------
where, of course % vi /etc/hostconfig ------------------------------------------ +++ POSTGRESQL=-YES- ------------------------------------------
In particular, I was wondering if the problem could be related to launching the postmaster in advance of some system service it needs; without seeing the Requires/Uses specs you gave, there's no way to know what might have happened.
i've had that issue in the past ... primarily related to partitions with DIRs symlinked elsewhere not spinning up fast enuf.
long story short, i took care of it (chats on the Apple kernle board) and hasn't been an issue since ...
BTW, that page also references this Apple document saying that StartupItems are being obsoleted: http://developer.apple.com/documentation/macosx/Conceptual/BPSystemStartup/Co ncepts/BootProcess.html#//apple_ref/doc/uid/20002130/CJBBICAB However, they should still work as of 10.3.*, so that's just an interesting tidbit for the future.
yeah, yeah ;-) everything under xinetd, eventually ...
one thing at a time -- i'm running outa beer here!
cheers,
richard
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
