On 13.1.2012 22:20, Tom Lane wrote:
> Matt Dew <mattd@consistentstate.com> writes:
>> An interesting sidenote we realized. the nice system shutdown script
>> /etc/init.d/postgres doesn't actually wait for the db to be down, it
>> just waits for pg_ctl to return.
>
> By default, "pg_ctl stop" does wait for the server to shut down ...
Not really. It waits for up to 60 seconds and if the shutdown was not
successful (as there was a connected client), it prints a message to the log
pg_ctl: server does not shut down
HINT: The "-m fast" option immediately disconnects sessions
rather than
and returns 1.
If you really need to wait for shutdown, you need to add "-w" to the
command line, use "-m fast" or "-m immediate".
But even ignoring the return value should not cause corruption IMHO.
Tomas