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
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.