Determining database status - Mailing list pgsql-novice

From Michael Lush
Subject Determining database status
Date
Msg-id Pine.LNX.4.64.0911031651070.30692@pigeon.ebi.ac.uk
Whole thread Raw
List pgsql-novice
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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

pgsql-novice by date:

Previous
From: Richard Broersma
Date:
Subject: Re: Bug - DatabaseMetaData.getCatalogs() was [Novice] Can't get list of databases with \list
Next
From: Greg Stark
Date:
Subject: Re: corrupt db