Re: postgres unable to start

On 28/07/2011 7:51 PM, tommaso wrote:
> Hi All,
>
> one of our users killed a postgres process with kill -9 "PID"
> after that the DB server is not longer able to start.
>

There is a lot of information missing from this question, though you did
include the log entries (thanks). Please see this for the rest of the
info you need:

http://wiki.postgresql.org/wiki/Guide_to_reporting_problems

Why did the user "kill -9" the DB, anyway? Was it perhaps not responding
for an extended period, and maybe in the "D" state in PS? Are there /
were there any messages in "dmesg" or in the kernel log files? Perhaps
related to I/O errors or file system errors? Was there a recent fsck on
the file system, a recent reboot of the server, or recent power
loss/interruption?

--
Craig Ringer

POST Newspapers
276 Onslow Rd, Shenton Park
Ph: 08 9381 3088 Fax: 08 9388 2258
ABN: 50 008 917 717
http://www.postnewspapers.com.au/