Hallo,
some info:
Postgres 8.4
Ubuntu 10.04.1
Linux hdmisv03 2.6.32-24-server #39-Ubuntu SMP Wed Jul 28 06:21:40 UTC 2010 x86_64 GNU/Linux
and we installed Postgres through atp.
The user wanted just to kill a connection from another user on a database. He did not kill the whole server process but only one connection on a single database.
The filesystem and the postgres server were ok. No reboot or power interuption, however fsck was not run recently.
The cluster includes about 450 databases. Perhaps too much?
If we identify the corrupted database (I think the one with OID 35531019), is there a way to remove it manually from the file system?
Tommaso
On Thu, 2011-07-28 at 20:02 +0800, Craig Ringer wrote:
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/
