Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 5C8EC1EC5BE4 for ; Thu, 2 Feb 2012 10:43:10 -0400 (AST) Received: from out1.mail.amis.hr ([188.129.0.4]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1RsxsT-0003ZY-Tl for pgsql-admin@postgresql.org; Thu, 02 Feb 2012 14:43:10 +0000 Received: from out.fsec.sm.srv.amis.hr (out.fsec.sm.srv.amis.hr [192.168.106.22]) by out1.mail.amis.hr (Postfix) with ESMTP id 20CCB1FE05 for ; Thu, 2 Feb 2012 15:42:57 +0100 (CET) Received: from pps.filterd (out [127.0.0.1]) by out.fsec.sm.srv.amis.hr (8.14.3/8.14.3) with SMTP id q12EXOEj005482 for ; Thu, 2 Feb 2012 15:42:56 +0100 Received: from smtp.amis.hr (smtp.sm.srv.amis.hr [192.168.106.39]) by out.fsec.sm.srv.amis.hr with ESMTP id 12qufrr1tr-1 for ; Thu, 02 Feb 2012 15:42:56 +0100 A-Original-Client-UID: 188.129.73.29 splivalo Received: from [192.168.10.1] (cpe-188-129-73-29.dynamic.amis.hr [188.129.73.29]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) (Authenticated sender: splivalo) by smtp.amis.hr (Postfix) with ESMTPSA id B6363275 for ; Thu, 2 Feb 2012 15:42:56 +0100 (CET) Message-ID: <4F2AA046.7010402@megafon.hr> Date: Thu, 02 Feb 2012 15:40:06 +0100 From: Mario Splivalo User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:9.0) Gecko/20111220 Thunderbird/9.0 MIME-Version: 1.0 To: "pgsql-admin@postgresql.org" Subject: Getting master host info from a slave Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Proofpoint-Virus-Version: vendor=fsecure engine=2.50.10432:5.6.7361, 1.0.260, 0.0.0000 definitions=2012-02-02_06:2012-02-02, 2012-02-02, 1970-01-01 signatures=0 X-Proofpoint-Spam-Details: rule=notspam policy=default score=0 spamscore=0 ipscore=0 suspectscore=0 phishscore=0 bulkscore=0 adultscore=0 classifier=spam adjust=0 reason=mlx engine=6.0.2-1012030000 definitions=main-1202020114 X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201202/6 X-Sequence-Number: 39066 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" Mario