5 ms·
I love PG, and don't plan to ever move away from it. But I'm starting to wish they had in-place upgrades. Application I develop is getting to the point of "to
by warbiscuit 11y ago
I love PG, and don't plan to ever move away from it.
But I'm starting to wish they had in-place upgrades. Application I develop is getting to the point of "too large to make a copy of the whole db whenever I want to upgrade Postgres".
I can postpone things for a little while by replacing all our large objects with a external file storage -- but the tables themselves are growing quickly.
That'd be my favorite "big data" feature.
- tsuraan 11y agoYou can run pg_upgrade with the --link option to have it hardlink most of the tables into the new cluster's location. It'll still re-write some things, but I believe that most of the actual table data remains unaltered.
- jeltz 11y agoYeah, unless you have huge system catalogs (where the table definitions are stored) pg_upgrade should be almost instant if you sue hardlinks.
- warbiscuit 11y agoThat's beautiful. Had no idea about that option.