Hacker News new | ask | show | jobs
by mh- 1460 days ago
Yes. Put concisely: Use the client tools from the newest version involved for all steps.
1 comments
oblio 1460 days ago
Isn't that impractical for most Linux distros? You'd need to manually install the new client.
link
BGZq7 1460 days ago
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).
link
mh- 1460 days ago
Probably? Certainly if you rely on distro packaging for it, yes.

I was just trying to simplify the guidance here. :)

link