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

From Tom Lane
Subject Re: Forcing current WAL file to be archived
Date
Msg-id 10713.1153842786@sss.pgh.pa.us
Whole thread Raw
In response to Re: Forcing current WAL file to be archived  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: Forcing current WAL file to be archived  (Bruce Momjian <bruce@momjian.us>)
Re: Forcing current WAL file to be archived  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-hackers
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.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Forcing current WAL file to be archived
Next
From: Bruce Momjian
Date:
Subject: Re: Forcing current WAL file to be archived