On Fri, Jul 20, 2012 at 1:02 AM, David Kerr <d...@mr-paradox.net> wrote:
> I was looking into this last month and some nice folks on the list pointed me
> to this formula
> for calculating lag. (to be run on the slave) similar to what Sergey said.
>
> when pg_last_xlog_receive_location() = pg_last_xlog_replay_location()
> then 0
> else extract ('epoch' from now()-pg_last_xact_replay_timestamp()) end
> as log_delay;
If you have a connection problem this will not reflect the situation.
--
Sergey Konoplev
a database architect, software developer at PostgreSQL-Consulting.com
http://www.postgresql-consulting.com
Jabber: gray...@gmail.com Skype: gray-hemp Phone: +79160686204
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
