Determining database status

View: New views
1 Messages — Rating Filter:   Alert me  

Determining database status

by Michael Lush-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message


Is there a proper way to determine if a postgres database (8.2) is in
recovery mode?  (I'm looking at making a backup database that updates
nightly (as a protection vs brainstorm) and want to shut it down when its
not in use)

pg_ctl status just says its running and psql creates a /scary/ FATAL
error :-)

--
Michael
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Michael John Lush PhD Tel:44-1223 492626
Bioinformatician
HUGO Gene Nomenclature Committee Email: hgnc@...
European Bioinformatics Institute
Hinxton, Cambridge
URL: http://www.genenames.org
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

--
Sent via pgsql-novice mailing list (pgsql-novice@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice