From: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
---|---|
To: | Luki Rustianto <lukirus(at)gmail(dot)com> |
Cc: | pgsql general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Guidelines for upgrading from pgsql7.4.xxx server to |
Date: | 2006-03-29 15:29:12 |
Message-ID: | 1143646152.3625.127.camel@state.g2switchworks.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, 2006-03-28 at 20:53, Luki Rustianto wrote:
> 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 ?
There's this page:
http://www.postgresql.org/docs/8.1/static/install-upgrading.html
And take a look at this one too:
http://www.postgresql.org/docs/8.1/static/release-8-1.html
which covers a few issues like encoding problems you might see. In
versions before 8.0 charset checking was lax, and you might have
characters in your database that are illegal for UTF-8 encoding. Simple
fix is to let iconv fix that. Linux has it, not sure about other OSes,
but someone could always download a knoppix disc and boot from it just
long enough to convert the dumps if you don't run linux in your shop.
From | Date | Subject | |
---|---|---|---|
Next Message | Tomi NA | 2006-03-29 15:29:34 | Re: Implementation Suggestions |
Previous Message | Reimer | 2006-03-29 15:13:21 | PostgreSQL x Sybase |