Tom Lane wrote:
Bruce Momjian wrote: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.
What Bruce would want is a way to "stop new transactions, archive and shutdown", which would do this atomically. Then we could have another shutdown switch for pg_ctl.
But yea, a documentation for a manual procedure would be ok, too, just not as user friendly.
Best Regards,
Michael Paesold
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match