Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 459307ACC82 for ; Wed, 8 Aug 2012 03:50:48 -0300 (ADT) Received: from mail-pb0-f46.google.com ([209.85.160.46]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Sz06P-0006Xu-If for pgsql-performance@postgresql.org; Wed, 08 Aug 2012 06:50:47 +0000 Received: by pbbrr13 with SMTP id rr13so981137pbb.19 for ; Tue, 07 Aug 2012 23:50:32 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=20120113; h=message-id:date:from:user-agent:mime-version:to:cc:subject :references:in-reply-to:content-type:x-gm-message-state; bh=GUdjguk+foAZt616jPhlR6ktJL/PzsH/Hpln/nv4Tcw=; b=PuIWTuyUvdbUnkvB7QHoDcbr8WKehH4QnAz4pc8TD0B8qHmfSEto52O/jyDS3SEoQX bF8HlHzw+7IFR3ShhcaqP9qwUI5kE8ffVuiEOBE6XmqEOicJK191T2WavCbAIE9hA5MJ qcVdySatXOMM6WBU573ATSBQ/ZlHO/4pJG/XC05asT3FX7ohhStgyfcMMO9ihpID1U5u W8AOID2rUmmGfJqA/Ig7gtQlli2RtD8d53O4o3ZXxLTTnKvqaUHqhf8yZj3e42qabAQi 0b5EtoukuzBcNOQLToS2YtUOSQAoTTzgjDj9+BKF5rJKg4kWSCweBwGJrAY4Gl9TOoqT j1og== Received: by 10.68.233.103 with SMTP id tv7mr34335001pbc.124.1344408632178; Tue, 07 Aug 2012 23:50:32 -0700 (PDT) Received: from ayaki.localdomain (office1.postnewspapers.com.au. [150.101.171.128]) by mx.google.com with ESMTPS id sk5sm12791489pbc.7.2012.08.07.23.50.29 (version=SSLv3 cipher=OTHER); Tue, 07 Aug 2012 23:50:31 -0700 (PDT) Message-ID: <50220C32.3060609@ringerc.id.au> Date: Wed, 08 Aug 2012 14:50:26 +0800 From: Craig Ringer User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:14.0) Gecko/20120717 Thunderbird/14.0 MIME-Version: 1.0 To: rajiv.kasera@pinelabs.com CC: pgsql-performance@postgresql.org Subject: Re: Postgres Upgrade from 8.4 to 9.1 References: <009001cd7395$b8970a00$29c51e00$@pinelabs.com> In-Reply-To: <009001cd7395$b8970a00$29c51e00$@pinelabs.com> Content-Type: multipart/alternative; boundary="------------080602090903040101030308" X-Gm-Message-State: ALoCoQn6cjRWKm9gmSjqCw+p7SAk96tctZ5i2BBoIppQ9OOkcL+YRb1z2pTJenjZCOLJ70TEwxlk X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201208/58 X-Sequence-Number: 47596 This is a multi-part message in MIME format. --------------080602090903040101030308 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit On 08/06/2012 01:38 PM, Rajiv Kasera wrote: > > 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. > The most important documentation here is the release notes for the major .0 versions: http://www.postgresql.org/docs/current/static/release-9-1.html http://www.postgresql.org/docs/ current /static/release-9-0.html ... in particular the "Migration to" sections. > 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. > No. Take a copy before upgrading. Always. Keep the copy read-only in some safe place. If you want to revert, make a copy of your backup and use that. Upgrades from 8.4 to 9.0 or 9.1 require a dump and reload or the use of the pg_upgrade tool. You can't just install the new version and start it on your old database. > 3.Any known issues and changes required to be done in the application > for this upgrade. > See the release notes. -- Craig Ringer --------------080602090903040101030308 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit

On 08/06/2012 01:38 PM, Rajiv Kasera wrote:

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.

The most important documentation here is the release notes for the major .0 versions:

http://www.postgresql.org/docs/current/static/release-9-1.html
http://www.postgresql.org/docs/current /static/release-9-0.html

... in particular the "Migration to" sections.

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.

No. Take a copy before upgrading. Always. Keep the copy read-only in some safe place.

If you want to revert, make a copy of your backup and use that.

Upgrades from 8.4 to 9.0 or 9.1 require a dump and reload or the use of the pg_upgrade tool. You can't just install the new version and start it on your old database.

3. Any known issues and changes required to be done in the application for this upgrade.

See the release notes.

--
Craig Ringer
--------------080602090903040101030308--