| 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: | Whole Thread | Raw Message | 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 |