Migration from 8.2 to 8.4 or major version migration and how postgres db is handled?

From: Omer Faruk SEN <omerfsen(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Migration from 8.2 to 8.4 or major version migration and how postgres db is handled?
Date: 2013-12-27 12:20:56
Message-ID: CAG+r6L9RJ8KxsHp7yKgnnu_cWqfmXgVkpGJ5=Q5NffadRa5Q6Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I have a question in mind. I have read

http://www.postgresql.org/docs/8.4/static/migration.html

and still it is not clear for me. The question is that

http://www.postgresql.org/docs/8.4/static/migration.html states first do a

pg_dumpall (which contains postgres db) Just in case I have made

pg_dumpall --clean --inserts (--insert is not required though) on Pgsql 8.2

Then on target machine which contains 8.4 I have issued

psql -f backup postgres

command.

My question here is that with import command my backup file contains
postgres db which may NOT be compatible with 8.4 since this
dump is for 8.2

So how this incompatibility is resolved? AFAIK major versions are not
compatible and requires dump/restore but how postgres table (aside
from other db that we have created) is handled?

Regards.

Browse pgsql-admin by date

  From Date Subject
Next Message Milos Gajdos 2014-01-01 16:07:32 9.1 to 9.2 upgrade surprises
Previous Message olimaz 2013-12-23 17:35:03 Re: HOT Standby - slave does not appear to be removing wal files