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)