Hacker News new | ask | show | jobs
by ComputerGuru 1119 days ago
pg_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.
2 comments

Well, 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

Arch Linux e.g. solved this by having a `postgresql-old-upgrade` package.