Re: 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 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