> OK, makes sense. Could we give them a command to archive it before they > shut down? That would make sense.
Not if the idea is to be certain you got everything ... I think what we have to do is document a manual procedure for archiving the last XLOG file. But really my question is "what's the use case for this?" ISTM that on-line backups are what PITR users want, not something involving shutting down the postmaster --- and the changes Simon is already making will be enough to handle those cases. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org