26 ms·
One thing I've never liked about postgres is that for any major version upgrade (8.3 -> 8.4) you need to do a full dump and restore of all your data. How do peo
by chrisbolt 18y ago
One thing I've never liked about postgres is that for any major version upgrade (8.3 -> 8.4) you need to do a full dump and restore of all your data. How do people handle this?
- nimbix 18y agoWe 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.
- boundlessdreamz 18y agooh! So what happens when you run apt-get upgrade or something similar ? 1. Will the upgrade fails because there are running databases? 2. Or can you dump using the new DB version and restore again ? Upgrading mysql was a breeze.