Skip site navigation (1) Skip section navigation (2)

Re: archive_timeout behavior for no activity

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Bruce Momjian" <bruce(at)momjian(dot)us>, "PostgreSQL-development" <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: archive_timeout behavior for no activity
Date: 2010-01-14 16:07:08
Message-ID: 4B4EECCC020000250002E4B1@gw.wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-hackers
Bruce Momjian <bruce(at)momjian(dot)us> wrote:
 
> Looking at the archive_timeout documentation and
> CheckArchiveTimeout(), it appears we force a new xlog file and
> archive it even if no activity has been recorded in the xlog file.
> Is this correct?  Should we document this or fix it so only xlog
> files with contents are archived?
 
Er, you can probably blame me for that.  Tom was going to fix it and
I pointed out that it would break our monitoring of our warm standby
processes.  We have a one hour maximum and send alerts if we've gone
75 minutes or more without receiving a WAL file from one of our
databases.  Of course, if we had a nicer way to know that we were
up-to-date with our WAL file copies, we wouldn't need this; but
right now there aren't a lot of options for monitoring these things.
 
-Kevin

In response to

Responses

pgsql-hackers by date

Next:From: Tim BunceDate: 2010-01-14 16:07:16
Subject: Miscellaneous changes to plperl [PATCH]
Previous:From: Dimitri FontaineDate: 2010-01-14 16:06:36
Subject: Re: Streaming replication, retrying from archive

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group