On 02/06/16 18:39, John R Pierce wrote: > On 6/2/2016 6:32 AM, Bertrand Paquet wrote: >> 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. > > "The IP" assumes there is only one... hosts can be multihomed, > postgres can be listening on numerous interfaces, there is no 'the IP' That's nice, but a standby is only connecting to one. -- Vik Fearing +33 6 46 75 15 36 http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
