Re: Guidelines for upgrading from pgsql7.4.xxx server to pgsql8.xxx server

As others have pointed out, OID dependant tables may need special attention.

We recently upgraded from 7.4 to 8.1.x and found some issues with encoding -- 8.1 defaulted to a different encoding and we had some data that was invalid; we manually fixed the old data before retrying the export.

Make sure you read the manual's section on the configuration parameters as well; there are some changes / improvements.

Some SQL may need adjustment -- there are some stricter checks in 8.1 which will fail to run SQL that 7.4 would accept (look for the "Missing WHERE clause" stuff in the manual, for instance.)

Our upgrade went smoothly (both runtime with postGIS data and the billing side of things) and I'd upgrading; 8.1 has some substantial improvements.

Greg Williamson
DBA
GlobeXplorer LLC

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org on behalf of Luki Rustianto
Sent: Tue 3/28/2006 6:53 PM
To: pgsql-general(at)postgresql(dot)org
Cc:
Subject: [GENERAL] Guidelines for upgrading from pgsql7.4.xxx server to pgsql8.xxx server

Hi All,

All of our application now runs on postgresql7.4.xxx servers, I never
tried it on version 8.xxx

I wonder if there are any guidelines / step by step / special
considerations whether it applies to database structure or the
application it self if we want to upgrade to version 8.xxx ?

Thanks.

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

!DSPAM:4429f70e308891228024673!