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@genenames.org
European Bioinformatics Institute
Hinxton, Cambridge
URL: http://www.genenames.org
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~