PostgreSQL 17
Current patch release: 17.9
End of life in 1,347 days (November 8, 2029). Plan your upgrade now.
September 26, 2024
Ongoing
November 8, 2029
17.9 (February 23, 2026)
About PostgreSQL 17
PostgreSQL 17 focused on performance and developer experience, with incremental backup support, faster B-tree index scans, and improved JSON capabilities.
Key Changes in PostgreSQL 17
- ●Incremental backup support via pg_basebackup for smaller, faster backups
- ●Faster B-tree index scans with optimized memory management
- ●Enhanced JSON support with
JSON_TABLEfunction - ●Improved COPY performance (up to 2x faster for bulk data loading)
- ●New SQL/JSON query functions for standards compliance
Breaking Changes
- ▲Removed support for running pg_upgrade from pre-10 versions
PostgreSQL 17 is currently under active support, released on September 26, 2024. It receives regular bug fixes, security patches, and may still get minor feature additions. The latest patch release is 17.9 (February 23, 2026).
Migration Notes
Use pg_upgrade for major version upgrades. Always test the upgrade on a staging instance first. Review pg_upgrade --check output carefully. Key areas to validate: custom extensions, replication setup, and connection pooler compatibility.
Lifecycle Progress
28% through its lifecycle. 1,347 days remaining.
All PostgreSQL Versions
| Version | Released | EOL | Latest | Status |
|---|---|---|---|---|
| 18 | September 25, 2025 | November 14, 2030 | 18.3 | Active |
| 17 (current page) | September 26, 2024 | November 8, 2029 | 17.9 | Active |
| 16 | September 14, 2023 | November 9, 2028 | 16.13 | Active |
| 15 | October 13, 2022 | November 11, 2027 | 15.17 | Active |
| 14 | September 30, 2021 | November 12, 2026 | 14.22 | Active |
| 13 | September 24, 2020 | November 13, 2025 | 13.23 | End of Life |
| 12 | October 3, 2019 | November 21, 2024 | 12.22 | End of Life |
| 11 | October 18, 2018 | November 9, 2023 | 11.22 | End of Life |
| 10 | October 5, 2017 | November 10, 2022 | 10.23 | End of Life |
| 9.6 | September 29, 2016 | November 11, 2021 | 9.6.24 | End of Life |
| 9.5 | January 7, 2016 | February 11, 2021 | 9.5.25 | End of Life |
| 9.4 | December 18, 2014 | February 13, 2020 | 9.4.26 | End of Life |
| 9.3 | September 9, 2013 | November 8, 2018 | 9.3.25 | End of Life |
| 9.2 | September 10, 2012 | November 9, 2017 | 9.2.24 | End of Life |
| 9.1 | September 12, 2011 | October 27, 2016 | 9.1.24 | End of Life |
| 9.0 | September 20, 2010 | October 8, 2015 | 9.0.23 | End of Life |
| 8.4 | July 1, 2009 | July 24, 2014 | 8.4.22 | End of Life |
| 8.3 | February 4, 2008 | February 7, 2013 | 8.3.23 | End of Life |
| 8.2 | December 5, 2006 | December 5, 2011 | 8.2.23 | End of Life |
| 8.1 | November 8, 2005 | November 8, 2010 | 8.1.23 | End of Life |
| 8.0 | January 19, 2005 | October 1, 2010 | 8.0.26 | End of Life |
| 7.4 | November 17, 2003 | October 1, 2010 | 7.4.30 | End of Life |
| 7.3 | November 27, 2002 | November 27, 2007 | 7.3.21 | End of Life |
| 7.2 | February 4, 2002 | February 4, 2007 | 7.2.8 | End of Life |
| 7.1 | April 13, 2001 | April 13, 2006 | 7.1.3 | End of Life |
| 7.0 | May 8, 2000 | May 8, 2005 | 7.0.3 | End of Life |
| 6.5 | June 9, 1999 | June 9, 2004 | 6.5.3 | End of Life |
| 6.4 | October 30, 1998 | October 30, 2003 | 6.4.2 | End of Life |
| 6.3 | March 1, 1998 | March 1, 2003 | 6.3.2 | End of Life |
Frequently Asked Questions
When was PostgreSQL 17 released?
When does PostgreSQL 17 reach end of life?
What is the latest patch version of PostgreSQL 17?
Related Resources
Get release updates for PostgreSQL
Breaking changes, security patches, EOL warnings. Monthly digest, no spam.
Free forever. Unsubscribe anytime. We track 50+ technologies.