Re: starting PGSQL automatically on Redhat 6.2

On Tue, 9 Jan 2001, Ryan Mahoney wrote:

> Hey all, I copied the pg_ctl script and placed it in my /etc/rc.d/init.d/
> directory and renamed it 'postgres'. I then made all the necessary symbolic
> links. When my machine boots up however, pgsql does not start up because it
> cannot be started by root. I have created the 'postgres' user and data
> directories. I can start PG manually just fine. Can someone post or mail a
> working startup script/recommend any changes to pg_ctl? Thanks!

You need to su to the postgres user in your script to start the
postmaster:

su postgres -c "postmaster -i ... "

There's a complete example in the installation docs.

-- Brett
http://www.chapelperilous.net/~bmccoy/
---------------------------------------------------------------------------
History is the version of past events that people have decided to agree on.
-- Napoleon Bonaparte, "Maxims"