How to upgrade postgresql from 14 to 17

Posted on In Views: Word count in article: 229 Reading time ≈ 1 mins.

Log into your server as root.

1
2
3
4
5
sudo apt install -y postgresql-common
sudo /usr/share/postgresql-common/pgdg/apt.postgresql.org.sh
sudo apt update
sudo apt install postgresql-17 postgresql-client-17
sudo pg_upgradecluster 14 main              # migrates 14 → 17 in place