- upgrade advice

From: fel <fellsin(at)hotmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: - upgrade advice
Date: 2011-06-03 10:22:31
Message-ID: BLU0-SMTP14148107143F617366C81ACB87F0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Campbell, Lance 2011-06-03 12:49:51 viewing results in terminal on RedHat 6.1
Previous Message Tom Lane 2011-06-02 19:54:30 Re: pgpool versus sequences