Le 14/10/2010 23:18, Rudolf van der Leeden a écrit : > [...] > quick question to the PG 9 community. > > I can query a hot standby server if recovery is still active using > the administration function pg_is_in_recovery(). Is there also a way > to query for the 'primary server', i.e. which server is delivering > the WAL records? > > I'd like to monitor a bunch of standby servers in terms of > configuration and operation. > There's no "SQL" way to know this, AFAICT. But I would love to be proven wrong: I would be able to add this info to pgAdmin, which would be great. -- Guillaume http://www.postgresql.fr http://dalibo.com -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
