On Dec 19, 2012 4:43 AM, "Josh Berkus" <j...@agliodbs.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