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 CAGdoAzjEOo2NVzxfQuk2Cm2-vZ12xsb9VV3wcyeO=u-NPXt91Q@mail.gmail.com
Whole thread Raw
In response to Re: Default maximum time replication between master and slave databases  (Scott Ribe <scott_ribe@elevated-dev.com>)
List pgsql-admin
Streaming replication.

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 14:32, Scott Ribe <scott_ribe@elevated-dev.com> wrote:
On Jul 10, 2015, at 6:54 AM, Alberto Olivares <alberto.olivares@snowflakesoftware.com> wrote:
>
> SELECT EXTRACT (epoch from now() - pg_last_xact_replay_timestamp());
>
> The maximum result is 60 seconds then the value goes to 0 and start again. I would like to modify this value to maximum 30 seconds.
>
> I have tried to change different parameters on the  postgresql.conf in both databases but I have not find the solution.

WAL shipping or streaming?

--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
https://www.linkedin.com/in/scottribe/
(303) 722-0567 voice







Winner of IHS Jane's ATC Award - Enabling Technology

pgsql-admin by date:

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