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@xxxxxxxxxxxxxx on behalf of Luki Rustianto Sent: Tue 3/28/2006 6:53 PM To: pgsql-general@xxxxxxxxxxxxxx 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!
