Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id 41F6F1337B63
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue, 21 Sep 2010 12:00:13 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 57416-08 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue, 21 Sep 2010 15:00:05 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-qy0-f181.google.com (mail-qy0-f181.google.com
	[209.85.216.181])
	by mail.postgresql.org (Postfix) with ESMTP id 71AEA1337B60
	for <pgsql-admin@postgresql.org>; Tue, 21 Sep 2010 12:00:05 -0300 (ADT)
Received: by qyk33 with SMTP id 33so5530710qyk.19
	for <pgsql-admin@postgresql.org>; Tue, 21 Sep 2010 08:00:04 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:received:in-reply-to
	:references:date:message-id:subject:from:to:cc:content-type;
	bh=cPKzJdc+P4MoPBnBKV4wBVLmlmeGaXQ6nOnoRihcCjA=;
	b=EenB3SpXQzb2wirDYy1WPosiVhELSRcEYLkO8n78SUDwZhWKHN8Vjtxi8SwU4zJDax
	+nTuw2QqqJg10v4MhgvHk54UVIt7LjivHyYnnrMcTxkLv1dGU/RiCTpt5f1+N3SYuXmS
	7Nxnw9v2VCQUEcUJIuO7kxqap9vCYWIHrsrag=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type;
	b=BZM7NlU1jkJ9zcotuDukcErzqon2YQ5vw5CJHOhOifHtUkTKvjSIgAHmMHhPsT6W2/
	H/YZb5qvensHb6yVcpQ+t6CMJufIGzjOhNdPqjwRYIZ7D+xrt7POdMcFcexKIsQvPPSH
	daR6vJejBQXg4xoFbG0tHk+tsAzFsvojEmjC8=
MIME-Version: 1.0
Received: by 10.229.1.201 with SMTP id 9mr6917943qcg.145.1285081203617; Tue,
	21 Sep 2010 08:00:03 -0700 (PDT)
Received: by 10.229.4.196 with HTTP; Tue, 21 Sep 2010 08:00:03 -0700 (PDT)
In-Reply-To: <2589.1285080879@sss.pgh.pa.us>
References: <AANLkTikunGjeYD6AqBtB4YD9DjEzq3SRQLomFSexiL_=@mail.gmail.com>
	<2589.1285080879@sss.pgh.pa.us>
Date: Tue, 21 Sep 2010 17:00:03 +0200
Message-ID: <AANLkTim7nRYbrYCHOm+ZoK2SoDMuijmkWA47T7J8fA6D@mail.gmail.com>
Subject: Re: [Postgresql 8.4.2] problem restoring data
From: fida aljounaidi <fida.aljounaidi@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-admin@postgresql.org
Content-Type: multipart/alternative; boundary=001485e7724ea630ce0490c648c7
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.899 tagged_above=-10 required=5
	tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001
X-Spam-Level: 
X-Archive-Number: 201009/124
X-Sequence-Number: 35668

--001485e7724ea630ce0490c648c7
Content-Type: text/plain; charset=UTF-8

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
>

--001485e7724ea630ce0490c648c7
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<br>Hi <br><br>Thank you for your answer. <br>I&#39;m trying again with ano=
ther dump. <br>By the way I&#39;m working on ubuntu server 8.04=C2=A0 ,post=
gresql 8.4.2. <br><br>Regards<br><br>Fida<br><br><br><br><div class=3D"gmai=
l_quote">
On 21 September 2010 16:54, Tom Lane <span dir=3D"ltr">&lt;<a href=3D"mailt=
o:tgl@sss.pgh.pa.us">tgl@sss.pgh.pa.us</a>&gt;</span> wrote:<br><blockquote=
 class=3D"gmail_quote" style=3D"border-left: 1px solid rgb(204, 204, 204); =
margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class=3D"im">fida aljounaidi &lt;<a href=3D"mailto:fida.aljounaidi@gma=
il.com">fida.aljounaidi@gmail.com</a>&gt; writes:<br>
&gt; I want to restore a large database (5GB) from a backup (dump postgresq=
l)<br>
&gt; When the process arrive to the largest table, it stops with this outpu=
t<br>
<br>
&gt; &quot;pg_restore: [custom archiver] could not uncompress data: too man=
y length or<br>
&gt; distance symbols&quot;<br>
<br>
</div>Hm. =C2=A0Either you have a corrupt dump file, or you&#39;ve found a =
bug in zlib.<br>
I&#39;d bet on the former myself.<br>
<br>
 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0regards, tom lane<br>
</blockquote></div><br>

--001485e7724ea630ce0490c648c7--