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