Discussion:
[ADMIN] Getting master host info from a slave
(too old to reply)
Mario Splivalo
2012-02-02 14:40:06 UTC
Permalink
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
--
Sent via pgsql-admin mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Guillaume Lelarge
2012-02-03 07:10:32 UTC
Permalink
Post by Mario Splivalo
How can I get the master server host data from a running slave, without
reading recovery.conf file?
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
--
Sent via pgsql-admin mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Loading...