Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id B961365019D
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Mon,  4 Aug 2008 01:41:30 -0300 (ADT)
Received: from postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 02174-03-2 for
	<pgsql-admin-postgresql.org@postgresql.org>;
	Mon,  4 Aug 2008 01:41:24 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from an-out-0708.google.com (an-out-0708.google.com
 [209.85.132.249])
	by postgresql.org (Postfix) with ESMTP id 2873C6502FC
	for <pgsql-admin@postgresql.org>; Mon,  4 Aug 2008 01:25:25 -0300 (ADT)
Received: by an-out-0708.google.com with SMTP id d30so332909and.33
	for <pgsql-admin@postgresql.org>; Sun, 03 Aug 2008 21:25:24 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from:to
	:subject:in-reply-to:mime-version:content-type:references;
	bh=8wh1wMi4GO53UepWpV9+XmZiEwKUNqtQlPCvC9sYB8k=;
	b=uoJOO5WViyTZ2UMMmebmm/J/ug22JZBrLhj6UagSjrL9AN5r5CKPo3Ut7BMcURefBz
	vOfO6VJH58rCpf7gnv05TgCJBKUIgjjJ4EVFCeIdiaf5A3H7RUrXlH37em97Bpig4w/X
	Mrch+WQQBgqvLfkV/Lln1LeuaL7k1ipTliU+g=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:in-reply-to:mime-version
	:content-type:references;
	b=b0LNBMh/eB4JLApEZ6V5M2vqc3XTsoqnABncg3KtZF+uVakV5WsQeKf30JyXmca3lV
	WcuYjJstjfvQb40l2kTA1XGvjjVPf4jyMTxC5XsJwKCjJpADGzlsasvb8Wver5r72I+B
	+rko4kvmyaefcOSbkyNdHQ635zLZOrYLGoZgs=
Received: by 10.100.139.20 with SMTP id m20mr19076236and.77.1217823924833;
	Sun, 03 Aug 2008 21:25:24 -0700 (PDT)
Received: by 10.100.242.10 with HTTP; Sun, 3 Aug 2008 21:25:24 -0700 (PDT)
Message-ID: <f93eaa100808032125g4658db32q6dad6f00f5693f66@mail.gmail.com>
Date: Sun, 3 Aug 2008 23:25:24 -0500
From: "Andrew Goodnough" <agoodno@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: client_encoding error on load
In-Reply-To: <19201.1217817494@sss.pgh.pa.us>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_33546_5975904.1217823924837"
References: <f93eaa100808031859y1c019fcbocc7a58d01c67d488@mail.gmail.com>
	<19201.1217817494@sss.pgh.pa.us>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200808/12
X-Sequence-Number: 29857

------=_Part_33546_5975904.1217823924837
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On Sun, Aug 3, 2008 at 9:38 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> "Andrew Goodnough" <agoodno@gmail.com> writes:
> > I'm using these commands to perform a dump and load.
> > pg_dump -c lakevie_typo | gzip > $HOME/backups/typo_$DATE.sql.gz
> > gzip < $HOME/backups/typo_$DATE.sql.gz |psql -d lakevie_typobak -f -
>
> Surely the second step must start with gunzip?
>
>                        regards, tom lane



Yeah, that's gotta be it.  Dumb error, thanks.

Andy

------=_Part_33546_5975904.1217823924837
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div dir="ltr"><br><div class="gmail_quote">On Sun, Aug 3, 2008 at 9:38 PM, Tom Lane <span dir="ltr">&lt;<a href="mailto:tgl@sss.pgh.pa.us">tgl@sss.pgh.pa.us</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class="Ih2E3d">&quot;Andrew Goodnough&quot; &lt;<a href="mailto:agoodno@gmail.com">agoodno@gmail.com</a>&gt; writes:<br>
&gt; I&#39;m using these commands to perform a dump and load.<br>
&gt; pg_dump -c lakevie_typo | gzip &gt; $HOME/backups/typo_$DATE.sql.gz<br>
&gt; gzip &lt; $HOME/backups/typo_$DATE.sql.gz |psql -d lakevie_typobak -f -<br>
<br>
</div>Surely the second step must start with gunzip?<br>
<br>
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;regards, tom lane</blockquote><div><br>&nbsp;</div></div>Yeah, that&#39;s gotta be it.&nbsp; Dumb error, thanks.<br><br>Andy<br><br><br></div>

------=_Part_33546_5975904.1217823924837--