Skip site navigation (1) Skip section navigation (2)

- 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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group