Tom Lane wrote: > Simon Riggs <[EMAIL PROTECTED]> 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). I am wondering if someone else needs to take this on, because if Simon doesn't complete it in a week, we don't have it for 8.2, and we would then have to sit through another year of PITR complaints. :-( -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster