Tom Lane wrote: > Bruce Momjian <pgman@candle.pha.pa.us> writes: > > OK, I updated the two current TODO items: > > * Automatically force archiving of partially-filled WAL files when > > pg_stop_backup() is called or the server is stopped > > > Is this OK? > > Archive on stop is right out. The common reason for a stop is that the > system is being shut down, and we don't have time to archive a WAL file > before init will kill -9 us.
Ah, good point. Can we do it for 'smart' shutdown mode, which is the default? I see server stop scripts using 'fast' where we would not do the WAL archive. -- 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 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match