Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id 30D691337BA8
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue,  1 Mar 2011 04:05:17 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 71012-05 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue,  1 Mar 2011 08:05:10 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-iw0-f174.google.com (mail-iw0-f174.google.com
	[209.85.214.174])
	by mail.postgresql.org (Postfix) with ESMTP id 9C4881337B93
	for <pgsql-admin@postgresql.org>; Tue,  1 Mar 2011 04:05:09 -0400 (AST)
Received: by iwn34 with SMTP id 34so3873483iwn.19
	for <pgsql-admin@postgresql.org>; Tue, 01 Mar 2011 00:05:09 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:subject:mime-version:content-type:from
	:in-reply-to:date:cc:content-transfer-encoding:message-id:references
	:to:x-mailer; bh=GV7LZUgW3qXQyPEPEugXubeEjWeZzASDIUkz/6G4SgQ=;
	b=hl/2V/I/tcydlIVBYw7mqGhVGB5l0u7ghNH1KflyKIq/CZPjmAAjlr4qS4t1k0jS+0
	j3VyAHpU6IK3dMM5Bltmx5p47rtgfoCeQVeSxIRHByR2d4S92i3kxOpjtp8JKzUaD+n8
	ljAn04hWy2AEOZzw+HBnXggGboOhnZ7nEQDao=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=subject:mime-version:content-type:from:in-reply-to:date:cc
	:content-transfer-encoding:message-id:references:to:x-mailer;
	b=x9R8Pno4DRzFZ1SBvDnQoJNEWhbZOKPCXfF/erFSWkxk+KIPxKR/FFo9k+MM962vko
	Tc39WBdgOxhgYYh0tDdo/iHrp7V0gpgnkNFUGiKvMQ+g72OeHBv4mrEkikL5EKjoLzm3
	/mcLqomcUhXWey6b5XgWhiOHFtyf8CFCTCHrs=
Received: by 10.42.229.135 with SMTP id ji7mr6244675icb.365.1298966709466;
	Tue, 01 Mar 2011 00:05:09 -0800 (PST)
Received: from [192.168.1.2] ([122.169.79.60])
	by mx.google.com with ESMTPS id xa8sm3727609icb.10.2011.03.01.00.05.05
	(version=TLSv1/SSLv3 cipher=OTHER);
	Tue, 01 Mar 2011 00:05:08 -0800 (PST)
Subject: Re: How to upgrade PostgreSQL minor releases without a dump/restore?
Mime-Version: 1.0 (Apple Message framework v1082)
Content-Type: text/plain; charset=us-ascii
From: Vibhor Kumar <vibhor.aim@gmail.com>
In-Reply-To: <003701cbd7e5$b8eb1d90$2ac158b0$@com>
Date: Tue, 1 Mar 2011 13:35:47 +0530
Cc: <pgsql-admin@postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <1F29F959-4FF0-47A2-AB09-7EDEA5112A5B@gmail.com>
References: <003701cbd7e5$b8eb1d90$2ac158b0$@com>
To: <gnanam@zoniac.com>
X-Mailer: Apple Mail (2.1082)
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5
	tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_LOW=-0.7
X-Spam-Level: 
X-Archive-Number: 201103/3
X-Sequence-Number: 36875


On Mar 1, 2011, at 1:23 PM, Gnanakumar wrote:

>=20
> 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."

Install the Binaries of Specific Minor Release and Start the PG Instance =
using new Binary (pg_ctl) of PG.

1. Stop PG using pg_ctl of v8.2.3.=20
2. Install v8.2.20
3. Start PG using v8.2.20 Binary.

Thanks & Regards,
Vibhor
Blog:http://vibhork.blogspot.com=