Re: Feature Request: pg_replication_master()

On Dec 19, 2012 4:43 AM, "Josh Berkus" <josh(at)agliodbs(dot)com> wrote:
>
> Hackers,
>
> Currently we can see each master's current replicas using
> pg_stat_replication. However, there is no way from a replica, that I
> know of, to figure out who its master is other than to look at
> recovery.conf.
>
> We should probably have a function, like pg_replication_master(), which
> gives the host address of the current master. This would help DBAs for
> large replication clusters a lot. Obviously, this would only work in
> streaming.

This sounds like my previous suggestion of returning the primary conninfo
value, but with just ip. That one came with a pretty bad patch, and was
later postponed until we folded recovery.conf into the main configuration
file parsing. I'm not really sure what happened to that project? (the
configuration file one)

/Magnus