client_encoding error on load

From: "Andrew Goodnough" <agoodno(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: client_encoding error on load
Date: 2008-08-04 01:59:27
Message-ID: f93eaa100808031859y1c019fcbocc7a58d01c67d488@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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 -

The dump is fine but the load only works if I first extract the sql, then
run it. Running it using the pipe to psql, I get:

psql:<stdin>:71: ERROR: invalid byte sequence for encoding "UTF8": 0x8b
HINT: This error can also happen if the byte sequence does not match the
encoding expected by the server, which is controlled by "client_encoding".

yet, doing a 'psql -l' shows this database to be UTF-8. And the dump file
says:

SET client_encoding = 'UTF8';

My goal is to get the two line dump/load working so I don't have any manual
steps and sql files laying around. Any ideas?

Andy

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2008-08-04 02:38:14 Re: client_encoding error on load
Previous Message Tom Lane 2008-08-02 15:25:16 Re: fuzzy search