Re: URGENT! pg_dump doesn't work!

Nigel J. Andrews wrote:

>On Mon, 22 Jul 2002, Wim wrote:
>
>>Hello guys,
>>
>>I have a problem with my postgres 7.2.1 database.
>>I can't perform a pg_dump one my database...
>>The message I get back is:
>>
>>pg_dump: query to obtain list of tables failed: server closed the
>>connection unexpectedly
>> This probably means the server terminated abnormally
>> before or while processing the request.
>>pg_dump failed on belbonedb_v2, exiting
>>
>>Whe I connect to the database and do:
>>
>>belbonedb_v2=# \dt networks
>>
>>I get:
>>
>>ERROR: AllocSetFree: cannot find block containing chunk 4aee70
>>
>>
>>Can I fix this error?
>>
>
>
>Is this perhaps another of those hardware errors that seem to be turning up at
>the moment?
>
>So Wim, did you have improper shutdowns? Are you confident in your memory and
>hard disk(s)?
>
>
The database is never killed with the -9 and I have no problems with my
hard disks or memory...
Is it a bug that can be fixed? I can create a DB with the same tables
and do a 'copy from/to' to transfer the data.
'Cause it is a large DB (tables with more that 1 million rows) , I would
do this if I have no other option left...

Thanx!

Wim