On Thu, Jun 2, 2016 at 10:16 AM, Melvin Davidson <melvin6...@gmail.com> wrote:
> It's been a few years since I worked with slony, and you did not state > which version of slony or PostgreSQL you are working with, nor did you > indicate the O/S. > I think OP had pointed to using streaming.... > That being said, you should be able to formulate a query with a join > between sl_path & sl_node that gives you the information you need. > > On Thu, Jun 2, 2016 at 9:32 AM, Bertrand Paquet < > bertrand.paq...@doctolib.fr> wrote: > >> Hi, >> >> 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. >> >> I've run into this as well. Only way is recovery.conf. --Scott > Regards, >> >> Bertrand >> > > > > -- > *Melvin Davidson* > I reserve the right to fantasize. Whether or not you > wish to share my fantasy is entirely up to you. > -- -- Scott Mead Sr. Architect *OpenSCG <http://openscg.com>* http://openscg.com