BCP Postgres upgrade 6.5-->7.2
Hello,
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: