Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: client_encoding error on load
Date
Msg-id 19201.1217817494@sss.pgh.pa.us
Whole thread Raw
In response to client_encoding error on load  ("Andrew Goodnough" <agoodno@gmail.com>)
Responses Re: client_encoding error on load  ("Andrew Goodnough" <agoodno@gmail.com>)
List pgsql-admin
Tree view 
"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

pgsql-admin by date:

Previous
From: "Andrew Goodnough"
Date:
Subject: client_encoding error on load
Next
From: "Praveen"
Date:
Subject: Re: client_encoding error on load