We do it over the weekend. Or at night. Or both. It's not fun, but we can handle it once every year and a half. I considered using Slony replication the last t

We do it over the weekend. Or at night. Or both. It's not fun, but we can handle it once every year and a half. I considered using Slony replication the last time we were upgrading to copy data between the databases, but I figured it doesn't make much difference and did a dump/restore instead.