Skip site navigation (1) Skip section navigation (2)

Getting master host info from a slave

From: Mario Splivalo <mario(dot)splivalo(at)megafon(dot)hr>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Getting master host info from a slave
Date: 2012-02-02 14:40:06
Message-ID: 4F2AA046.7010402@megafon.hr (view raw or flat)
Thread:
Lists: pgsql-admin
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

Responses

pgsql-admin by date

Next:From: Mario SplivaloDate: 2012-02-02 16:15:58
Subject: Re: ssl3 errors in replication.
Previous:From: Mario SplivaloDate: 2012-02-02 07:36:35
Subject: ssl3 errors in replication.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group