From: | AI Rumman <rummandba(at)gmail(dot)com> |
---|---|
To: | pgsql-general General <pgsql-general(at)postgresql(dot)org> |
Subject: | invalid byte sequence for encoding "UTF8": 0xf1612220 |
Date: | 2011-05-11 07:16:30 |
Message-ID: | BANLkTinOQRdpcZgc9bJggQaSvU4KtHGDFA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I am trying to migrate a database from Postgresql 8.2 to Postgresql 8.3 and
getting the following error:
pg_restore: [archiver (db)] Error from TOC entry 2764; 0 29708702 TABLE DATA
originaldata postgres
pg_restore: [archiver (db)] COPY failed: ERROR: invalid byte sequence for
encoding "UTF8": 0xf1612220
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".
CONTEXT: COPY wi_originaldata, line 3592
I took a dump from 8.2 server and then tried to restore at 8.3.
Both the client_encoding and server_encoding are UTF8 at both the servers.
Table "public.data"
Column | Type
| Modifiers
---------------------+------------------------+------------------------------------------------------------------------
orgid | integer |
id | integer | not null default
nextval(('"data"'::text)::regclass)
datatypecode | character varying(15) |
batchname | character varying(60) |
filename | character varying(60) |
encoding | character varying(20) |
errormessage | character varying(255) |
originaldata_backup | bytea |
processeddata | bytea |
validatedflag | smallint |
processedflag | smallint |
createddate | date |
createdtime | time without time zone |
modifieddate | date |
modifiedtime | time without time zone |
processeddate | date |
processedtime | time without time zone |
deletedflag | smallint |
originaldata | text |
Indexes:
"data_pkey" PRIMARY KEY, btree (id)
Any help will be appreciable.
From | Date | Subject | |
---|---|---|---|
Next Message | mephysto | 2011-05-11 07:19:29 | Custom types and JDBC |
Previous Message | Dae-man Yang | 2011-05-11 06:29:07 | ERROR: cannot execute nextval() in a read-only transaction |