From: Andrew Goodnough <agoodno@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: client_encoding error on load
Date: Sun, 3 Aug 2008 23:25:24 -0500
Message-ID: <f93eaa100808032125g4658db32q6dad6f00f5693f66@mail.gmail.com> (raw)
In-Reply-To: <19201.1217817494@sss.pgh.pa.us>
References: <f93eaa100808031859y1c019fcbocc7a58d01c67d488@mail.gmail.com>
<19201.1217817494@sss.pgh.pa.us>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: agoodno@gmail.com
Subject: Re: client_encoding error on load
In-Reply-To: <f93eaa100808032125g4658db32q6dad6f00f5693f66@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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