Upgrading postgresql from version 7.4.3

From: Arun P(dot)L <arunpl(at)hotmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Upgrading postgresql from version 7.4.3
Date: 2013-05-09 09:02:05
Message-ID: SNT136-W17D1732CFA66F38BBFA6FBDBA40@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

How can I upgrade to latest postgresql version 9.2 from my current version 7.4.3? How complicated this will be as the db contains large amount of data? I have installed the latest version 9.2 in new server and while restoring the dump from old version, data in some of the large tables are not copied and getting error.

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?

Please provide your suggestion regarding this.

Regards~
Arun

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2013-05-09 09:24:59 Re: Upgrading postgresql from version 7.4.3
Previous Message Kevin Grittner 2013-05-09 02:31:20 Re: Normal errors codes in serializable transactions