Re: Corrupt database

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
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 12:21:17
Message-ID: 20021016122117.GA630@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I've havn't done anything much with it in a while, but the link below may
help.

http://svana.org/kleptog/pgsql/pgfsck.html

On Wed, Oct 16, 2002 at 10:21:30AM +0100, Neil Fraser wrote:
> 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.
>
> This behaviour occurs when the database is opened in using Perl's DBI,
> or when using psql or pg_dump or vacuumdb. There is about a megabyte of
> text contained in this database which I'd rather like to extract
> somehow. Our other PostgreSQL databases are running perfectly.
>
> Any suggestions on how to recover my data? I've browsed the PG data
> files, but they appear to be binary, which I can't read.
>
> PostgreSQL 7.1.1 on Linux 2.2.19
>
> Thank you.
> --
> | Neil D. Fraser, Programmer & Wizard, neil(at)digitalroutes(dot)co(dot)uk
> | Digital Routes, Inverness, Scotland, www.digitalroutes.co.uk
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> There are 10 kinds of people in the world, those that can do binary
> arithmetic and those that can't.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gert Kienhuis 2002-10-16 12:36:03 Inquiry From Form [pgsql]
Previous Message Jose Antonio Leo 2002-10-16 10:52:11 Re: RV: bad result in a query!! hopeless