"Joshua D. Drake" <jd@commandprompt.com> writes:
>> I believe 20 seconds is the standard number --- that's plenty for
>> Postgres.
>>
> Not always. More than once I have had a postgresql connection hung up
> that will stop the main postmaster from dying on TERM. However the
> machine will eventually kill it hard and thus could produce during restart.
Seems fine to me. Otherwise such a hangup could prevent system shutdown
indefinitely, which is a Bad Thing when your UPS batteries have thirty
seconds left in 'em ...
You will get a WAL replay at restart in that scenario, but your data
should be perfectly safe.
regards, tom lane