From: | Alberto Olivares <alberto(dot)olivares(at)snowflakesoftware(dot)com> |
---|---|
To: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Default maximum time replication between master and slave databases |
Date: | 2015-07-10 14:07:41 |
Message-ID: | CAGdoAzhtCUgNsK_HHQ6dPYdQ_CONAh=CSmh0OyVkoCzaNWcCVw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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 .
Regards,
Alberto.
*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:56, Guillaume Lelarge <guillaume(at)lelarge(dot)info> wrote:
> 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
>
--
*Winner of IHS Jane's ATC Award - Enabling Technology*
*Read more <http://www.snowflakesoftware.com/2015/03/janes-award/>*
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2015-07-10 14:11:25 | Re: Default maximum time replication between master and slave databases |
Previous Message | Guillaume Lelarge | 2015-07-10 14:07:03 | Re: Automatic restore corruption problem |