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
