[ADMIN] Replication monitoring questions

2013-01-17 Thread Scott Whitney
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: [ADMIN] Replication monitoring questions

2013-01-17 Thread Ray Stell
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.