Re: [REPOST] Problem for dumping a 6.5.2 database

"Bruno BAGUETTE" <pgsql-ml(at)baguette(dot)net> writes:
> I'm trying to dump a PostgreSQL 6.5.2. database table in order to add it
> in a PostgreSQL 7.3.3 database but I'm encountering some errors :

> -- reading user-defined functions
> getFuncs(): SELECT failed. Explanation from backend: 'pqReadData() --
> backend closed the channel unexpectedly.

> thedatabasename=> \d tablename;
> pqReadData() -- backend closed the channel unexpectedly.

Looks to me like you've got some serious problems with corruption of the
system tables :-(

If you can SELECT from the tables you need, I'd suggest dumping out
their contents using COPY commands. Then you can reload those data
files into a newer database (assuming you remember what the table
schemas were). 6.5.2 is old enough that I don't really remember how
to do any sort of data-recovery work with it...

regards, tom lane