Re: Default maximum time replication between master and slave databases

[Keith <keith@xxxxxxxxxxx>]

On Fri, Jul 10, 2015 at 10:23 AM, Alberto Olivares <alberto.olivares@xxxxxxxxxxxxxxxxxxxxx> wrote:

Thanks Guillaume,

maybe. I am trying to find the parameter that controls this value but I cannot find it. Last thing I tried was to modify the vacuum parameters on the slave but nothing changes.

Alberto Olivares Colas
Technical Consultant

Snowflake Software

Tel.: +44 (0)2380 386578

Email: alberto.olivares@xxxxxxxxxxxxxxxxxxxxx

Website: www.snowflakesoftware.com
Twitter: @sflakesoftware

Follow us on LinkedIn

Winner of IHS Jane's ATC Award - Enabling Technology

Read more

Registered in England & Wales. Registered Number: 4294244

-----------------------------------------------------------------------------------------

On 10 July 2015 at 15:11, Guillaume Lelarge <guillaume@xxxxxxxxxxxx> wrote:

Le 10 juil. 2015 4:07 PM, "Alberto Olivares" <alberto.olivares@xxxxxxxxxxxxxxxxxxxxx> a écrit :
>
> Hi,
>
> I don't have any write activity on the master, but still this value goes to 60 seconds and then restart constantly from 0 again . 
>

Well, you have. That might be autovacuum doing some vacuum or analyze without you noticing it.

--
Guillaume

Winner of IHS Jane's ATC Award - Enabling Technology

Read more

I still don't think you're understanding how replication works along with trying to use this function to monitor slave lag. I tried to give a good summary here.

http://www.keithf4.com/monitoring_streaming_slave_lag/