From: | Michael Simms <grim(at)argh(dot)demon(dot)co(dot)uk> |
---|---|
To: | mdalphin(at)amgen(dot)com (Mark Dalphin) |
Cc: | pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: [GENERAL] How to salvage a corrupted DB? |
Date: | 1999-09-24 18:56:46 |
Message-ID: | 199909241856.TAA04505@argh.demon.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> Hi,
>
> I have an important database which I have been unable to backup/dump for "a long
> while". I am looking for a method to "fix" the problem. As a last resort, I
> guess I could dump the DB table by table using "\copy", although I haven't tried
> yet. And I worry that the corrupted system tables may be accessed during a
> "\copy" so I may still be stuck.
<snip>
> Okay, what tables are present?
>
> > htg=> \d
> > pqReadData() -- backend closed the channel unexpectedly.
> > This probably means the backend terminated abnormally
> > before or while processing the request.
> > htg=>
> >
> Well, not quite such a hard crash; I'm still in psql, however, I am not
> connected to any DB an longer.
At the worst, you could, as you say, dump out the tables using copy.
To get the table list, look in the data directory, and you should see
all you need to know what tables are there
~Michael
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Ryan | 1999-09-24 21:50:54 | Any books available commercially? |
Previous Message | Mark Dalphin | 1999-09-24 18:11:32 | How to salvage a corrupted DB? |