Re: How to run PostgreSQL on boot?

2003-09-01 Thread Jonathan Chen
On Mon, Sep 01, 2003 at 06:21:12PM +0300, Alex Zivenko wrote:
> Hi all!
> I need to run Postgresql server on startup. It means, that I need to start 
> postmaster every boot. How can I do this?

If you installed via the ports-system, it installs:

/usr/local/etc/rc/010.pgsql.sh

which starts up postgresql on boot.
-- 
Jonathan Chen <[EMAIL PROTECTED]>
--
"Only the meek get pinched. The bold survive."
  - Ferris Bueller
___
[EMAIL PROTECTED] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "[EMAIL PROTECTED]"


Re: How to run PostgreSQL on boot?

2003-09-01 Thread David Landgren
Alex Zivenko wrote:
Hi all!
I need to run Postgresql server on startup. It means, that I need to start postmaster 
every boot. How can I do this?
Sorry for my english.
I have the following file on the servers that run Postgresql, named 
/usr/local/etc/rc.d/postgresql.sh:

#! /bin/sh

su postgres -c '/home/pgsql/bin/pg_ctl start \
  -D /home/pgsql/data -l /var/log/postgresql'
You will probably have to change paths etc. to suit your site, but 
this is the general idea.

David

___
[EMAIL PROTECTED] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "[EMAIL PROTECTED]"