Re: client_encoding error on load

["Andrew Goodnough" <agoodno@xxxxxxxxx>]

On Sun, Aug 3, 2008 at 9:38 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:

"Andrew Goodnough" <agoodno@xxxxxxxxx> 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