Postgres Pro
Downloads
Home   >   mailing lists

Re: client_encoding error on load - Mailing list pgsql-admin

From Andrew Goodnough
Subject Re: client_encoding error on load
Date
Msg-id f93eaa100808032125g4658db32q6dad6f00f5693f66@mail.gmail.com
Whole thread Raw
In response to Re: client_encoding error on load  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view

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


pgsql-admin by date:

Previous
From: "Praveen"
Date:
Subject: Re: client_encoding error on load
Next
From: Lennin Caro
Date:
Subject: Re: functions