Versioning Policy

The PostgreSQL Global Development Group releases a new major version containing new features about once a year. Each major version receives bug fixes and, if need be, security fixes that are released at least once every three months in what we call a "minor release." For more information on the minor release schedule, you can view the minor release roadmap.

If the release team determines that a critical bug or security fix is too important to wait until the regularly scheduled minor release, it may make a release available outside of the minor release roadmap.

The PostgreSQL Global Development Group supports a major version for 5 years after its initial release. After this, a final minor version will be released and the software will then be unsupported (end-of-life).

Version Numbering

Starting with PostgreSQL 10, a major version is indicated by increasing the first part of the version, e.g. 10 to 11. Before PostgreSQL 10, a major version was indicated by increasing either the first or second part of the version number, e.g. 9.5 to 9.6.

Minor releases are numbered by increasing the last part of the version number. Beginning with PostgreSQL 10, this is the second part of the version number, e.g. 10.0 to 10.1; for older versions this is the third part of the version number, e.g. 9.5.3 to 9.5.4.

Upgrading

Major versions make complex changes, so the contents of the data directory cannot be maintained in a backward compatible way. A dump/reload of the database or use of the pg_upgrade application is required for major upgrades. We also recommend reading the upgrading section of the major version you are planning to upgrade to. You can upgrade from one major version to another without upgrading to intervening versions, but we recommend reading the release notes of all intervening major versions prior to doing so.

Minor release upgrades do not require a dump and restore; you simply stop the database server, install the updated binaries, and restart the server. Such upgrades might require additional steps so always read the release notes first.

Minor releases only contain fixes for frequently-encountered bugs, low-risk fixes, security issues, and data corruption problems. The community considers performing minor upgrades to be less risky than continuing to run an old minor version.

We recommend that users always run the current minor release associated with their major version.

Releases

VersionCurrent minorSupportedFirst ReleaseFinal Release
1717.4YesSeptember 26, 2024November 8, 2029
1616.8YesSeptember 14, 2023November 9, 2028
1515.12YesOctober 13, 2022November 11, 2027
1414.17YesSeptember 30, 2021November 12, 2026
1313.20YesSeptember 24, 2020November 13, 2025
1212.22NoOctober 3, 2019November 21, 2024
1111.22NoOctober 18, 2018November 9, 2023
1010.23NoOctober 5, 2017November 10, 2022
9.69.6.24NoSeptember 29, 2016November 11, 2021
9.59.5.25NoJanuary 7, 2016February 11, 2021
9.49.4.26NoDecember 18, 2014February 13, 2020
9.39.3.25NoSeptember 9, 2013November 8, 2018
9.29.2.24NoSeptember 10, 2012November 9, 2017
9.19.1.24NoSeptember 12, 2011October 27, 2016
9.09.0.23NoSeptember 20, 2010October 8, 2015
8.48.4.22NoJuly 1, 2009July 24, 2014
8.38.3.23NoFebruary 4, 2008February 7, 2013
8.28.2.23NoDecember 5, 2006December 5, 2011
8.18.1.23NoNovember 8, 2005November 8, 2010
8.08.0.26NoJanuary 19, 2005October 1, 2010
7.47.4.30NoNovember 17, 2003October 1, 2010
7.37.3.21NoNovember 27, 2002November 27, 2007
7.27.2.8NoFebruary 4, 2002February 4, 2007
7.17.1.3NoApril 13, 2001April 13, 2006
7.07.0.3NoMay 8, 2000May 8, 2005
6.56.5.3NoJune 9, 1999June 9, 2004
6.46.4.2NoOctober 30, 1998October 30, 2003
6.36.3.2NoMarch 1, 1998March 1, 2003
close