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 [EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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
---------------------------(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
