Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1b9C9R-0008BA-IS for pgsql-general@arkaria.postgresql.org; Sat, 04 Jun 2016 14:02:09 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1b9C9R-00046T-5A for pgsql-general@arkaria.postgresql.org; Sat, 04 Jun 2016 14:02:09 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1b9C78-0000Ub-Du for pgsql-general@postgresql.org; Sat, 04 Jun 2016 13:59:46 +0000 Received: from fr1.2ndquadrant.fr ([2001:41d0:2:127c::1]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1b9C75-0005Pi-PN for pgsql-general@postgresql.org; Sat, 04 Jun 2016 13:59:45 +0000 Received: from localhost (localhost.localdomain [127.0.0.1]) by fr1.2ndquadrant.fr (Postfix) with ESMTP id 79E7D60DA6; Sat, 4 Jun 2016 15:59:42 +0200 (CEST) X-Virus-Scanned: Debian amavisd-new at fr1.2ndquadrant.fr Received: from fr1.2ndquadrant.fr ([127.0.0.1]) by localhost (fr1.2ndquadrant.fr [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id uV0HM9MC-dIA; Sat, 4 Jun 2016 15:59:41 +0200 (CEST) Received: from [192.168.0.3] (ath91-3-88-167-161-184.fbx.proxad.net [88.167.161.184]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) (Authenticated sender: charles) by fr1.2ndquadrant.fr (Postfix) with ESMTPSA id C8A76608FB; Sat, 4 Jun 2016 15:59:40 +0200 (CEST) Subject: Re: Replication To: John R Pierce , pgsql-general@postgresql.org References: From: Vik Fearing Message-ID: <5752DECC.1010703@2ndquadrant.fr> Date: Sat, 4 Jun 2016 15:59:40 +0200 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101 Thunderbird/38.8.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -3.3 (---) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-general Precedence: bulk Sender: pgsql-general-owner@postgresql.org 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general