pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Getting master host info from a slave
2+ messages / 2 participants
[nested] [flat]

* Getting master host info from a slave
@ 2012-02-02 14:40 Mario Splivalo <mario.splivalo@megafon.hr>
  2012-02-03 07:10 ` Re: Getting master host info from a slave Guillaume Lelarge <guillaume@lelarge.info>
  0 siblings, 1 reply; 2+ messages in thread

From: Mario Splivalo @ 2012-02-02 14:40 UTC (permalink / raw)
  To: 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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Getting master host info from a slave
  2012-02-02 14:40 Getting master host info from a slave Mario Splivalo <mario.splivalo@megafon.hr>
@ 2012-02-03 07:10 ` Guillaume Lelarge <guillaume@lelarge.info>
  0 siblings, 0 replies; 2+ messages in thread

From: Guillaume Lelarge @ 2012-02-03 07:10 UTC (permalink / raw)
  To: Mario Splivalo <mario.splivalo@megafon.hr>; +Cc: 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




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2012-02-03 07:10 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-02-02 14:40 Getting master host info from a slave Mario Splivalo <mario.splivalo@megafon.hr>
2012-02-03 07:10 ` Guillaume Lelarge <guillaume@lelarge.info>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox