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"