postgres invalid byte sequence for encoding "UTF8"

Question

my origin database is with SQL_ASCII encoding and my future database is with UTF8, which is in another server.

well... I export with this command:

pg_dump -v -E UTF8 -Fc -h x.x.x.x old-database-name -U username > backup.dmp

and try import with this one

pg_restore --single-transaction -v -Fc -d new-database-name -U username <  backup.dmp

but I am facing this error:

pg_restore: [arquivador (bd)] Erro ao PROCESSAR TOC: pg_restore: [arquivador (bd)] Erro no registro do TOC 722; 1255 4594720 FUNCTION Whatever(character varying) username pg_restore: [arquivador (bd)] could not execute query: ERRO: sequência de bytes é inválida para codificação "UTF8": 0xe1 0x72 0x69

if I dump and restore without -E parameter works well, but my new database then has characters problems.

Helio Ferreira · Accepted Answer · 2016-05-18 15:47:06Z

1

well... i had to dump like plain text and removed invalids characters with this command on linux:

iconv -c -f UTF-8 -t UTF-8 <backup.sql >backup-cleaned.sql

answered May 18, 2016 at 15:47

Helio Ferreira

1731 gold badge3 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

postgres invalid byte sequence for encoding "UTF8"

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related