pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

[Postgresql 8.4.2] problem restoring data
3+ messages / 2 participants
[nested] [flat]

* [Postgresql 8.4.2] problem restoring data
@ 2010-09-21 13:41  fida aljounaidi <fida.aljounaidi@gmail.com>
  0 siblings, 1 reply; 3+ messages in thread

From: fida aljounaidi @ 2010-09-21 13:41 UTC (permalink / raw)
  To: pgsql-admin

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

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: [Postgresql 8.4.2] problem restoring data
@ 2010-09-21 14:54  Tom Lane <tgl@sss.pgh.pa.us>
  parent: fida aljounaidi <fida.aljounaidi@gmail.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Tom Lane @ 2010-09-21 14:54 UTC (permalink / raw)
  To: fida aljounaidi <fida.aljounaidi@gmail.com>; +Cc: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: [Postgresql 8.4.2] problem restoring data
@ 2010-09-21 15:00  fida aljounaidi <fida.aljounaidi@gmail.com>
  parent: Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 3+ messages in thread

From: fida aljounaidi @ 2010-09-21 15:00 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin

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
>

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

end of thread, other threads:[~2010-09-21 15:00 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-09-21 13:41 [Postgresql 8.4.2] problem restoring data fida aljounaidi <fida.aljounaidi@gmail.com>
2010-09-21 14:54 ` Tom Lane <tgl@sss.pgh.pa.us>
2010-09-21 15:00   ` fida aljounaidi <fida.aljounaidi@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox