Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 2CD871D012E9 for ; Fri, 3 Feb 2012 03:10:48 -0400 (AST) Received: from sd-17937.dedibox.fr ([88.191.100.74]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1RtDIE-00045d-5Y for pgsql-admin@postgresql.org; Fri, 03 Feb 2012 07:10:48 +0000 Received: from [192.168.10.3] (AMontsouris-552-1-48-181.w92-140.abo.wanadoo.fr [92.140.87.181]) by sd-17937.dedibox.fr (Postfix) with ESMTPA id 1303F3B92D; Fri, 3 Feb 2012 08:10:33 +0100 (CET) Message-ID: <1328253032.2186.1.camel@localhost.localdomain> Subject: Re: Getting master host info from a slave From: Guillaume Lelarge To: Mario Splivalo Cc: "pgsql-admin@postgresql.org" Date: Fri, 03 Feb 2012 08:10:32 +0100 In-Reply-To: <4F2AA046.7010402@megafon.hr> References: <4F2AA046.7010402@megafon.hr> Content-Type: text/plain; charset="UTF-8" X-Mailer: Evolution 3.2.3 (3.2.3-1.fc16) Content-Transfer-Encoding: 7bit Mime-Version: 1.0 X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201202/11 X-Sequence-Number: 39071 On Thu, 2012-02-02 at 15:40 +0100, Mario Splivalo wrote: > How can I get the master server host data from a running slave, without > reading recovery.conf file? > > I've tried with SHOW, but that just gives me: > > postgres=# show primary_conninfo; > ERROR: unrecognized configuration parameter "primary_conninfo" > Unfortunately, right now, you can't. You have to read the file. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com PostgreSQL Sessions #3: http://www.postgresql-sessions.org