Re: Default maximum time replication between master and slave databases

Hi

Le 10 juil. 2015 2:58 PM, "Alberto Olivares" <
alberto(dot)olivares(at)snowflakesoftware(dot)com> a écrit :
>
> Hello,
>
> I am running this query in the slave database:
>
> 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.
>
> Anyone knows how to change this default value?
>

pg_last_xact_replay_timestamp() gives you the timestamp of the last
replayed transaction. That doesn't have anything to do with configuration.
It mostly depends on the activity on the master. If you don't have any
write activity on the master, you'll have bigger values. And that's normal.

--
Guillaume