Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id D15EB182A953 for ; Mon, 6 Aug 2012 02:39:57 -0300 (ADT) Received: from [122.160.150.50] (helo=zimbra.pinelabs.com) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SyG2l-00005c-7M for pgsql-performance@postgresql.org; Mon, 06 Aug 2012 05:39:56 +0000 Received: from localhost (localhost.localdomain [127.0.0.1]) by zimbra.pinelabs.com (Postfix) with ESMTP id 3144120F09E0 for ; Mon, 6 Aug 2012 11:09:36 +0530 (IST) X-Virus-Scanned: amavisd-new at pinelabs.com Received: from zimbra.pinelabs.com ([127.0.0.1]) by localhost (zimbra.pinelabs.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id idCUe4Ja0udn for ; Mon, 6 Aug 2012 11:09:35 +0530 (IST) Received: from PINENOIL10149 (unknown [192.168.101.70]) by zimbra.pinelabs.com (Postfix) with ESMTP id B516320F09CE for ; Mon, 6 Aug 2012 11:09:35 +0530 (IST) Reply-To: From: "Rajiv Kasera" To: Subject: Postgres Upgrade from 8.4 to 9.1 Date: Mon, 6 Aug 2012 11:08:34 +0530 Message-ID: <009001cd7395$b8970a00$29c51e00$@pinelabs.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0091_01CD73C3.D250CCA0" X-Mailer: Microsoft Outlook 14.0 Thread-Index: Ac1zlbggeDmoDI9tRGyTNu+R+XYJwQ== Content-Language: en-us X-Host-Lookup-Failed: Reverse DNS lookup failed for 122.160.150.50 (failed) X-Pg-Spam-Score: 1.6 (+) X-Archive-Number: 201208/56 X-Sequence-Number: 47594 This is a multipart message in MIME format. ------=_NextPart_000_0091_01CD73C3.D250CCA0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi, I am planning a Postgres migration from 8.4 to 9.1 to be able to leverage the replication features available in the 9.1 version. I would like to understand the following things in this regard: 1. Any good documentation which should help in this upgrade. 2. To be able to replicate the complete steps in a test environment before doing it in LIVE which is running 9.0, is it possible to revert this database to 8.4 and then upgrade to 9.1. 3. Any known issues and changes required to be done in the application for this upgrade. Thanks, rajiv ------=_NextPart_000_0091_01CD73C3.D250CCA0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi,

I am plann= ing a Postgres migration from 8.4 to 9.1 to be able to leverage the replica= tion features available in the 9.1 version. I would like to understand the = following things in this regard:

&n= bsp;

1.= = Any good documentation which should help in = this upgrade.

2. &nbs= p; To be able to replicate the co= mplete steps in a test environment before doing it in LIVE which is running= 9.0, is it possible to revert this database to 8.4 and then upgrade to 9.1= .

3. &nb= sp; Any known issues and changes required to = be done in the application for this upgrade.

Thanks,
rajiv<= /p>

= ------=_NextPart_000_0091_01CD73C3.D250CCA0--