Backup and restore UTF8 data

From: Benjamin Arai <benjamin(at)araisoft(dot)com>
To: pgsql-admin-owner(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Backup and restore UTF8 data
Date: 2007-01-13 00:02:14
Message-ID: 45A82186.1020008@araisoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I am trying to backup an installation (8.0.3) and restore it to a new
(8.2.1) installation. I am am running the following command the backup
the data.

pg_dumpall > outfile

Then on the new machine I am simply running:

ENCODING=UTF8 psql -f outfile postgres

I get the following error for some of the records.

psql:outfile:151275: ERROR: invalid byte sequence for encoding "UTF8": 0x92

Does anybody know what I can do to fix this?

Benjamin

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Devrim GUNDUZ 2007-01-13 00:08:19 Re: Backup and restore UTF8 data
Previous Message Simon Riggs 2007-01-12 23:36:30 Re: Autovacuum Improvements