From: yhe <yinghe0101@yahoo.com>
To: pgsql-admin@postgresql.org
Subject: strem replication standby lag check
Date: Fri, 17 Jan 2014 11:16:55 -0800 (PST)
Message-ID: <1389986215594-5787682.post@n5.nabble.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
hi, all,
I know we can connect to primary and SELECT pg_current_xlog_location(); (eg.
'0/36A77900') to get primary xlog position then connect to the standby to do
the following to get the byte lag:
select pg_xlog_location_diff('0/36A77900',pg_last_xlog_replay_location());
0/36A77900 is the xlog position from primary.
My question is that is there a way I can connect to the primary on the
standby host using replica user which i already have the primary_conninfo in
the recovery.conf and get the result of SELECT pg_current_xlog_location();
of the primary so I can simply write a function on the standby to return the
lag in bytes in one call.
any way I can do that without a dblink?
Thank you if any one can help.
best,
Ying
--
View this message in context: http://postgresql.1045698.n5.nabble.com/strem-replication-standby-lag-check-tp5787682.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: yinghe0101@yahoo.com
Subject: Re: strem replication standby lag check
In-Reply-To: <1389986215594-5787682.post@n5.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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