Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 4274CB622C7 for ; Fri, 3 Jun 2011 07:22:42 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 19520-04 for ; Fri, 3 Jun 2011 10:22:35 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from blu0-omc1-s34.blu0.hotmail.com (blu0-omc1-s34.blu0.hotmail.com [65.55.116.45]) by mail.postgresql.org (Postfix) with ESMTP id 52B62B62B51 for ; Fri, 3 Jun 2011 07:22:35 -0300 (ADT) Received: from BLU0-SMTP141 ([65.55.116.9]) by blu0-omc1-s34.blu0.hotmail.com with Microsoft SMTPSVC(6.0.3790.4675); Fri, 3 Jun 2011 03:22:35 -0700 X-Originating-IP: [62.23.146.21] X-Originating-Email: [fellsin@hotmail.com] Message-ID: Received: from [192.168.10.28] ([62.23.146.21]) by BLU0-SMTP141.phx.gbl over TLS secured channel with Microsoft SMTPSVC(6.0.3790.4675); Fri, 3 Jun 2011 03:22:33 -0700 Date: Fri, 3 Jun 2011 12:22:31 +0200 From: fel User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.2.17) Gecko/20110414 Lightning/1.0b2 Thunderbird/3.1.10 MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: - upgrade advice Content-Type: multipart/alternative; boundary="------------060909010904020000050205" X-OriginalArrivalTime: 03 Jun 2011 10:22:33.0697 (UTC) FILETIME=[26F25510:01CC21D8] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.897 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RFC_ABUSE_POST=0.001, T_RP_MATCHES_RCVD=-0.01, T_TO_NO_BRKTS_FREEMAIL=0.01 X-Spam-Level: X-Archive-Number: 201106/10 X-Sequence-Number: 37636 --------------060909010904020000050205 Content-Type: text/plain; charset="ISO-8859-1"; format=flowed Content-Transfer-Encoding: 7bit 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. --------------060909010904020000050205 Content-Type: text/html; charset="ISO-8859-1" Content-Transfer-Encoding: 7bit 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.
--------------060909010904020000050205--