Thread: [Postgresql 8.4.2] problem restoring data

Hi
I want to restore a large database (5GB) from a backup (dump postgresql)
When the process arrive to the largest table, it stops with this output

"pg_restore: [custom archiver] could not uncompress data: too many length or distance symbols"

i do the dump with "pg_dump -Fc"

Does someone have an idea on this?

Thank you

Regards,
Fida

fida aljounaidi <fida.aljounaidi@gmail.com> writes:
> I want to restore a large database (5GB) from a backup (dump postgresql)
> When the process arrive to the largest table, it stops with this output

> "pg_restore: [custom archiver] could not uncompress data: too many length or
> distance symbols"

Hm.  Either you have a corrupt dump file, or you've found a bug in zlib.
I'd bet on the former myself.

            regards, tom lane

Hi

Thank you for your answer.
I'm trying again with another dump.
By the way I'm working on ubuntu server 8.04  ,postgresql 8.4.2.

Regards

Fida