Re: Upgrading postgresql from version 7.4.3

John R Pierce <pierce@xxxxxxxxxxxx> · Thu, 09 May 2013 02:24:59 -0700



    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