pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Craig Ringer <ringerc@ringerc.id.au>
To: Chris Preston <chris@thetrafalgartravel.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Simple Upgrade from PostgreSQL version 8.1.11 (With schemas)
Date: Wed, 11 Jul 2012 11:41:01 +0800
Message-ID: <4FFCF5CD.8080100@ringerc.id.au> (raw)
In-Reply-To: <3EED475E754849429C74FCAB58B57CFF@chrisp>
References: <CACi+J=Tkm0v9djUMr6gFN4sav6rMFX4s2ARegAuXLL82d=oL3g@mail.gmail.com>
	<4FEE0DCB.8020503@gmail.com>
	<3EED475E754849429C74FCAB58B57CFF@chrisp>

On 07/10/2012 11:28 PM, 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?

Not very, unless your database and queries are very simple.

At minimum you'll have to deal with the removal of implicit casts to 
text ( 
http://www.postgresql.org/docs/current/static/release-8-3.html#AEN116407) and, 
if you use bytea, the change of default bytea format ( 
<http://www.postgresql.org/docs/9.0/static/runtime-config-client.html#GUC-BYTEA-OUTPUT; 
http://www.postgresql.org/docs/current/static/release-9-0.html#AEN109764).

In general, you will want to read the "Migration to" notes for each version:

http://www.postgresql.org/docs/current/static/release-8-2.html 
<http://www.postgresql.org/docs/current/static/release-9-0.html;
http://www.postgresql.org/docs/current/static/release-8-3.html 
<http://www.postgresql.org/docs/current/static/release-9-0.html;
http://www.postgresql.org/docs/current/static/release-8-4.html 
<http://www.postgresql.org/docs/current/static/release-9-0.html;
http://www.postgresql.org/docs/current/static/release-9-0.html
http://www.postgresql.org/docs/current/static/release-9-1.html 
<http://www.postgresql.org/docs/current/static/release-9-0.html;

Alternately, you could try using PostgreSQL 9.1's pg_dump on your 8.1 
database, load the dump into a 9.1 instance, run your client against it 
and see what breaks. For simpler apps that can be a reasonable choice.

--
Craig Ringer

view thread (4+ messages)  latest in thread

Message-ID: <4FFCF5CD.8080100@ringerc.id.au>
Permalink:  ../4FFCF5CD.8080100@ringerc.id.au/
Also on:    postgresql.org/message-id/4FFCF5CD.8080100@ringerc.id.au

 · 

reply
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: ringerc@ringerc.id.au, chris@thetrafalgartravel.com
  Subject: Re: Simple Upgrade from PostgreSQL version 8.1.11 (With schemas)
  In-Reply-To: <4FFCF5CD.8080100@ringerc.id.au>

* 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