From: Steve Crawford <scrawford@pinpointresearch.com>
To: Chris Preston <chris@thetrafalgartravel.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Simple Upgrade from PostgreSQL version 8.1.11 (With schemas)
Date: Tue, 10 Jul 2012 08:38:30 -0700
Message-ID: <4FFC4C76.8090203@pinpointresearch.com> (raw)
In-Reply-To: <3EED475E754849429C74FCAB58B57CFF@chrisp>
References: <CACi+J=Tkm0v9djUMr6gFN4sav6rMFX4s2ARegAuXLL82d=oL3g@mail.gmail.com>
<4FEE0DCB.8020503@gmail.com>
<3EED475E754849429C74FCAB58B57CFF@chrisp>
On 07/10/2012 08:28 AM, Chris Preston wrote:
> Hello all,
> How far can I get to a higher version of PostgreSQL by just entering a
> command line instruction to upgrade without any major effort?
>
> Regards
>
> Chris Preston
>
>
At the simplest you just do a dump (using the dump tools from the *new*
version of PostgreSQL) and restore to the new version. If you aren't
worried about down-time and have the absolute simplest use-case then it
isn't too difficult.
Most people have to deal with reviewing the release notes to see how
they affect the overall system, setting up a test of the new version to
shake out issues and planning the upgrade to minimize down-time. Among
the things that have changed over the past few releases are tightening
up of casting rules and changing the default for
standard_conforming_strings to on either of which could cause serious
breakage.
Once you get to a newer version (anything past 8.3? 8.4) you can use the
new upgrade tools moving forward to minimize downtime during the upgrade
process but you will *always* need to test and evaluate before deploying.
Cheers,
Steve
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-sql@postgresql.org
Cc: scrawford@pinpointresearch.com, chris@thetrafalgartravel.com
Subject: Re: Simple Upgrade from PostgreSQL version 8.1.11 (With schemas)
In-Reply-To: <4FFC4C76.8090203@pinpointresearch.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