Postgres Pro
Downloads
Home   >   mailing lists

ERROR: AllocSetFree: cannot find block containing chunk 507928 - Mailing list pgsql-general

From Edwin New
Subject ERROR: AllocSetFree: cannot find block containing chunk 507928
Date
Msg-id 83CE2DFB3E02EF4EAB09B5125EAD011B01365672@lavertonexch.toll.com.au
Whole thread Raw
Responses Re: ERROR: AllocSetFree: cannot find block containing chunk 507928  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view

When I connect to this database with psql, and type \z to see a list of tables, I get the error

        ERROR:  AllocSetFree: cannot find block containing chunk 507928

When I try to dump the database, I get this error:

        pg_dump: query to obtain list of tables failed: ERROR:  AllocSetFree: cannot find block containing chunk 51d158

I am running 7.2.1 on Solaris 8.

What do I need to do to recover this database?

Thanks,

Edwin New

pgsql-general by date:

Previous
From: "Wang, Mary Y"
Date:
Subject: Re: SQL - display different data
Next
From: Tom Lane
Date:
Subject: Re: ERROR: AllocSetFree: cannot find block containing chunk 507928