Probably you will find pg_last_xact_replay_timestamp() interesting. It
returns the timestamp of the last transaction (when the transaction
was commited) that was replayed on slave.
http://www.postgresql.org/docs/9.1/static/functions-admin.html#FUNCTIONS-RECOVERY-INFO-TABLE
On Wed, Mar 14, 2012 at
Hi All,
I hope this is the correct mailing list to ask this question.
We are setting up a system using postgresql 9.1 and streaming
replication to copy reference data from a single central location to
several remote sites. The database changes will come in clumps with
long periods of no activity
