On Mon, Apr 25, 2011, Axel Rau wrote: > > On 25.04.2011, at 09:27, [email protected] wrote: > > > I'm thinking about upgrading mine to 9, but I'm also realizing I'm looking > > at a multi-hour if not multi-day import window... > > My pg dumps are ~20GB at this point. Probably smaller than some others', > > but still a challenge. > > > > Thoughts? > pg_upgrade. I never did it, so I don't know how much faster it is. > The standard tool is Slony. Setup a 2nd cluster, init replication and keep it > running. Then upgrade the 2nd cluster to 9.0 with pg_upgrade, while > replication still running. At least you can have as many restarts of the > complete process as necessary w/o disturbing your production system... > Did anybody try Slony with aox?
+1 for pg_upgrade. Make sure you're using 9.0.4's version, there was a
nasty bug in previous versions that sneakily scrambled TOAST data:
http://wiki.postgresql.org/wiki/20110408pg_upgrade_fix
With that scariness out of the way, it shaved off at least a day of
upgrade time on a setup at my employer, did a 140GB data directory in
about an hour and a half.
--
Mahlon E. Smith
http://www.martini.nu/contact.html
pgpfcoZEbKphj.pgp
Description: PGP signature
