From ashish.yadav@firemon.com Tue Aug  19 22:13:15 2014
Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M42760=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1XJreV-0008EZ-BK
 for pgsql-admin@arkaria.postgresql.org; Tue, 19 Aug 2014 22:13:15 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M42760=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1XJreU-00011P-Fp
 for pgsql-admin@arkaria.postgresql.org; Tue, 19 Aug 2014 22:13:14 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
 by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256)
 (Exim 4.80) (envelope-from <ashish.yadav@firemon.com>)
 id 1XJUIK-0004SN-Dz
 for pgsql-admin@postgresql.org; Mon, 18 Aug 2014 21:16:48 +0000
Received: from smtp90.ord1c.emailsrvr.com ([108.166.43.90])
 by magus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256)
 (Exim 4.80) (envelope-from <ashish.yadav@firemon.com>)
 id 1XJUIG-0001PF-3R
 for pgsql-admin@postgresql.org; Mon, 18 Aug 2014 21:16:46 +0000
Received: from localhost (localhost.localdomain [127.0.0.1])
 by smtp12.relay.ord1c.emailsrvr.com (SMTP Server) with ESMTP id 3A34080220
 for <pgsql-admin@postgresql.org>; Mon, 18 Aug 2014 17:16:41 -0400 (EDT)
X-Virus-Scanned: OK
Received: from smtp192.mex05.mlsrvr.com (unknown [184.106.31.85])
 by smtp12.relay.ord1c.emailsrvr.com (SMTP Server) with ESMTPS id 2915080247
 for <pgsql-admin@postgresql.org>; Mon, 18 Aug 2014 17:16:41 -0400 (EDT)
Received: from ORD2MBX05E.mex05.mlsrvr.com ([fe80::d47d:20ff:fe52:4153]) by
 ORD2HUB24.mex05.mlsrvr.com ([fe80::be30:5bff:fef5:60b0%15]) with mapi id
 14.03.0169.001; Mon, 18 Aug 2014 16:16:41 -0500
From: Ashish Yadav <ashish.yadav@firemon.com>
To: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Upgrading PostgreSQL from v8.4.14 to v9.3.5
Thread-Topic: Upgrading PostgreSQL from v8.4.14 to v9.3.5
Thread-Index: AQHPuym0fzi81pKzdEepFkf4FNFGXQ==
Date: Mon, 18 Aug 2014 21:16:40 +0000
Message-ID: <D017D767.2DC7%ashish.yadav@firemon.com>
Accept-Language: en-US
Content-Language: en-US
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
x-originating-ip: [199.180.243.242]
Content-Type: multipart/alternative;
 boundary="_000_D017D7672DC7ashishyadavfiremoncom_"
MIME-Version: 1.0
X-Pg-Spam-Score: -1.9 (-)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

--_000_D017D7672DC7ashishyadavfiremoncom_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi,

I am currently running a stand alone PostgreSQL v8.4.14 on a Linux CentOS s=
erver and need to perform an upgrade.
Can I upgrade to the latest PostgreSQL v9.3.5 or do I need to perform an in=
termediate upgrade?

Current:
psql (PostgreSQL) 8.4.14

java version "1.6.0_37"
Java(TM) SE Runtime Environment (build 1.6.0_37-b06)
Java HotSpot(TM) 64-Bit Server VM (build 20.12-b01, mixed mode)

Linux 2.6.18-371.4.1.el5 x86_64



Thanks,

Ashish.

--_000_D017D7672DC7ashishyadavfiremoncom_
Content-Type: text/html; charset="us-ascii"
Content-ID: <F724F45A8E38534A81C4E77EF16DCD32@mex05.mlsrvr.com>
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii"=
>
</head>
<body style=3D"word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-lin=
e-break: after-white-space; color: rgb(0, 0, 0); font-size: 14px; font-fami=
ly: Calibri, sans-serif;">
<div>Hi,</div>
<div><br>
</div>
<div>I am currently running a stand alone PostgreSQL v8.4.14 on a Linux Cen=
tOS server and need to perform an upgrade.&nbsp;</div>
<div>Can I upgrade to the latest PostgreSQL v9.3.5 or do I need to perform =
an intermediate upgrade?</div>
<div><br>
</div>
<div><b>Current:</b></div>
<div>psql (PostgreSQL) 8.4.14</div>
<div><br>
</div>
<div>
<div>java version &quot;1.6.0_37&quot;</div>
<div>Java(TM) SE Runtime Environment (build 1.6.0_37-b06)</div>
<div>Java HotSpot(TM) 64-Bit Server VM (build 20.12-b01, mixed mode)</div>
</div>
<div><br>
</div>
<div>Linux 2.6.18-371.4.1.el5 x86_64</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div>Thanks,</div>
<div><br>
</div>
<div>Ashish.</div>
</body>
</html>

--_000_D017D7672DC7ashishyadavfiremoncom_--




From raghuchennuru@gmail.com Wed Aug  20 03:35:07 2014
Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M42762=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1XJwfz-0002XI-A3
 for pgsql-admin@arkaria.postgresql.org; Wed, 20 Aug 2014 03:35:07 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M42762=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1XJwfy-0007VI-L6
 for pgsql-admin@arkaria.postgresql.org; Wed, 20 Aug 2014 03:35:06 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
 by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256)
 (Exim 4.80) (envelope-from <raghuchennuru@gmail.com>)
 id 1XJwfx-0007Sv-5z
 for pgsql-admin@postgresql.org; Wed, 20 Aug 2014 03:35:05 +0000
Received: from mail-oi0-x22d.google.com ([2607:f8b0:4003:c06::22d])
 by magus.postgresql.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:256)
 (Exim 4.80) (envelope-from <raghuchennuru@gmail.com>)
 id 1XJwft-0001X1-4Q
 for pgsql-admin@postgresql.org; Wed, 20 Aug 2014 03:35:04 +0000
Received: by mail-oi0-f45.google.com with SMTP id e131so5296283oig.18
 for <pgsql-admin@postgresql.org>; Tue, 19 Aug 2014 20:34:57 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
 h=mime-version:in-reply-to:references:from:date:message-id:subject:to
 :cc:content-type;
 bh=DIsoAywWqeYyMbuU7JOBrxvL69ljNzpAIVmEslh34ns=;
 b=osNwbvGY2QREHxofjHFpfJLf/0C7NPr/YOEZNgZFUjRr3iJ13BSNQa8Y1McqIH3ro7
 B+s9H7t88r+sJd9L1P9v3Q2kSrNDr6PwGQbu/tLlELT0aOlJ0V0jFvyRBXQHnmozkjzI
 ek4ACGxzx5G0WXZxB7LfuRHj+kYf2v8VOE9W093gMucc2jSWT17THWAs2qy48NjTuqI1
 pTj/T4XytseFjlyHr0sUZo4hCEzNNSO/gVoEYDKpqpt2kPXigR0o3gH/ocVP3e0ALtK0
 rITinEjWIqvkVgtzE3Zz3V2bKwwtrorihDTGrTJuf/H/LpaOn5Wd5I7hQfib8oVtjMvq
 IUAw==
X-Received: by 10.182.33.33 with SMTP id o1mr47450244obi.24.1408505697926;
 Tue, 19 Aug 2014 20:34:57 -0700 (PDT)
MIME-Version: 1.0
Received: by 10.202.136.70 with HTTP; Tue, 19 Aug 2014 20:34:37 -0700 (PDT)
In-Reply-To: <D017D767.2DC7%ashish.yadav@firemon.com>
References: <D017D767.2DC7%ashish.yadav@firemon.com>
From: Raghu Ram <raghuchennuru@gmail.com>
Date: Wed, 20 Aug 2014 09:04:37 +0530
Message-ID: 
 <CALnrrJSfAEXRCc8ERnk2ejQAhwJnmRL2jkuzk1SmLDpdKNx83g@mail.gmail.com>
Subject: Re: Upgrading PostgreSQL from v8.4.14 to v9.3.5
To: Ashish Yadav <ashish.yadav@firemon.com>
Cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Content-Type: multipart/alternative; boundary=001a11c1fe1eca04bc05010749f5
X-Pg-Spam-Score: -2.0 (--)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

--001a11c1fe1eca04bc05010749f5
Content-Type: text/plain; charset=UTF-8

On Tue, Aug 19, 2014 at 2:46 AM, Ashish Yadav <ashish.yadav@firemon.com>
wrote:

>  Hi,
>
>  I am currently running a stand alone PostgreSQL v8.4.14 on a Linux
> CentOS server and need to perform an upgrade.
> Can I upgrade to the latest PostgreSQL v9.3.5 or do I need to perform an
> intermediate upgrade?
>
>  *Current:*
> psql (PostgreSQL) 8.4.14
>
>  java version "1.6.0_37"
> Java(TM) SE Runtime Environment (build 1.6.0_37-b06)
> Java HotSpot(TM) 64-Bit Server VM (build 20.12-b01, mixed mode)
>
>  Linux 2.6.18-371.4.1.el5 x86_64
>
>
>
Apply database minor versions from PostgreSQL 8.4.14 to 8.4.22 and then
up-grade database version from PostgreSQL 8.4.22 to PostgreSQL 9.3.5.

Thanks & Regards
Raghu Ram

--001a11c1fe1eca04bc05010749f5
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div class=3D"gmail_extra"><br><div class=3D"gmail_quote">=
On Tue, Aug 19, 2014 at 2:46 AM, Ashish Yadav <span dir=3D"ltr">&lt;<a href=
=3D"mailto:ashish.yadav@firemon.com" target=3D"_blank">ashish.yadav@firemon=
.com</a>&gt;</span> wrote:<br>

<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex">



<div style=3D"word-wrap:break-word;color:rgb(0,0,0);font-size:14px;font-fam=
ily:Calibri,sans-serif">
<div>Hi,</div>
<div><br>
</div>
<div>I am currently running a stand alone PostgreSQL v8.4.14 on a Linux Cen=
tOS server and need to perform an upgrade.=C2=A0</div>
<div>Can I upgrade to the latest PostgreSQL v9.3.5 or do I need to perform =
an intermediate upgrade?</div>
<div><br>
</div>
<div><b>Current:</b></div>
<div>psql (PostgreSQL) 8.4.14</div>
<div><br>
</div>
<div>
<div>java version &quot;1.6.0_37&quot;</div>
<div>Java(TM) SE Runtime Environment (build 1.6.0_37-b06)</div>
<div>Java HotSpot(TM) 64-Bit Server VM (build 20.12-b01, mixed mode)</div>
</div>
<div><br>
</div>
<div>Linux 2.6.18-371.4.1.el5 x86_64</div>
<div><br>
</div>
<div><br></div></div></blockquote><div>=C2=A0=C2=A0</div><div>Apply databas=
e minor versions from PostgreSQL 8.4.14 to 8.4.22 and then up-grade databas=
e version from PostgreSQL 8.4.22 to PostgreSQL 9.3.5.<br></div><div><br></d=
iv><div>

Thanks &amp; Regards</div><div>Raghu Ram</div><div>=C2=A0</div></div></div>=
</div>

--001a11c1fe1eca04bc05010749f5--




From scott.marlowe@gmail.com Wed Aug  20 15:16:08 2014
Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M42763=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1XK7cO-000122-87
 for pgsql-admin@arkaria.postgresql.org; Wed, 20 Aug 2014 15:16:08 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M42763=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1XK7cN-0003Xu-EM
 for pgsql-admin@arkaria.postgresql.org; Wed, 20 Aug 2014 15:16:07 +0000
Received: from makus.postgresql.org ([2001:4800:1501:1::229])
 by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256)
 (Exim 4.80) (envelope-from <scott.marlowe@gmail.com>)
 id 1XK7cI-0003OM-33
 for pgsql-admin@postgresql.org; Wed, 20 Aug 2014 15:16:02 +0000
Received: from mail-qa0-x234.google.com ([2607:f8b0:400d:c00::234])
 by makus.postgresql.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:256)
 (Exim 4.80) (envelope-from <scott.marlowe@gmail.com>)
 id 1XK7cE-0000uz-Gd
 for pgsql-admin@postgresql.org; Wed, 20 Aug 2014 15:16:00 +0000
Received: by mail-qa0-f52.google.com with SMTP id j15so6964505qaq.25
 for <pgsql-admin@postgresql.org>; Wed, 20 Aug 2014 08:15:57 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
 h=mime-version:in-reply-to:references:date:message-id:subject:from:to
 :cc:content-type;
 bh=JlIJgfrEsFXNFKBtUvC+UeRJ4X+/1uTtGLszeLccofY=;
 b=aHMEk7pU5QM/BdTFMn4M3PJXuXVs2y0YdYgFGKi9wXYF4B4aFXGOfXisIqKK33g3JA
 /XFX1gw6kjZFq+CyJqxYtyT4hm9zTyp+GYGrfMURN0pDhvWWWg3TI9RljfKw1AjpLWVS
 j/WEYVR5k0jRYyv+OGiJlwm7EhvBjdzX+lT3l5AjgsgUm6ISGT0tX2mGWvjvIB06ehBq
 VUuLzLU6RXRu2zpAaSWN2yVMGZdD4EtSepMkbFzQ5nLFBJ+qqVKvgq5rgoOMlgKGT0Ev
 t3GJTOh0Ij49qCeexFwvYxq7aHSeQDa/ekq78RX4ZmcwiXeIxv1dQb/khYXt3vgJGw2E
 odww==
MIME-Version: 1.0
X-Received: by 10.140.34.164 with SMTP id l33mr27259531qgl.72.1408547757563;
 Wed, 20 Aug 2014 08:15:57 -0700 (PDT)
Received: by 10.140.47.131 with HTTP; Wed, 20 Aug 2014 08:15:57 -0700 (PDT)
In-Reply-To: <D017D767.2DC7%ashish.yadav@firemon.com>
References: <D017D767.2DC7%ashish.yadav@firemon.com>
Date: Wed, 20 Aug 2014 09:15:57 -0600
Message-ID: 
 <CAOR=d=3DzCzLF2Pbt_4Pso0nZrOivrM=FwXK5Wk0N-1UmdctqQ@mail.gmail.com>
Subject: Re: Upgrading PostgreSQL from v8.4.14 to v9.3.5
From: Scott Marlowe <scott.marlowe@gmail.com>
To: Ashish Yadav <ashish.yadav@firemon.com>
Cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Content-Type: text/plain; charset=UTF-8
X-Pg-Spam-Score: -2.0 (--)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

On Mon, Aug 18, 2014 at 3:16 PM, Ashish Yadav <ashish.yadav@firemon.com> wrote:
> Hi,
>
> I am currently running a stand alone PostgreSQL v8.4.14 on a Linux CentOS
> server and need to perform an upgrade.
> Can I upgrade to the latest PostgreSQL v9.3.5 or do I need to perform an
> intermediate upgrade?
>
> Current:
> psql (PostgreSQL) 8.4.14
>
> java version "1.6.0_37"
> Java(TM) SE Runtime Environment (build 1.6.0_37-b06)
> Java HotSpot(TM) 64-Bit Server VM (build 20.12-b01, mixed mode)
>

How important is uninterrupted uptime to you? If no big deal, then as
mentioned by another poster, upgrde ti 8.4.latest, then after taking a
backup install 9.3.latest and use pg_upgrade from 9.3 to get there.

Other possibilites are to take a backup with 9.3 and then restore with
that. Use slony to replicate from 8.4 to 9.3 so that both are live and
switchover time is minimized.

-- 
To understand recursion, one must first understand recursion.


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin