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