Re: [GENERAL] Streaming Recovery - Automated Monitoring - CODE LINK

2010-10-03 Thread Karl Denninger
On 10/3/2010 3:44 PM, Karl Denninger wrote: > On 10/3/2010 1:34 AM, Guillaume Lelarge wrote: >> Le 03/10/2010 07:07, Karl Denninger a écrit : >>> On 10/2/2010 11:40 PM, Rajesh Kumar Mallah wrote: I hope u checked point #11 http://wiki.postgresql.org/wiki/Streaming_Replication#How_to_U

Re: [GENERAL] Streaming Recovery - Automated Monitoring

2010-10-03 Thread Karl Denninger
On 10/3/2010 1:34 AM, Guillaume Lelarge wrote: > Le 03/10/2010 07:07, Karl Denninger a écrit : >> On 10/2/2010 11:40 PM, Rajesh Kumar Mallah wrote: >>> I hope u checked point #11 >>> http://wiki.postgresql.org/wiki/Streaming_Replication#How_to_Use >>> >>> * *11.* You can calculate the replic

Re: [GENERAL] Streaming Recovery - Automated Monitoring

2010-10-02 Thread Guillaume Lelarge
Le 03/10/2010 07:07, Karl Denninger a écrit : > On 10/2/2010 11:40 PM, Rajesh Kumar Mallah wrote: >> >> I hope u checked point #11 >> http://wiki.postgresql.org/wiki/Streaming_Replication#How_to_Use >> >> * *11.* You can calculate the replication lag by comparing the >> current WAL writ

Re: [GENERAL] Streaming Recovery - Automated Monitoring

2010-10-02 Thread Magnus Hagander
On Sun, Oct 3, 2010 at 07:07, Karl Denninger wrote: > Now how do I get an arithmetic difference between the two?  There will > (usually) be a small difference between the master and slave on a busy > system - what I want to do is query both and if the difference in their > locations is greater tha

Re: [GENERAL] Streaming Recovery - Automated Monitoring

2010-10-02 Thread Karl Denninger
On 10/2/2010 11:40 PM, Rajesh Kumar Mallah wrote: > > I hope u checked point #11 > http://wiki.postgresql.org/wiki/Streaming_Replication#How_to_Use > > * *11.* You can calculate the replication lag by comparing the > current WAL write location on the primary with the last WAL > lo

Re: [GENERAL] Streaming Recovery - Automated Monitoring

2010-10-02 Thread Rajesh Kumar Mallah
I hope u checked point #11 http://wiki.postgresql.org/wiki/Streaming_Replication#How_to_Use - *11.* You can calculate the replication lag by comparing the current WAL write location on the primary with the last WAL location received/replayed by the standby. They can be retrieved using *