Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id D9401133616B
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue,  1 Mar 2011 03:56:55 -0400 (AST)
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 70779-05 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue,  1 Mar 2011 07:56:48 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from rs73.luxsci.com (rs73.luxsci.com [64.49.254.135])
	by mail.postgresql.org (Postfix) with ESMTP id 6D9071337B39
	for <pgsql-admin@postgresql.org>; Tue,  1 Mar 2011 03:56:48 -0400 (AST)
Received: from GNANAM ([180.151.61.10]) (authenticated bits=0)
	by rs73.luxsci.com (8.13.8/8.13.8) with ESMTP id p217uhHi005974;
	Tue, 1 Mar 2011 01:56:45 -0600
Reply-To: <gnanam@zoniac.com>
From: "Gnanakumar" <gnanam@zoniac.com>
To: <pgsql-admin@postgresql.org>
Subject: How to upgrade PostgreSQL minor releases without a dump/restore?
Date: Tue, 1 Mar 2011 13:23:12 +0530
Organization: Zoniac Software Private Limited
Message-ID: <003701cbd7e5$b8eb1d90$2ac158b0$@com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
X-Mailer: Microsoft Office Outlook 12.0
Thread-Index: AcvX5bXHzocpKWCXSZib4SDnH75gQQ==
Content-Language: en-us
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9
X-Spam-Level: 
X-Archive-Number: 201103/1
X-Sequence-Number: 36873

Hi,

Our production server is running PostgreSQL v8.2.3 on CentOS5.2. We're
planning to upgrade to the latest version in 8.2 series, that is v8.2.20.
Also, in future, we've planned to upgrade to the most recent minor release
as soon as possible (as and when released by PostgreSQL).

Initially, we've installed v8.2.3 from source. PostgreSQL is installed in
/usr/local/pgsql/ and data directory is available in /usr/local/pgsql/data

PostgreSQL Versioning policy says: "Upgrading to a minor release does not
require a dump and restore; merely stop the database server, install the
updated binaries, and restart the server."

Now, without a dump/restore, what are the recommended ways/steps involved in
upgrading PostgreSQL to latest version for minor releases?

Regards,
Gnanam