On 12/09/11 17:27, Simon Riggs wrote:
On Mon, Sep 12, 2011 at 8:19 AM, Toby Corkindale
<toby.corkindale@xxxxxxxxxxxxxxxxxxxx> wrote:
On 12/09/11 17:13, Simon Riggs wrote:
On Mon, Sep 12, 2011 at 7:54 AM, Toby Corkindale
What is the best method for determining whether you're connected to the
master or slave database?
SELECT pg_is_in_recovery();
If I'm on a master database, which had previously crashed and is now in the
process of recovery, won't that also return "true" there?
No, because you can't connect to the database during crash recovery,
so the first time you can connect to a has-crashed master it will
return false.
aaah.. Thanks! I didn't realise that.
Thanks for your help.
-Toby
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
