4 ms·
Yeah, super easy. Let me just shut down my database server for 30 hours so I can do a dump and load.
by dingleberry420 4y ago
Yeah, super easy. Let me just shut down my database server for 30 hours so I can do a dump and load.
- Axsuul 4y agoHave you looked into `pg_upgrade —link`?
- dingleberry420 4y agoI know it, and it's the way to go after making backups. It's not that hard, but not trivial either. You have to install the old & new postgres versions alongside each other, shut the database down, etc. I've done it many times, it's not hard, but I wouldn't call it a "piece of cake". And it does require some downtime. Anyway, my comment was simply responding to the parent's: > Or you could just dump and load the database (maybe even pipe it from one to the next).