Re: switch WAL segment

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> Andreas Pflug wrote:
>> Tom Lane wrote:
>>> Do we have a TODO for allowing users to
>>> force switching to a new WAL file segment?
>>
>> Together with PITR, this might make sense?

> I thought about this, and it would perhaps help, but it would bloat the
> archive location if used repeatedly, perhaps every minute so you have a
> recent version. It also might not work on server shutdown because there
> might not be time to do the archive. I think we are going to need a
> solution to archive the current file in a different way.

More to the point, if we did think that was worth doing then we'd just
make pg_start_backup do it automatically. There's still no need for
user control.

regards, tom lane