From: | Vik Fearing <vik(at)2ndquadrant(dot)fr> |
---|---|
To: | John R Pierce <pierce(at)hogranch(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Replication |
Date: | 2016-06-04 13:59:40 |
Message-ID: | 5752DECC.1010703@2ndquadrant.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 02/06/16 18:39, John R Pierce wrote:
> On 6/2/2016 6:32 AM, Bertrand Paquet wrote:
>> On an hot standby streaming server, is there any way to know, in SQL,
>> to know the ip of current master ?
>> The solution I have is to read the recovery.conf file to find
>> primary_conninfo, but, it can be false.
>
> "The IP" assumes there is only one... hosts can be multihomed,
> postgres can be listening on numerous interfaces, there is no 'the IP'
That's nice, but a standby is only connecting to one.
--
Vik Fearing +33 6 46 75 15 36
http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support
From | Date | Subject | |
---|---|---|---|
Next Message | Vik Fearing | 2016-06-04 14:06:20 | Re: Partitioned tables do not return affected row counts to client |
Previous Message | Vik Fearing | 2016-06-04 13:58:02 | Re: Replication |