Re: [GENERAL] Effect of a kill -9 on postgres

2011-08-07 Thread Craig Ringer
The only time "kill -9" should be a data corruption issue is if you kill the postMASTER (not just a backend) then remove the postmaster.pid file from the datadir and relaunch the postmaster without first making sure the worker backends are all shut down. You need to load the shotgun, aim it carefu

[GENERAL] Effect of a kill -9 on postgres

2011-08-07 Thread Royce Ausburn
Hi all, A few days ago one of our postgres (8.3.12) servers was a bit unhappy, and someone decided to try a kill -9 on a backend process after a kill (TERM) was ineffective. I've read many times in the past that a kill -9 can be pretty hazardous to a postgres' health, and now it seems I get to