Simon Riggs <[EMAIL PROTECTED]> writes: > On Tue, 2006-07-25 at 11:07 -0400, Tom Lane wrote: >> I see no need for that to be "automatic". I'd vote for a simple >> function pg_finish_wal_segment() or something like that, which you >> call just after pg_stop_backup() if you want this behavior. Trying >> to tie it into pg_stop_backup() will only make things more complicated >> and less flexible.
> Putting it into pg_stop_backup was what we previously agreed. > Where is the loss of flexibility? I don't see why you think this function should be tied to making a backup. There are other reasons for wanting to force a WAL switch than that, and there are scenarios in which you don't need a WAL switch at the end of a backup. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq