Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group