Обсуждение: [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
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
On 21 September 2010 16:54, Tom Lane <tgl@sss.pgh.pa.us> wrote:
fida aljounaidi <fida.aljounaidi@gmail.com> writes:Hm. Either you have a corrupt dump file, or you've found a bug in zlib.
> 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'd bet on the former myself.
regards, tom lane