"Simon Riggs" <[EMAIL PROTECTED]> writes: > A simple solution is to introduce a new function:
> pg_archive_wait(integer maxwait); > maxwait = 0 means wait forever, otherwise time measured in seconds. maxwait is redundant; people who want a timeout should use statement_timeout. > This will get the current xlog position and wait for all files prior to > that point to be shown as archive done. Including the current one? If so, it'll wait longer than necessary; if not, ISTM it's a gotcha waiting to trap the unwary. Perhaps better is a variant of pg_stop_backup that includes a wait for the pushed-out xlog segment to be archived. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings