From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Forcing current WAL file to be archived |
Date: | 2006-07-25 16:29:21 |
Message-ID: | 200607251629.k6PGTLc22942@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Simon Riggs wrote:
> On Tue, 2006-07-25 at 11:57 -0400, Bruce Momjian wrote:
> > Tom Lane wrote:
> > > Simon Riggs <simon(at)2ndquadrant(dot)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.
It is not a blame issue. The issue is I would like this completed for
8.2 and I want to minimize the possibility it will not be done.
I think we do know what we want done. It is just that we are not
certain of the user interface.
--
Bruce Momjian bruce(at)momjian(dot)us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-07-25 16:29:47 | Re: Forcing current WAL file to be archived |
Previous Message | Csaba Nagy | 2006-07-25 16:26:42 | Re: Forcing current WAL file to be archived |