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