Skip to content

PostgreSQL

An advanced open-source relational database known for reliability, standards compliance and extensions such as PostGIS and pgvector.

  • Active project
  • Latest 18.7Nov 2026
  • Supported 4 versions
On this page

At a glance

Type
Database
Developer
PostgreSQL Global Development Group
First release
29 Jan 1997
Release cadence
Major release yearly (September/October); each supported for 5 years
Model
Object-relational (SQL)
Notable features
MVCC, JSONB, extensions (PostGIS, pgvector), logical replication
Written in
C
Runs on
Linux, Windows, macOS, BSD
Support
5 years per major version; minor releases every quarter
License
PostgreSQL License (BSD-style)

Newest release

PostgreSQL 18

Released 25 Sep 2025 · latest update 18.7

Support status

18 Supported

Until 14 Nov 2030 · in 4 years

17 Supported

Until 8 Nov 2029 · in 2.5 years

16 Supported

Until 9 Nov 2028 · in 1.5 years

15 Supported

Until 11 Nov 2027 · in 11 months

14 End of life

Ended 12 Nov 2026 · 1 day ago

Release history

VersionReleasedLatestEnd of lifeStatus
1825 Sep 202518.714 Nov 2030Supported
1726 Sep 202417.128 Nov 2029Supported
1614 Sep 202316.169 Nov 2028Supported
1513 Oct 202215.2011 Nov 2027Supported
1430 Sep 202114.2512 Nov 2026End of life
1324 Sep 202013.2313 Nov 2025End of life
123 Oct 201912.2221 Nov 2024End of life
1118 Oct 201811.229 Nov 2023End of life
105 Oct 201710.2310 Nov 2022End of life
9.629 Sep 20169.6.2411 Nov 2021End of life
9.57 Jan 20169.5.2511 Feb 2021End of life
9.418 Dec 20149.4.2613 Feb 2020End of life
9.39 Sep 20139.3.258 Nov 2018End of life
9.210 Sep 20129.2.249 Nov 2017End of life
9.112 Sep 20119.1.2427 Oct 2016End of life
9.020 Sep 20109.0.238 Oct 2015End of life
8.41 Jul 20098.4.2224 Jul 2014End of life
8.34 Feb 20088.3.237 Feb 2013End of life
8.25 Dec 20068.2.235 Dec 2011End of life
8.18 Nov 20058.1.238 Nov 2010End of life
8.019 Jan 20058.0.261 Oct 2010End of life
7.417 Nov 20037.4.301 Oct 2010End of life
7.327 Nov 20027.3.2127 Nov 2007End of life
7.24 Feb 20027.2.84 Feb 2007End of life
7.113 Apr 20017.1.313 Apr 2006End of life
7.08 May 20007.0.38 May 2005End of life
6.59 Jun 19996.5.39 Jun 2004End of life
6.430 Oct 19986.4.230 Oct 2003End of life
6.31 Mar 19986.3.21 Mar 2003End of life
6.22 Oct 19976.2.1EndedEnd of life
6.18 Jun 19976.1.1EndedEnd of life
6.029 Jan 19976.0EndedEnd of life

Release data: endoflife.date and vendor announcements, checked 13 Nov 2026. Spotted a mistake? Tell us.

Support timeline

The 12 most recent releases, from release day to the end of support.

  • Active support
  • Today
18
17
16
15
14
13
12
11
10
9.6
9.5
9.4

History

PostgreSQL grew out of the POSTGRES research project led by Michael Stonebraker at the University of California, Berkeley, from 1986. In 1995 two students added an SQL interpreter and called it Postgres95. The following year it became an open-source community project named PostgreSQL. No single company controls it: development is coordinated by the PostgreSQL Global Development Group.

A major version comes out every year, and each is supported for five years with quarterly minor releases. Features such as JSONB, logical replication, and extensions like PostGIS and pgvector have made it the default choice for many new applications and cloud database services.

Milestones

  1. 1986Michael Stonebraker starts the POSTGRES project at UC Berkeley
  2. 1995Postgres95 replaces the QUEL query language with SQL
  3. 1997PostgreSQL 6.0 is the first release under the new name
  4. 2005PostgreSQL 8.0 runs natively on Windows
  5. 2010PostgreSQL 9.0 adds built-in streaming replication
  6. 2014PostgreSQL 9.4 introduces JSONB
  7. 2017PostgreSQL 10 adds logical replication and declarative partitioning
  8. 2025PostgreSQL 18 adds asynchronous I/O

PostgreSQL guides

Browse all 27 PostgreSQL guides →

Frequently asked questions

What is the latest version of PostgreSQL?

The newest PostgreSQL release is PostgreSQL 18, released on 25 Sep 2025. Its latest update is 18.7 (9 Nov 2026).

Which PostgreSQL versions are still supported?

As of 13 Nov 2026, 4 versions are supported: PostgreSQL 18 (until 14 Nov 2030); PostgreSQL 17 (until 8 Nov 2029); PostgreSQL 16 (until 9 Nov 2028); PostgreSQL 15 (until 11 Nov 2027).

Is PostgreSQL 14 still supported?

No. PostgreSQL 14 reached end of life on 12 Nov 2026 and no longer gets free security updates. Upgrade to PostgreSQL 18.

Compare PostgreSQL

← All software & operating systems

Back to top