From: Guillaume Lelarge <guillaume@lelarge.info>
To: Mario Splivalo <mario.splivalo@megafon.hr>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Getting master host info from a slave
Date: Fri, 03 Feb 2012 08:10:32 +0100
Message-ID: <1328253032.2186.1.camel@localhost.localdomain> (raw)
In-Reply-To: <4F2AA046.7010402@megafon.hr>
References: <4F2AA046.7010402@megafon.hr>
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.infohttp://www.dalibo.com
PostgreSQL Sessions #3: http://www.postgresql-sessions.org
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: guillaume@lelarge.info, mario.splivalo@megafon.hr
Subject: Re: Getting master host info from a slave
In-Reply-To: <1328253032.2186.1.camel@localhost.localdomain>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox