Postgres Pro
Downloads
Home   >   mailing lists

Re: Master ip from hot_standby.. - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: Master ip from hot_standby..
Date
Msg-id CAB7nPqSp1R4iXyDLAXtTjpSdRs-XzLbqdjcwonn6nomaV0d7-g@mail.gmail.com
Whole thread Raw
In response to Master ip from hot_standby..  (sudalai <sudalait2@gmail.com>)
List pgsql-hackers
Tree view 
On Mon, Oct 27, 2014 at 8:15 PM, sudalai <sudalait2@gmail.com> wrote:
>    I need to query master ip from hot_standby.
> *pg_stat_replication*  view only shows the slave replication status.
>
> Is there any way to get *Master IP* from standby node apart from checking
> *recovery.conf* file.
That's the way to go as it is in primary_conninfo. Recovery parameters
are only loaded by the startup process after reading it from
recovery.conf.

Note that this would be more a question for pgsql-general or
pgsql-novice but surely not hackers.
-- 
Michael

pgsql-hackers by date:

Previous
From: "Tomas Vondra"
Date:
Subject: Re: proposal: CREATE DATABASE vs. (partial) CHECKPOINT
Next
From: Michael Paquier
Date:
Subject: Re: Dynamically change Master(recovery info) without restarting standby server..