Mac OS 10.3.4: pgsql fails to launch at boot

Discussion:

(too old to reply)

Randall Perry

2004-06-07 14:28:31 UTC

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.
--
Randall Perry
sysTame

Xserve Web Hosting/Co-location
Website Development/Promotion
Mac Consulting/Sales

http://www.systame.com/

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ***@postgresql.org

Jeff Self

2004-06-07 16:57:01 UTC

Permalink

Post by Randall Perry
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
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.
--
Jeff Self
Dept. of Information Technology
City of Newport News
757.926.3741

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ***@postgresql.org so that your
message can get through to the mailing list cleanly

Randall Perry

2004-06-07 17:49:08 UTC

Permalink

Post by Jeff Self

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 ***@postgresql.org so that your
message can get through to the mailing list cleanly

Jose' Cruanyes

2004-06-07 20:10:46 UTC

Permalink

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

Post by Randall Perry

Post by Jeff Self

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

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Kurt Watson

2004-06-12 23:53:54 UTC

Permalink

Post by Jose' Cruanyes
probably the scripts kicks in too early because the
"StartupParameters.plist" file is not correct

SNIP

Post by Jose' Cruanyes

SNIP

One related tip, maybe everyone already knows this. You can call
SystemStarter -nd to have SystemStarter run through in debug mode. This
is a pretty good way to see what is running when.
I agree with Jose Cruanyes, it's probably just the .plist preference for
launch order. I've seen "late" and "last" both used.

Good luck, please reply if that fixed it.