On Thu, 2 Jun 2016, 10:34 p.m. Scott Mead, <sco...@openscg.com> wrote:
> 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. > 9.6 onward you will have a new view which will facilitate you to query the replication details on standby. I have not tried but probably you can check the pid of wal receiver and find out what host it is connected to (should be possible from network stats). > --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 > -- -- Best Regards Sameer Kumar | DB Solution Architect *ASHNIK PTE. LTD.* 101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533 T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com
