| From: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
|---|---|
| To: | Toby Corkindale <toby(dot)corkindale(at)strategicdata(dot)com(dot)au> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: (replication) Detecting if server a slave, or a master in recovery |
| Date: | 2011-09-12 07:27:34 |
| Message-ID: | CA+U5nMLdNmzxNR_55Dw_pYkAHQYnjiuU_zAWAXAA+BZ7WqhnFQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Sep 12, 2011 at 8:19 AM, Toby Corkindale
<toby(dot)corkindale(at)strategicdata(dot)com(dot)au> 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.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Toby Corkindale | 2011-09-12 07:32:36 | Re: (replication) Detecting if server a slave, or a master in recovery |
| Previous Message | Toby Corkindale | 2011-09-12 07:19:34 | Re: (replication) Detecting if server a slave, or a master in recovery |