Startup script

From: "Hari Bhanujan" <hbhanujan(at)sbcglobal(dot)net>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Startup script
Date: 2004-03-11 21:18:12
Message-ID: 000501c407ae$5cc959a0$0600a8c0@Bhanujan.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Start(){

# <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

}

stop(){

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
Hari

Browse pgsql-novice by date

  From Date Subject
Next Message stm23 2004-03-12 03:07:30 setting up postgresql
Previous Message Tom Lane 2004-03-11 18:37:15 Re: Finding slow queries?