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