Submitted by Scott (not verified) on Fri, 2008-02-15 09:49.
Actually, the dump restore is pretty common with databases.
Where I used to work we were upgrading from Oracle 9i to 10g. You can bet there was a migration plan, and it took literally weeks to prepare for it. Dumping and restoring was a part of that plan. In fact, Oracle was far more difficult to upgrade than pgsql was.
Due to the way pgsql is made, it's unlikely that dump/restore for major version upgrades is going away anytime soon.
Note that it's considered best to dump from the version you're going TO, not FROM, so it's handy to have both versions installed at once.
On debian / ubuntu, it's easy to do and there's a command pg_upgradecluster that takes as argument the versions and the locations of the two clusters (a pg installation is called a cluster) and then initdbs the new one like the old one, and initiates a pg_dumpall from the old to the new and voila, you're migrated. Really, it's pretty seamless.
»
Reply
Search
Windows for Intel Macs
Todd Ogasawara's Windows for Intel Macs ($7.99USD published by O'Reilly Media) is for Intel Mac users running Bootcamp or Parallels who want to learn more about running Microsoft Windows XP on Mac. It also provides specific tips and hints for using Parallels Desktop for Mac.
Actually, the dump restore
Actually, the dump restore is pretty common with databases.
Where I used to work we were upgrading from Oracle 9i to 10g. You can bet there was a migration plan, and it took literally weeks to prepare for it. Dumping and restoring was a part of that plan. In fact, Oracle was far more difficult to upgrade than pgsql was.
Due to the way pgsql is made, it's unlikely that dump/restore for major version upgrades is going away anytime soon.
Note that it's considered best to dump from the version you're going TO, not FROM, so it's handy to have both versions installed at once.
On debian / ubuntu, it's easy to do and there's a command pg_upgradecluster that takes as argument the versions and the locations of the two clusters (a pg installation is called a cluster) and then initdbs the new one like the old one, and initiates a pg_dumpall from the old to the new and voila, you're migrated. Really, it's pretty seamless.