[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

BCP Postgres upgrade 6.5-->7.2


I have a database running on potato using postgres 6.5 that I'd like to upgrade to Woody running postgres 7.2.

The docs seem to imply that upgrading with this big a jump from 6.5 to 7.2 is dangerous.....even if I do it by hand like so:

pg_dump mydatabase > dump.mydatabase
destroydb mydatabase
upgrade the database system to 7.2
createdb mydatabase
psql < dump.mydatabase

Can this large jump be made safely?

If not, I don't see any other versions of postgres available for debian...so how should it be done in smaller increments?

Do my steps above look reasonable?

Thanks, Henry Hollenberg   hgh@jam.rr.com

Reply to: