Re:PostgreSQL upgrades are hard
by oblio on Saturday June 25, 2022 @02:48PM
(#31877675)
Isn't that impractical for most Linux distros? You'd need to manually install the new client.
[ Parent
| on HN ]
On Debian (and probably most of its derivatives), the package manager will not remove any running PostgreSQL versions and will let you have multiple versions side by side. It also has its own tool pg_upgradecluster, which can perform the upgrade using pg_dump+pg_restore or pg_upgrade (optionally with link or clone options).