Обсуждение: [Postgresql 8.4.2] problem restoring data

Поиск
Список
Период
Сортировка

[Postgresql 8.4.2] problem restoring data

От
fida aljounaidi
Дата:
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



Re: [Postgresql 8.4.2] problem restoring data

От
Tom Lane
Дата:
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

Re: [Postgresql 8.4.2] problem restoring data

От
fida aljounaidi
Дата:

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



On 21 September 2010 16:54, Tom Lane <tgl@sss.pgh.pa.us> wrote:
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