Thread: Migrating Postgresql 8.0 to 8.3

Hello Friends,

I would like to migrate postgresql 8.0 to 8.3. Please suggest me the best way of restoring my backup.

In which format should I take the backup and how should I restore the data. Does it require to write any sql script. will it create any problems in migrating 8.0 to 8.3.

Looking forward to hearing from you soon,

Best Regards,

Krishna

quickinfo wrote:
> I would like to migrate postgresql 8.0 to 8.3. Please suggest me the
best way of restoring my backup.
>
> In which format should I take the backup and how should I restore the
data. Does it require to write
> any sql script. will it create any problems in migrating 8.0 to 8.3.

Follow there directions:
http://www.postgresql.org/docs/8.3/static/install-upgrading.html

There is one behaviour change in 8.3 that caused problems for many
people:
http://www.postgresql.org/docs/8.3/static/release-8-3.html#AEN87860
Read the first point.

If that is a problem for you, read this:
http://petereisentraut.blogspot.co.at/2008/03/readding-implicit-casts-in
-postgresql.html

You should definitely upgrade to 9.1 and not to 8.3

Yours,
Laurenz Albe

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