From: Uwe Schroeder <uwe@bunspace.com>
To: pgsql-admin@postgresql.org
To: gnanam@zoniac.com
Cc: 'Devrim GÜNDÜZ' <devrim@gunduz.org>
Subject: Re: How to upgrade PostgreSQL minor releases without a dump/restore?
Date: Thu, 3 Mar 2011 19:43:46 -0800
Message-ID: <201103031943.46705.uwe@bunspace.com> (raw)
In-Reply-To: <004501cbd7ef$4c02d240$e40876c0$@com>
References: <003701cbd7e5$b8eb1d90$2ac158b0$@com>
<1298966686.2128.16.camel@lenovo01-laptop03.gunduz.org>
<004501cbd7ef$4c02d240$e40876c0$@com>
> > ? 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
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: uwe@bunspace.com, gnanam@zoniac.com, devrim@gunduz.org
Subject: Re: How to upgrade PostgreSQL minor releases without a dump/restore?
In-Reply-To: <201103031943.46705.uwe@bunspace.com>
* 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