Re: Migrating Postgresql 8.0 to 8.3

From: Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>
To: quickinfo <quickinfo123(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Migrating Postgresql 8.0 to 8.3
Date: 2012-08-13 13:33:56
Message-ID: 50290244.4090209@ringerc.id.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 08/13/2012 08:40 PM, quickinfo wrote:
> Hello Friends,
>
> I would like to migrate postgresql 8.0 to 8.3. Please suggest me the
> best way of restoring my backup.

If at all possible, use the 8.3 version of pg_dump to make a new backup
from your 8.0 server, rather than trying to restore a dump from 8.0 to 8.3.

Also, please consider 8.3 as a stepping stone to 9.1, which should be
your migration target. 8.3 will be leaving support early next year:

http://www.postgresql.org/support/versioning/

so it is not a good choice for an upgrade target.

--
Craig Ringer

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2012-08-13 15:58:33 Re: json support for composites in upcoming 9.2
Previous Message Albe Laurenz 2012-08-13 13:09:35 Re: Migrating Postgresql 8.0 to 8.3