Re: Default maximum time replication between master and slave databases

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: Alberto Olivares <alberto(dot)olivares(at)snowflakesoftware(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Default maximum time replication between master and slave databases
Date: 2015-07-10 13:32:07
Message-ID: AF02885C-89DF-4C6F-A060-494CE3F80B07@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Alberto Olivares 2015-07-10 13:47:23 Re: Default maximum time replication between master and slave databases
Previous Message michael@sqlexec.com 2015-07-10 13:30:16 Re: Automatic restore corruption problem