| From: | Michael Lush <mjlush(at)ebi(dot)ac(dot)uk> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Determining database status |
| Date: | 2009-11-03 17:04:49 |
| Message-ID: | Pine.LNX.4.64.0911031651070.30692@pigeon.ebi.ac.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)genenames(dot)org
European Bioinformatics Institute
Hinxton, Cambridge
URL: http://www.genenames.org
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Broersma | 2009-11-03 17:36:56 | Bug - DatabaseMetaData.getCatalogs() was [Novice] Can't get list of databases with \list |
| Previous Message | A. Kretschmer | 2009-11-03 06:22:40 | Re: GETTING INFO FROM SEQUENCE OBJECTS |