Postgres Pro
Downloads
Home   >   mailing lists

Re: Getting master host info from a slave - Mailing list pgsql-admin

From Guillaume Lelarge
Subject Re: Getting master host info from a slave
Date
Msg-id 1328253032.2186.1.camel@localhost.localdomain
Whole thread Raw
In response to Getting master host info from a slave  (Mario Splivalo <mario.splivalo@megafon.hr>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: ssl3 errors in replication.
Next
From: Javier Reyes
Date:
Subject: Equivalent plpgsql trigger in C