Movatterモバイル変換


[0]ホーム

URL:


September 25, 2025: PostgreSQL 18 Released!

Quick Links

Versioning Policy

The PostgreSQL Global Development Group releases a new major version containingnew features about once a year. Each major version receives bug fixes and, ifneed be,security fixes that are released atleast once every three months in what we call a "minor release." For moreinformation on the minor release schedule, you can view theminor release roadmap.

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

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

Version Numbering

Starting with PostgreSQL 10, a major version is indicated by increasing thefirst part of the version, e.g. 10 to 11. Before PostgreSQL 10, a major versionwas indicated by increasing either the first or second part of the versionnumber, 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 versionnumber, e.g. 9.5.3 to 9.5.4.

Upgrading

Major versions make complex changes, so the contents of the data directorycannot be maintained in a backward compatible way. A dump/reload of thedatabase or use of thepg_upgrade application is requiredfor major upgrades. We also recommend reading theupgrading section of the majorversion you are planning to upgrade to. You can upgrade from one major versionto another without upgrading to intervening versions, but we recommend readingtherelease notes of all intervening majorversions 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
1818.0YesSeptember 25, 2025November 14, 2030
1717.6YesSeptember 26, 2024November 8, 2029
1616.10YesSeptember 14, 2023November 9, 2028
1515.14YesOctober 13, 2022November 11, 2027
1414.19YesSeptember 30, 2021November 12, 2026
1313.22YesSeptember 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

[8]ページ先頭

©2009-2025 Movatter.jp