PostgreSQL 17 vs 18

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

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.

PostgreSQL 17 PostgreSQL 18
ReleasedSep 26, 2024Sep 25, 2025
StatusSupportedSupported
Active support until——
End of lifeNov 8, 2029
in 2 years
Nov 14, 2030
in 4 years
Total support5 years, 1 month5 years, 1 month
Latest version17.11
Aug 10, 2026
18.6
Aug 11, 2026
LTSNoNo

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