I can answer your first question. The way I check the replication delay is
by running this query on the replication server:
*SELECT now() - pg_last_xact_replay_timestamp();*
Of course you need to configure hot standby replication, which you should
if you are not.
Regards,
Strahinja
On Tue, Apr
We recently moved to PG 9.2.4 (from 8.4.4) to take advantage of replication,
and I have to say it's pretty awesome.
I ran into some things that I was hoping someone could clarify.
a) There appears to be no way to tell how "far behind" my standby servers are.
That is, I can find a checkpoint
