4 ms·
This is an exciting release to be sure. Very happy to see that the CPU improvements include ARM, diversity is good! Given the current release pace, I'd love to
by tuetuopay 3y ago
This is an exciting release to be sure. Very happy to see that the CPU improvements include ARM, diversity is good!
Given the current release pace, I'd love to have another upgrade path than `pg_dump | psql`. That would remove a great deal of friction in prod.
- hans_castorp 3y ago> I'd love to have another upgrade path than `pg_dump | psql` pg_upgrade
- djbusby 3y agoOr logical replication to the new box then migrate traffic.
- ComputerGuru 3y agopg_upgrade is not an option on many systems if you are installing with the package manager as it requires both old and new binaries to be simultaneously present.
- dawidpotocki 3y agoArch Linux e.g. solved this by having a `postgresql-old-upgrade` package.
- hans_castorp 3y agoWell, that's a problem of the package manager, not a Postgres problem. At least with Ubuntu and RedHat/CentOS/Rocky/... installing two versions in parallel is absolutely no problem. I think Ubuntu even wraps that into their upgrade scripts and you can pass an option to use pg_upgrade or pg_dump/pg_restore
- jeltz 3y agoThere is pg_upgrade and logical replication. I have used both and they both work excellently. Logical replication can be a bit of a hassle to set up though, especially if the database is huge.