Migrating Postgresql 8.0 to 8.3

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

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