Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id 7F3E41337B3E
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu,  3 Mar 2011 23:50:36 -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 26373-09 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Fri,  4 Mar 2011 03:50:29 +0000 (UTC)
X-Greylist: delayed 00:06:40.769722 by SQLgrey-1.7.6
Received: from bunspace.com (mail.andrea-schroeder.com [64.142.76.151])
	by mail.postgresql.org (Postfix) with SMTP id C6F15133655C
	for <pgsql-admin@postgresql.org>; Thu,  3 Mar 2011 23:50:28 -0400 (AST)
Received: (qmail 11177 invoked by uid 453); 4 Mar 2011 03:43:47 -0000
X-Virus-Checked: Checked by ClamAV on bunspace.com
Received: from tiburon.bunspace.com (HELO tiburon.localnet) (192.168.1.4)
	by bunspace.com (qpsmtpd/0.83) with ESMTP;
	Thu, 03 Mar 2011 19:43:47 -0800
From: Uwe Schroeder <uwe@bunspace.com>
Organization: Bunspace.com
To: pgsql-admin@postgresql.org,
 gnanam@zoniac.com
Subject: Re: How to upgrade PostgreSQL minor releases without a dump/restore?
Date: Thu, 3 Mar 2011 19:43:46 -0800
User-Agent: KMail/1.13.5 (Linux/2.6.35-25-paeoss; KDE/4.5.1; i686; ; )
Cc: "'Devrim =?iso-8859-1?q?G=DCND=DCZ=27?=" <devrim@gunduz.org>
References: <003701cbd7e5$b8eb1d90$2ac158b0$@com>
	<1298966686.2128.16.camel@lenovo01-laptop03.gunduz.org>
	<004501cbd7ef$4c02d240$e40876c0$@com>
In-Reply-To: <004501cbd7ef$4c02d240$e40876c0$@com>
MIME-Version: 1.0
Content-Type: Text/Plain;
  charset="us-ascii"
Content-Transfer-Encoding: 7bit
Message-Id: <201103031943.46705.uwe@bunspace.com>
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/34
X-Sequence-Number: 36906


> > ? Did you read the paragraph above?
> > 
> > Install latest version, and restart postmaster.
> 
> Installing of latest version as-is will keep overwriting the existing
> installed directories/files/binaries but not the "/usr/local/pgsql/data/"
> directory right?  Since this is our production server database, am just
> clarifying this question that came to my mind, before upgrading.

For sake of safety, I'd always make a backup of the data directory. You don't 
need to dump/restore. Just copy the files someplace else and then do the 
update. In case something goes wrong you can always go back to your old 
version and just copy the backup to the data directory.

That's how I do upgrades. Never needed the backup, but better to have one.

Uwe