Re: [GENERAL] 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


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)