PostgreSQL 17 vs 18
Which should you run?
Pick PostgreSQL 18 for new installs. It's supported until Nov 14, 2030, 1 year longer than 17, which ends Nov 8, 2029.
17
18
20242030
Supported
Security fixes only
Today
| PostgreSQL 17 | PostgreSQL 18 | |
|---|---|---|
| Released | Sep 26, 2024 | Sep 25, 2025 |
| Status | Supported | Supported |
| Active support until | — | — |
| End of life | Nov 8, 2029 in 2 years | Nov 14, 2030 in 4 years |
| Total support | 5 years, 1 month | 5 years, 1 month |
| Latest version | 17.11 Aug 10, 2026 | 18.6 Aug 11, 2026 |
| LTS | No | No |
How to upgrade from PostgreSQL 17 to 18
Minor releases (e.g. 18.x to 18.6) 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-18
sudo systemctl restart postgresql New major version on Ubuntu / Debian
sudo apt install postgresql-18
pg_lsclusters Then run sudo pg_upgradecluster <old-version> main. It migrates the old cluster onto version 18.
Docker
docker pull postgres:18 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 17 or 18?
- Pick PostgreSQL 18 for new installs. It's supported until Nov 14, 2030, 1 year longer than 17, which ends Nov 8, 2029.
- How long are PostgreSQL 17 and 18 supported?
- PostgreSQL 17: supported until Nov 8, 2029. PostgreSQL 18: supported until Nov 14, 2030.
- What are the latest PostgreSQL 17 and 18 versions?
- PostgreSQL 17 is at 17.11 (Aug 10, 2026), and PostgreSQL 18 is at 18.6 (Aug 11, 2026).
More PostgreSQL comparisons
Official release policy · Checked 6 hours ago