Postgres Pro
Downloads
Home   >   mailing lists

Re: Default maximum time replication between master and slave databases - Mailing list pgsql-admin

From Alberto Olivares
Subject Re: Default maximum time replication between master and slave databases
Date
Msg-id CAGdoAziqCDZ0uizseGc5wE5Rq0KsPh7fvKbr6PDzhbcL+bh5HQ@mail.gmail.com
Whole thread Raw
In response to Re: Default maximum time replication between master and slave databases  (Guillaume Lelarge <guillaume@lelarge.info>)
Responses Re: Default maximum time replication between master and slave databases
List pgsql-admin
Tree view
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



Winner of IHS Jane's ATC Award - Enabling Technology

Registered in England & Wales. Registered Number: 4294244
-----------------------------------------------------------------------------------------




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

Le 10 juil. 2015 4:07 PM, "Alberto Olivares" <alberto.olivares@snowflakesoftware.com> 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

pgsql-admin by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: Default maximum time replication between master and slave databases
Next
From: Keith
Date:
Subject: Re: Default maximum time replication between master and slave databases