On 5/9/2013 2:02 AM, Arun P.L wrote:
pg_restore: [archiver (db)] Error from TOC entry1550 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