pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedSimple Upgrade from PostgreSQL version 8.1.11 (With schemas)
4+ messages / 4 participants
[nested] [flat]
* Simple Upgrade from PostgreSQL version 8.1.11 (With schemas)
@ 2012-07-10 15:28 Chris Preston <chris@thetrafalgartravel.com>
0 siblings, 3 replies; 4+ messages in thread
From: Chris Preston @ 2012-07-10 15:28 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Simple Upgrade from PostgreSQL version 8.1.11 (With schemas)
@ 2012-07-10 15:38 Steve Crawford <scrawford@pinpointresearch.com>
parent: Chris Preston <chris@thetrafalgartravel.com>
2 siblings, 0 replies; 4+ messages in thread
From: Steve Crawford @ 2012-07-10 15:38 UTC (permalink / raw)
To: Chris Preston <chris@thetrafalgartravel.com>; +Cc: pgsql-sql
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Simple Upgrade from PostgreSQL version 8.1.11 (With schemas)
@ 2012-07-11 03:41 Craig Ringer <ringerc@ringerc.id.au>
parent: Chris Preston <chris@thetrafalgartravel.com>
2 siblings, 0 replies; 4+ messages in thread
From: Craig Ringer @ 2012-07-11 03:41 UTC (permalink / raw)
To: Chris Preston <chris@thetrafalgartravel.com>; +Cc: pgsql-sql
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Simple Upgrade from PostgreSQL version 8.1.11 (With schemas)
@ 2012-07-14 03:22 Jasen Betts <jasen@xnet.co.nz>
parent: Chris Preston <chris@thetrafalgartravel.com>
2 siblings, 0 replies; 4+ messages in thread
From: Jasen Betts @ 2012-07-14 03:22 UTC (permalink / raw)
To: pgsql-sql
On 2012-07-10, Chris Preston <chris@thetrafalgartravel.com> 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?
8.1.23
going to 8.2.x or later is going to need more effort, especially if any
of your code relies on any of 8.1's quirks (like comparing integers to
strings) - if you do decide to abandon 8.1.x you may as well make it a
big change and go to 9.1
--
⚂⚃ 100% natural
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2012-07-14 03:22 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-07-10 15:28 Simple Upgrade from PostgreSQL version 8.1.11 (With schemas) Chris Preston <chris@thetrafalgartravel.com>
2012-07-10 15:38 ` Steve Crawford <scrawford@pinpointresearch.com>
2012-07-11 03:41 ` Craig Ringer <ringerc@ringerc.id.au>
2012-07-14 03:22 ` Jasen Betts <jasen@xnet.co.nz>
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