| From: | Neil Fraser <neil(at)digitalroutes(dot)co(dot)uk> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Corrupt database |
| Date: | 2002-10-16 09:21:30 |
| Message-ID: | 3DAD2F9A.2070203@digitalroutes.co.uk |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jose Antonio Leo | 2002-10-16 10:52:11 | Re: RV: bad result in a query!! hopeless |
| Previous Message | Patrick Fiche | 2002-10-16 09:09:28 | Use of VACUUM / REINDEX |