|
Home > Archive > PostgreSQL Discussion > March 2006 > Guidelines for upgrading from pgsql7.4.xxx server to pgsql8.xxx server
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Guidelines for upgrading from pgsql7.4.xxx server to pgsql8.xxx server
|
|
| Luki Rustianto 2006-03-29, 3:27 am |
| 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
| |
| Gregory S. Williamson 2006-03-29, 7:29 am |
| 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@postgresql.org on behalf of Luki Rustianto
Sent: Tue 3/28/2006 6:53 PM
To: pgsql-general@postgresql.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:4429f70e30889
1228024673!
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
|
|
|
|
|