- upgrade advice

fel <fellsin@xxxxxxxxxxx> · Fri, 3 Jun 2011 12:22:31 +0200



    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.