Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Tom Lane wrote:
>> 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.
[ thinks about it... ] Yeah, that seems doable, since 'smart' mode by
definition isn't making any promises about getting out of town quick.
However, would it really be all that helpful to do that? I'm not sure
I trust a backup methodology that depends on having shut down the server
in "the right way".
It seems reasonable to me to have pg_stop_backup() close the current WAL
segment, and also to have some time-limit-driven mechanism for doing so.
What's the use-case for doing it on postmaster stop, though?
regards, tom lane
---------------------------(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
