PostgreSQL Version History

5 active, 24 end-of-life. 29 versions tracked.

PostgreSQL releases a new major version every year in the fall, typically September or October. The project has maintained this annual cadence since PostgreSQL 10 (2017). Each major version is supported for 5 years.

Recommendation

For new deployments, use PostgreSQL 18. It's the latest stable release with the longest support window (through November 2030).

Version Released End of Life Latest Patch Status
PostgreSQL 18 September 25, 2025 November 14, 2030 18.3 Active
PostgreSQL 17 September 26, 2024 November 8, 2029 17.9 Active
PostgreSQL 16 September 14, 2023 November 9, 2028 16.13 Active
PostgreSQL 15 October 13, 2022 November 11, 2027 15.17 Active
PostgreSQL 14 September 30, 2021 November 12, 2026 14.22 Active
PostgreSQL 13 September 24, 2020 November 13, 2025 13.23 End of Life
PostgreSQL 12 October 3, 2019 November 21, 2024 12.22 End of Life
PostgreSQL 11 October 18, 2018 November 9, 2023 11.22 End of Life
PostgreSQL 10 October 5, 2017 November 10, 2022 10.23 End of Life
PostgreSQL 9.6 September 29, 2016 November 11, 2021 9.6.24 End of Life
PostgreSQL 9.5 January 7, 2016 February 11, 2021 9.5.25 End of Life
PostgreSQL 9.4 December 18, 2014 February 13, 2020 9.4.26 End of Life
PostgreSQL 9.3 September 9, 2013 November 8, 2018 9.3.25 End of Life
PostgreSQL 9.2 September 10, 2012 November 9, 2017 9.2.24 End of Life
PostgreSQL 9.1 September 12, 2011 October 27, 2016 9.1.24 End of Life
PostgreSQL 9.0 September 20, 2010 October 8, 2015 9.0.23 End of Life
PostgreSQL 8.4 July 1, 2009 July 24, 2014 8.4.22 End of Life
PostgreSQL 8.3 February 4, 2008 February 7, 2013 8.3.23 End of Life
PostgreSQL 8.2 December 5, 2006 December 5, 2011 8.2.23 End of Life
PostgreSQL 8.1 November 8, 2005 November 8, 2010 8.1.23 End of Life
PostgreSQL 8.0 January 19, 2005 October 1, 2010 8.0.26 End of Life
PostgreSQL 7.4 November 17, 2003 October 1, 2010 7.4.30 End of Life
PostgreSQL 7.3 November 27, 2002 November 27, 2007 7.3.21 End of Life
PostgreSQL 7.2 February 4, 2002 February 4, 2007 7.2.8 End of Life
PostgreSQL 7.1 April 13, 2001 April 13, 2006 7.1.3 End of Life
PostgreSQL 7.0 May 8, 2000 May 8, 2005 7.0.3 End of Life
PostgreSQL 6.5 June 9, 1999 June 9, 2004 6.5.3 End of Life
PostgreSQL 6.4 October 30, 1998 October 30, 2003 6.4.2 End of Life
PostgreSQL 6.3 March 1, 1998 March 1, 2003 6.3.2 End of Life
View PostgreSQL Hub Page →

PostgreSQL Support Policy

PostgreSQL provides 5 years of support for each major version. During this period, the community releases quarterly updates with bug fixes and security patches. After the 5-year window, the version becomes unsupported and receives no further updates.

What You Need to Know

PostgreSQL 14 reaches end-of-life in November 2026. Plan your upgrade to 16, 17, or 18.

PostgreSQL 18 is the latest release with improved performance, partitioning, and JSON functionality.

Major version upgrades require running pg_upgrade or pg_dump/restore. They can't be done with a simple package update.

PostgreSQL 17, 16, and 15 are also fully supported with years of remaining support.

Frequently Asked Questions

How often does PostgreSQL release new versions?
PostgreSQL ships a new major version annually, usually in September or October. Minor releases (bug fix patches) come out quarterly, typically in February, May, August, and November.
Which PostgreSQL version should I use in 2026?
PostgreSQL 17 is the best choice for new installations. It has the longest remaining support window (until 2029) and includes the latest performance improvements. PostgreSQL 16 and 15 are also fully supported.
How do I upgrade PostgreSQL major versions?
Use pg_upgrade for in-place upgrades (faster, less downtime) or pg_dump/pg_restore for a clean migration. Unlike minor version updates, major version upgrades can't be done with a simple package update because they change the data storage format.
How long is each PostgreSQL version supported?
Each major version gets exactly 5 years of support from its initial release. During this time, the community provides quarterly patch releases with bug fixes and security updates.

Related Tools

Get PostgreSQL release alerts

New releases, EOL warnings, security patches. Monthly digest, no spam.

Free forever. Unsubscribe anytime.