I almost forgot one of the biggest gotchas. Remember that users and
groups were conflated into "roles" in postgres 8.1. In addition to being
a change, there were some other issues, namely that you couldn't
manually specify user and group sysids. I had to change our user and
group management scripts to properly reflect this.
Peter
Peter Koczan wrote:
A few months ago, I upgraded postgres from 7.4 to 8.2. There were a
few gotchas, but we don't keep a whole lot of data so even the biggest
problems were, on the whole, minor.
- The cidr data type became more strict, and a few tables in our
network database would not restore until this was fixed.
- One of the primary keys broke and couldn't get created. This was
more the fault of poor admins (before my time) and internal
fragmentation than postgres 7.4. I had to fix the underlying table
before it would restore.
- There were a few permissions issues (new acls + an inconsistent
previous policy = fun).
- The system databases went from SQL_ASCII encoding to UTF8 encoding.
I had to explicitly create the database during the restore, or else
the database would have the wrong encoding.
I doubt that you will run into these exact problems, but my point is
that there are inevitably some gotchas. If it's not prohibitively
time-consuming, I'd recommend a full dump/restore of your database(s)
from 8.0 to 8.2 so you can catch many of these gotchas before going
live. Also, you might want to create test versions of your apps and
try them against the 8.2 server.
On the whole, I've found postgres to be very good at maintaining
backwards compatibility of interfaces and sql, so I estimate that most
queries and db apps should "just work" with 8.2.
Peter
On 5/10/07, *Steve Holdoway* <[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>> wrote:
Are there any gotchas? I've got the opportunity to move to another
database server for this application and yould like to take the
opportunity to upgrade at the same time.
tia,
Steve
---------------------------(end of
broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
