Re: Database Recovery Procedures - Mailing list pgsql-general

From Tom Lane
Subject Re: Database Recovery Procedures
Date
Msg-id 2630.1063812912@sss.pgh.pa.us
Whole thread Raw
In response to Re: Database Recovery Procedures  (Network Administrator <netadmin@vcsn.com>)
Responses Re: Database Recovery Procedures  (Network Administrator <netadmin@vcsn.com>)
List pgsql-general
Network Administrator <netadmin@vcsn.com> writes:
> ..if I using the psql client, and issue a "select * from <corrupt table name>
> limit 5" if get this...

> PANIC:  read of clog file 5, offset 16384 failed: Success

Hm, not good :-(.  What files actually exist in $PGDATA/pg_clog/ (names
and sizes)?

> So back to my original question.  What are the recover procedures (if
> any) that should be tried before I grab my PGDATA path from tape?

You may be up against having to do that, but some investigation first
seems called for.

            regards, tom lane

pgsql-general by date:

Previous
From: Christopher Murtagh
Date:
Subject: PHP db support was Re: Dreamweaver
Next
From: Oleg Bartunov
Date:
Subject: Re: Trying to create a GiST index in 7.3