Postgres Pro
Downloads
Home   >   mailing lists

- Upgrade advice - Mailing list pgsql-novice

From fel
Subject - Upgrade advice
Date
Msg-id BLU0-SMTP171FA0AD90940DD96103CCAB87F0@phx.gbl
Whole thread Raw
Responses Re: - Upgrade advice  (Alan Hodgson <ahodgson@simkin.ca>)
List pgsql-novice
Tree view
Hello all,

I would need advice regarding upgrade.

I have a small server running RHEL 5.2 32bit / Postgresql 8.3.3.
I would like to upgrade Postgres to 9.0 on a new server running RHEL 5.5 but 64bit.

What would be the best solution :
- Dump data from 32bit to 64bit then upgrade to v9.0 (using pg_upgrade).
- Upgrade to v9.0 then dump from 32 to 64bit.
- Dump from 8.3-32bit to 9.0-64bit.

Fel.

pgsql-novice by date:

Previous
From: "Jean-Yves F. Barbier"
Date:
Subject: BYTEA index
Next
From: Alan Hodgson
Date:
Subject: Re: - Upgrade advice