On Jan 17, 2013, at 11:20 AM, Scott Whitney wrote:
> What I want to know is whether there's a situation in which my standby is
> running, the receiver process is running, but "something" is wrong.
I compare pg_controldata output from the two clusters periodically.
I've got replication setup (streaming replication) between two 9.2.2 clusters.
Everything went just fine on that, and it's working as expected.
Now, obviously, I'll know if my primary goes down. I just monitor him as usual.
How do I tell whether the standby has gone out of sync for whatever re
