Getting master host info from a slave

Поиск
Список
Период
Сортировка
Искать

Getting master host info from a slave

От:
Mario Splivalo <mario.splivalo@megafon.hr>
Дата:
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

Re: Getting master host info from a slave

От:
Guillaume Lelarge <guillaume@lelarge.info>
Дата:
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

FAQ