Re: Default maximum time replication between master and slave databases

Streaming replication.

*Alberto Olivares Colas*Technical Consultant
Snowflake Software

Tel.: +44 (0)2380 386578

Email: alberto(dot)olivares(at)snowflakesoftware(dot)com
Website: www.snowflakesoftware.com
Twitter: @sflakesoftware <http://www,twitter(dot)com(at)sflakesoftware/>
Follow us on LinkedIn <http://www.linkedin.com/company/snowflake-software>

*Winner of IHS Jane's ATC Award - Enabling Technology*
*Read more <http://www.snowflakesoftware.com/2015/03/janes-award/>*

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

On 10 July 2015 at 14:32, Scott Ribe <scott_ribe(at)elevated-dev(dot)com> wrote:

> On Jul 10, 2015, at 6:54 AM, Alberto Olivares <
> alberto(dot)olivares(at)snowflakesoftware(dot)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(at)elevated-dev(dot)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*
*Read more <http://www.snowflakesoftware.com/2015/03/janes-award/>*