Re: [GENERAL] Starting postmaster at boot

2000-09-14 Thread David Veatch

At 03:20 PM 9/14/00 -0400, Adam Lang wrote:
 >I'm still having difficulties getting postgres to start on boot.
 >
 >Any chance someone can give me an example of how they have it on their
 >system?
 >
 >
 >(Seemed to have been lost in the list being down).
 >
 >Adam Lang
 >Systems Engineer
 >Rutgers Casualty Insurance Company

Haven't done much looking into it for efficiency or anything like that, but 
here's what I have in my rc.local file (FreeBSD 3.2).  Hope it helps!


#!/bin/sh
[ -x /usr/local/pgsql/bin/postmaster ] && {
 su -l postgres -c 'exec /usr/local/pgsql/bin/postmaster -D 
/usr/local/pgsql/data -S -o -F -N 48 -B 96> /home/postgres/postgres.log' &
 echo -n ' postgres'
}

David Veatch - [EMAIL PROTECTED]

"Many people would sooner die than think.
In fact, they do." - Bertrand Russell




Re: [GENERAL] Starting postmaster at boot

2000-09-14 Thread David Veatch

At 03:31 PM 9/14/00 -0400, Adam Lang wrote:
 >Does it work the same for linux?

It's basic sh, so I can only assume that it does, though I should stress 
that I don't run Linux, and haven't sat at a Linux command prompt in over a 
year... so I can't say it does with 100% certainty.  The sh syntax should 
port, and if the Linux port of Postgres supports the same arguments as the 
FreeBSD port, then that should work as well...

David Veatch - [EMAIL PROTECTED]

"Many people would sooner die than think.
In fact, they do." - Bertrand Russell