Re: (replication) Detecting if server a slave, or a master in recovery

On 12/09/11 17:27, Simon Riggs wrote:
> On Mon, Sep 12, 2011 at 8:19 AM, Toby Corkindale
> <toby.corkindale@strategicdata.com.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.


aaah.. Thanks! I didn't realise that.

Thanks for your help.

-Toby