To all :
I am using Postgresql 7.4.1 (pgversion : 7.4). The database has been
configured properly but during startup and shutdown for which the
following scripts are entered
# <poweruser> database
echo "Starting <poweruser> Database"
PG<POWERUSER>="start -D /u/www/<poweruser>/db/data -o '-i -p
5233' -l /u/www/<poweruser>/log/dblog"
su -l <poweruser> -s /bin/sh -c "/usr/bin/pg_ctl $PG<POWERUSER>
> /dev/null 2>&1" < /dev/null
echo "Stopping <poweruser> Database"
su -l <poweruser> -s /bin/sh -c "/usr/bin/pg_ctl stop -D
/u/www/<poweruser>/db/data -s -m fast" > /dev/null 2>&1
However, once the machine is rebooted and I am logged in as the
<poweruser> and type in psql - I get the error that postmaster is not
running. Is there something else that should be here..
Please advise and thanks
pgsql-novice by date
|Next:||From: stm23||Date: 2004-03-12 03:07:30|
|Subject: setting up postgresql|
|Previous:||From: Tom Lane||Date: 2004-03-11 18:37:15|
|Subject: Re: Finding slow queries? |