Re: Re: starting PGSQL automatically on Redhat 6.2

On Wed, Jan 10, 2001 at 12:17:23PM -0000, Ryan Mahoney wrote:
> 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

I added the following to the postgres account's .profile:

export PGDATA=${HOME}/data

I then had to use the following in my startup script:

su - postgres -- --login -c "pg_ctl -o -S start"

su - postgres -- --login -c "pg_ctl stop"

The reason for the --login is that the bash/gnu-su combination is broken (IMO)
wrt to sourcing .profile when ran from su.

mrc
--
Mike Castle Life is like a clock: You can work constantly
dalgoda(at)ix(dot)netcom(dot)com and be right all the time, or not work at all
www.netcom.com/~dalgoda/ and be right at least twice a day. -- mrc
We are all of us living in the shadow of Manhattan. -- Watchmen