Tom Lane wrote: > Bruce Momjian <pgman@candle.pha.pa.us> writes: > > Tom Lane wrote: > >> However, this still begs the question of why we are bothering. > >> I disagree with the goal in this particular case anyhow: I do not > >> think it's necessary, safe, nor sane for a shutdown to try to archive > >> the last XLOG segment. Even if we fixed the xlog mechanism to end the > >> file there, I really have a problem with the idea that the archiver > >> should try to start a fresh archiving cycle at shutdown. > > > Doing the archive at server shutdown eliminates one of the "must > > document" items, so the system behaves more predictably that it does > > not. It is not required --- it is a usability issue. > > No, it just replaces a documentation issue with a reliability issue. > We'd have to consider what to say about the prospect that the archiver > is unable to archive that last segment, is kill -9'd by init at some > critical point in the process, etc etc. I think it's just a bad idea > to promise people that shutting down the postmaster will have any such > effect.
OK, makes sense. Could we give them a command to archive it before they shut down? That would make sense. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
