pg_standby: How to check in which state the server is currently?

From: Frank Lanitz <frank(at)frank(dot)uvena(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_standby: How to check in which state the server is currently?
Date: 2011-12-05 11:16:29
Message-ID: 4EDCA80D.8020701@frank.uvena.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi list,

We had in past from time to time the issue, that the standby server is
stopping recovering, creating a new timeline and become up and running.
In parallel to check for the reasons of this behavior we are looking for
a clean way to check whether warm standby database is still in
recovering mode or has become ready. I did some search, but didn't found
any ready-2-use script for doing this on a stand alone basis (should
only be temp. solution that will be replaced by real monitoring later)
I looked for some solution checking ps for pg_standby and trying to
connect to database. But I'm not sure how 'secure' in terms of falls
positive and missed events this is.

Can anybody put me onto the right way here?

Cheers,
Frank

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2011-12-05 11:25:09 Re: What's the best way in Postgres9 to store a bunch of arbitrary boolean values for a row?
Previous Message Cédric Villemain 2011-12-05 10:54:32 Re: What's the best way in Postgres9 to store a bunch of arbitrary boolean values for a row?