On 25.04.2011, at 09:27, my...@mware.ca 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?
Axel --- PGP-Key:29E99DD6 ☀ +49 151 2300 9283 ☀ computing @ chaos claudius