Re: Re: starting PGSQL automatically on Redhat 6.2

I'm actaully trying to get 7.1b to start automatically, still no success,
but I'm making progres.

Trying to modify the pg_ctl that comes with 7.1 to add the su - postgres -c
....

-Ryan

Tatsuo Ishii wrote in message <20010110111111X(dot)t-ishii(at)sra(dot)co(dot)jp>...
>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