PostgreSQL 16 vs 17
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.
16
17
20232029
Supported
Security fixes only
Today
| PostgreSQL 16 | PostgreSQL 17 | |
|---|---|---|
| Released | Sep 14, 2023 | Sep 26, 2024 |
| Status | Supported | Supported |
| Active support until | — | — |
| End of life | Nov 9, 2028 in 2 years | Nov 8, 2029 in 2 years |
| Total support | 5 years, 1 month | 5 years, 1 month |
| Latest version | 16.15 Aug 10, 2026 | 17.11 Aug 10, 2026 |
| LTS | No | No |
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