Re: Replication

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Replication
Date: 2016-06-02 16:39:07
Message-ID: d72df372-298a-6007-9b69-2ca5f3f0a312@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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'

--
john r pierce, recycling bits in santa cruz

In response to

  • Replication at 2016-06-02 13:32:32 from Bertrand Paquet

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Clark 2016-06-02 16:56:14 dumb question
Previous Message Sameer Kumar 2016-06-02 16:15:19 Re: WAL's listing in pg_xlog by some sql query