Re: postgres unable to start

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/