Re: Corrupt database

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Neil Fraser <neil(at)digitalroutes(dot)co(dot)uk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Corrupt database
Date: 2002-10-16 15:06:29
Message-ID: 24477.1034780789@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Neil Fraser <neil(at)digitalroutes(dot)co(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Robert Treat 2002-10-16 15:11:22 Re: '-i option' with Runlevel script (RPM version)
Previous Message Shridhar Daithankar 2002-10-16 14:16:01 Re: Queries take forever on ported database from MSSQL -> Postgresql