Over in the "Log notice that checkpoint is to be written on shutdown" thread...
On 10/16/14, 2:31 PM, Michael Banck wrote:> There were some comments that this might not actually be the case and/or>
thatthe postmaster was simply waiting for clients to disconnect due to> smart shutdown being invoked.
Something else mentioned was that once you start a smart shutdown you have no good way (other than limited ps output)
tosee what the shutdown is waiting on. I'd like to have some way to get back into the database to see what's going on.
Perhapswe could allow superusers to connect while waiting for shutdown. A big warning that we're in shutdown would be
nice,and maybe it would make sense to further restrict this to only local connections.
It would also be good to be able to abort a smart shutdown if you determine it was a bad idea. Perhaps that's an
acceptableway to solve both problems: if your smart shutdown is hung, cancel it and connect to see what's going on.
--
Jim Nasby, Data Architect, Blue Treble Consulting
Data in Trouble? Get it in Treble! http://BlueTreble.com