Re: Upgrading postgresql from version 7.4.3 - Mailing list pgsql-general

From John R Pierce
Subject Re: Upgrading postgresql from version 7.4.3
Date
Msg-id 518B6B6B.1000001@hogranch.com
Whole thread Raw
In response to Upgrading postgresql from version 7.4.3  (Arun P.L <arunpl@hotmail.com>)
List pgsql-general
On 5/9/2013 2:02 AM, Arun P.L wrote:

pg_restore: [archiver (db)] Error from TOC entry  1550 TABLE DATA  table_name;    
pg_restore: [archiver (db)] COPY failed for table "table_name": ERROR:  invalid byte sequence for encoding "UTF8": 0xa0

What else can I do for this issue, or in general how can I upgrade from a lower major version to higher version? Should I first upgrade to version 8 first and then go for the 9?

your problem is, you have data in your database that isn't valid UTF8.

what encoding was the 7.4 system ?



-- 
john r pierce                                      37N 122W
somewhere on the middle of the left coast

pgsql-general by date:

Previous
From: Arun P.L
Date:
Subject: Upgrading postgresql from version 7.4.3
Next
From: Jon Smark
Date:
Subject: Re: Normal errors codes in serializable transactions