PostgreSQL 16 vs 17

Support windows, end-of-life dates and latest versions side by side.

Which should you run?

Pick PostgreSQL 17 for new installs. It's supported until Nov 8, 2029, 11 months longer than 16, which ends Nov 9, 2028.

PostgreSQL 16 PostgreSQL 17
ReleasedSep 14, 2023Sep 26, 2024
StatusSupportedSupported
Active support until——
End of lifeNov 9, 2028
in 2 years
Nov 8, 2029
in 2 years
Total support5 years, 1 month5 years, 1 month
Latest version16.15
Aug 10, 2026
17.11
Aug 10, 2026
LTSNoNo

How to upgrade from PostgreSQL 16 to 17

Minor releases (e.g. 17.x to 17.11) never need a dump or pg_upgrade: install the packages and restart. A new major version does.

Ubuntu / Debian (PGDG repository)

sudo apt update
sudo apt install --only-upgrade postgresql-17
sudo systemctl restart postgresql

New major version on Ubuntu / Debian

sudo apt install postgresql-17
pg_lsclusters

Then run sudo pg_upgradecluster <old-version> main. It migrates the old cluster onto version 17.

Docker

docker pull postgres:17

Official upgrade guide ↗ Back up first, and test on a non-production machine when you move to a new branch.

Quick answers

Should I use PostgreSQL 16 or 17?
Pick PostgreSQL 17 for new installs. It's supported until Nov 8, 2029, 11 months longer than 16, which ends Nov 9, 2028.
How long are PostgreSQL 16 and 17 supported?
PostgreSQL 16: supported until Nov 9, 2028. PostgreSQL 17: supported until Nov 8, 2029.
What are the latest PostgreSQL 16 and 17 versions?
PostgreSQL 16 is at 16.15 (Aug 10, 2026), and PostgreSQL 17 is at 17.11 (Aug 10, 2026).

More PostgreSQL comparisons

Official release policy · Checked 5 hours ago