Re: Forcing current WAL file to be archived - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: Forcing current WAL file to be archived
Date
Msg-id 1153844031.2592.612.camel@holly
Whole thread Raw
In response to Re: Forcing current WAL file to be archived  (Bruce Momjian <bruce@momjian.us>)
Responses Re: Forcing current WAL file to be archived  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
On Tue, 2006-07-25 at 11:57 -0400, Bruce Momjian wrote:
> Tom Lane wrote:
> > Simon Riggs <simon@2ndquadrant.com> writes:
> > > I was planning to add a new GUC
> > >     archive_timeout (integer) = max # secs between log file switches
> > 
> > That's fine, but feature freeze is in a week and we don't even have the
> > basic function for manually doing a log file switch.  Let's get that
> > done first and then think about automatic switches.
> > 
> > Also, forcing another 16M of WAL out every few seconds is a pretty crude
> > and inefficient way of making sure your hot standby server is up to
> > date.  As Hannu noted, an archiving script can do better than that if it
> > can access the current WAL file name and offset.  So we really want to
> > get the function to return that info done as well.
> 
> Agreed.  One concern I have is that we have waited for Simon to complete
> this for 1.5 years, and now with a week left he is still working on it
> (or starting on it).  

Since we cannot agree even now on what should be done, you'll forgive me
for not having completed it sooner, especially since you know more about
my schedule now than others.

--  Simon Riggs              EnterpriseDB   http://www.enterprisedb.com



pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: Forcing current WAL file to be archived
Next
From: Tom Lane
Date:
Subject: Re: [PATCHES] Patch for VS.Net 2005's strxfrm() bug