How to run PostgreSQL on boot?

[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