Re: Re: starting PGSQL automatically on Redhat 6.2

From: T F <torford(at)hotmail(dot)nospam(dot)com>
Subject: [GENERAL] Re: starting PGSQL automatically on Redhat 6.2
Date: Tue, 09 Jan 2001 12:12:52 -0700
Message-ID: <3A5B62B4(dot)C73124BE(at)hotmail(dot)nospam(dot)com>

> 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!
> >
> > Ryan Mahoney
> > ryan(at)paymentalliance(dot)net
>
> You might try this, it was taken from the postgresql-6.5.3-6 rpm:
>
>

That script seems dangerous. It calls

killproc postmaster

to terminate postmaster. In this case killproc firstly sends SIGTERM
to postmaster (this is ok). But if postmaster won't die with the
signal, then killproc sends SIGKILL to postmaster (this is not
good). SIGINT or SIGQUIT should be sent in this case.

BTW, pg_ctl only works with version 7.0 or higher.
--
Tatsuo Ishii