Re: Getting master host info from a slave

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Mario Splivalo <mario(dot)splivalo(at)megafon(dot)hr>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Getting master host info from a slave
Date: 2012-02-03 07:10:32
Message-ID: 1328253032.2186.1.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message girish R G peetle 2012-02-03 10:36:42 Postges 9.0 WAL SEGEMENT SIZE is 128 GB for default server configuration.
Previous Message arokyzxc 2012-02-03 04:52:10 build postgresql problem