Re: Corrupt database - Mailing list pgsql-general

From Tom Lane
Subject Re: Corrupt database
Date
Msg-id 24477.1034780789@sss.pgh.pa.us
Whole thread Raw
In response to Corrupt database  (Neil Fraser <neil@digitalroutes.co.uk>)
List pgsql-general
Neil Fraser <neil@digitalroutes.co.uk> writes:
> One of our PostgreSQL databases has been corrupted somehow.  Whenever we
> try to open it or access it the 'postmaster' task suddenly goes to 99%
> CPU usage, it rapidly eats up all memory, then crashes our server.

Hm.  Can you attach to the backend task with a debugger and get a stack
trace to show where it's going nuts?

            regards, tom lane

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: RV: bad result in a query!! hopeless
Next
From: Robert Treat
Date:
Subject: Re: '-i option' with Runlevel script (RPM version)