Re: Mac OS 10.3.4: pgsql fails to launch at boot

probably the scripts kicks in too early because the
"StartupParameters.plist" file is not correct

here's mine
---------------
{
Description = "PostGreSQL RDBMS";
Provides = ("PostGreSQL");
Requires = ("Network", "Resolver");
Uses = ("Network Time", "NFS");
OrderPreference = "Last";
Messages =
{
start = "Starting PostGreSQL Services";
stop = "Stopping PostGreSQL Services";
};
}
---------------

and for completeness here is the SystemStarter script

-----------
#!/bin/sh

startPG ()
{
sudo -u pgsql /usr/local/pgsql/bin/pg_ctl start -D
/usr/local/pgsql/data -l /var/log/postgres/postgres.log -o -i

/bin/sleep 1 # Just for flashing the note
}

stopPG ()
{
/usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data stop
}

if /bin/test "$1" = "start"
then
startPG
elif /bin/test "$1" = "stop"
then
stopPG
fi
-----------
may be is not the best system posible but it works well in several tens
of servers now

On Jun 7, 2004, at 7:49 PM, Randall Perry wrote:

> on 6/7/04 12:57 PM, Jeff Self at jself(at)nngov(dot)com wrote:
>
>> On Mon, 2004-06-07 at 10:28, Randall Perry wrote:
>>> On searching the archives I noticed Bob Smith in Jul, 2002 had a
>>> similar
>>> problem to mine, but never posted a solution.
>>>
>>> I'm using pgsql 7.4.2 on Mac OS 10.3.4. I installed the startup
>>> script for
>>> darwin from the contrib/start-scripts folder. On boot, pgsql startup
>>> fails
>>> and I see this error in the pgsql logfile:
>>>
>>> bootstrap_look_up() failed (ipc/send) invalid destination port
>>>
>>> After the machine has booted the same startup script works fine.
>>>
>>> This appears to be a Mac OS issue. If anyone has any clue what's
>>> going on
>>> please let me know.
>>>
>>> I've gotten around the problem right now by putting a call to the
>>> startup
>>> script directly in /etc/rc, as the last command.
>>
>> I've never run into this myself. Did you install from source or use
>> Mark Liyanage's package? His package is at
>> http://www.entropy.ch/software/macosx/postgresql/
>>
>> Very easy installation if you're willing to start over.
>
> I've been rolling my own PostgreSQL for quite a while. AFICT there's
> nothing
> wrong with the installation; there's just something wrong with
> SystemStarter
> and pgsql.
>
> --
> Randall Perry
> sysTame
>
> Xserve Web Hosting/Co-location
> Website Development/Promotion
> Mac Consulting/Sales
>
> http://www.systame.com/
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
>
Pax et Bonum

# dott. Jose' Cruanyes Aguilar - C.E. Soft srl
# Pzza. Firenze,4 MILANO - XX Settembre 10, CREMONA
# 02,33603122 0372,460602