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@ix.netcom.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