|| at Nov 9, 2009 at 9:58 am
On Sun, 8 Nov 2009, raghu ram wrote:
On Sun, Nov 1, 2009 at 4:31 PM, Victor Jason wrote:
Many times after I start the db (/etc/init.d/postgresql), the second I
access it I get
*"FATAL: the database system is starting up"*
Is there a natural way (any cli command or other) to check with the DB if
it's still starting up or it is ready?
you can check the status of the database using the pg_ctl utility.
pg_ctl -D <data directory path> status
I have the same problem as Victor
In my hands pg_ctl status just gives me
"pg_ctl: server is running (PID: 26644)"
The only way I know is to attempt to login to the database which
generates that scary error :-}
I'd also like to know if there was a better/nicer/proper way to determine
if the database was starting up
Michael John Lush PhD Tel:44-1223 492626
HUGO Gene Nomenclature Committee Email: email@example.com
European Bioinformatics Institute