Re: upgrade 8.0.3 -> 8.2.4 - Mailing list pgsql-admin

From Peter Koczan
Subject Re: upgrade 8.0.3 -> 8.2.4
Date
Msg-id 4643AEA2.4050404@gmail.com
Whole thread Raw
In response to Re: upgrade 8.0.3 -> 8.2.4  ("Peter Koczan" <pjkoczan@gmail.com>)
List pgsql-admin
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* <steve.holdoway@firetrust.com
> <mailto:steve.holdoway@firetrust.com>> 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
>
>


pgsql-admin by date:

Previous
From: "zhan deng"
Date:
Subject: silent installation of PostresSQL
Next
From: Steve Holdoway
Date:
Subject: Re: upgrade 8.0.3 -> 8.2.4