From: Kenneth Marshall <ktm@rice.edu>
To: Uwe Schroeder <uwe@bunspace.com>
Cc: pgsql-admin@postgresql.org, gnanam@zoniac.com, 'Devrim G?ND?Z' <devrim@gunduz.org>
Subject: Re: How to upgrade PostgreSQL minor releases without a dump/restore?
Date: Fri, 4 Mar 2011 08:37:46 -0600
Message-ID: <20110304143746.GE8169@aart.is.rice.edu> (raw)
In-Reply-To: <201103031943.46705.uwe@bunspace.com>
References: <003701cbd7e5$b8eb1d90$2ac158b0$@com>
<1298966686.2128.16.camel@lenovo01-laptop03.gunduz.org>
<004501cbd7ef$4c02d240$e40876c0$@com>
<201103031943.46705.uwe@bunspace.com>
On Thu, Mar 03, 2011 at 07:43:46PM -0800, Uwe Schroeder wrote:
>
> > > ? 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
>
The "Just copy the files someplace else" can take a long, long
time for a large database and you need to have the database off-line
for the copy to be correct. Not really an option in many environments.
Cheers,
Ken
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ktm@rice.edu, uwe@bunspace.com, devrim@gunduz.org
Subject: Re: How to upgrade PostgreSQL minor releases without a dump/restore?
In-Reply-To: <20110304143746.GE8169@aart.is.rice.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox