Search Postgresql Archives

Re: archive_timeout in postgresql.conf

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



akp geek wrote:

I am trying to set up the PG_STANDBY on our database setup. our requirement is, In case of disaster we should be able to bring up standby, the lag time allowed in our setup is up to 2 hours. The question I have is, what should be the value I set for the archive_timeout in the postgressql.conf file? Can you please help?

You might as well set it to something similar in scale to checkpoint_timeout; 5 or 10 minutes would be completely reasonable for archive_timeout.

That parameter isn't the only component to lag time though, it primarily impacts how many transactions you're willing to lose if commits happen on the master that aren't transferred over to the standby and the master dies. Lag time is that time, plus however long it takes the standby to keep up with processing the incoming archive files, plus how long it takes to bring it out of recovery after a primary failure.

--
Greg Smith  2ndQuadrant US  Baltimore, MD
PostgreSQL Training, Services and Support
greg@xxxxxxxxxxxxxxx   www.2ndQuadrant.us


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux