Amazon Web Services
docs.aws.amazon.com › amazon rds › user guide for aurora › working with amazon aurora postgresql › database engine updates for amazon aurora postgresql › using an aurora postgresql long-term support (lts) release
Using an Aurora PostgreSQL long-term support (LTS) release - Amazon Aurora
Learn about long-term support for your DB cluster engine for Aurora PostgreSQL.
PostgreSQL
postgresql.org › support › versioning
PostgreSQL: Versioning Policy
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.
Videos
17:09
Upgrade PostgreSQL 16 to 18 Effortlessly using pg_upgrade on Ubuntu ...
12:44
Upgrade PostgreSQL 17 to 18 Effortlessly using pg_upgrade on Ubuntu ...
10:53
Install PostgreSQL 16 with pgaudit Support on Ubuntu 24.04 LTS ...
23:33
How to Install PostgreSQL and PGAdmin on Ubuntu 24.04 LTS - YouTube
06:16
How to Install Postgres and Pgadmin on Ubuntu 24.04 LTS Linux - ...
GitHub
github.com › credativ › postgresql-lts › releases
Releases · credativ/postgresql-lts
The PostgreSQL community has stopped releasing updates for the 9.1.X release series in October 2016. This update is a Long-Term-Support (LTS) community effort by credativ GmbH and not an official release by the PostgreSQL community.
Author credativ
AWS re:Post
repost.aws › questions › QUIyM7xK7rSLqfQPm0SQUcxg › aurora-postgresql-16-lts
Aurora PostgreSQL 16 LTS | AWS re:Post
July 8, 2025 - LTS releases are supported for at least three years, compared to the typical 12-month support period for standard minor versions. For Aurora PostgreSQL 16, while the specific minor version that will be designated as LTS has not yet been explicitly identified in the release calendars, AWS follows this pattern for all major versions.
GitHub
github.com › credativ › postgresql-lts
GitHub - credativ/postgresql-lts: PostgreSQL long term support development · GitHub
Further information can be found here: https://github.com/credativ/postgresql-lts/wiki PostgreSQL is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, subqueries, triggers, user-defined types and functions.
Author credativ
PostgreSQL
postgresql.org › docs › release
PostgreSQL: Release Notes
Below is the complete archive of release notes for every version of PostgreSQL.
GitHub
github.com › credativ › postgresql-lts › blob › REL8_4_LTS › README
postgresql-lts/README at REL8_4_LTS · credativ/postgresql-lts
PostgreSQL Database Management System (8.4LTS branch)
Author credativ
End of Life Date
endoflife.date › postgresql
PostgreSQL | endoflife.date
May 14, 2026 - PostgreSQL, also known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing extensibility and technical standards compliance.
GitHub
github.com › credativ › postgresql-lts › blob › REL8_4_LTS › HISTORY
postgresql-lts/HISTORY at REL8_4_LTS · credativ/postgresql-lts
PostgreSQL long term support development. Contribute to credativ/postgresql-lts development by creating an account on GitHub.
Author credativ
Amazon Web Services
docs.aws.amazon.com › amazon rds › release notes for aurora postgresql › release calendars for aurora postgresql
Release calendars for Aurora PostgreSQL - Amazon Aurora
Plan major version upgrades and estimate when a new Aurora PostgreSQL major version will be available. Schedule minor version upgrades during your maintenance windows. Select the right Aurora Long-Term Support (LTS) version for workloads that require staying on the same minor version across ...
PostgreSQL
postgresql.org › download › linux › ubuntu
PostgreSQL: Linux downloads (Ubuntu)
The PostgreSQL Apt repository supports the current versions of Ubuntu: resolute (26.04, LTS) questing (25.10, non-LTS) noble (24.04, LTS) jammy (22.04, LTS) on the following architectures: amd64 · arm64 (LTS releases only) ppc64el (LTS releases only) sudo apt install -y postgresql-common sudo /usr/share/postgresql-common/pgdg/apt.postgresql.org.sh ·
Wikipedia
en.wikipedia.org › wiki › PostgreSQL
PostgreSQL - Wikipedia
June 4, 2026 - POHST-gres-kew-EL), also known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance. PostgreSQL features transactions with atomicity, consistency, isolation, durability (ACID) properties, automatically updatable views, ...
EnterpriseDB
enterprisedb.com › docs › postgres_for_kubernetes › latest
EDB Docs - EDB Postgres® AI for CloudNativePG™ Cluster v1.30.0
While we encourage customers to regularly upgrade to the latest version of the operator to take advantage of new features, having LTS versions allows customers desiring additional stability to stay on the same version for 12-18 months before upgrading. EDB Postgres® AI for CloudNativePG™ Cluster works with both PostgreSQL, EDB Postgres Extended and EDB Postgres Advanced server, and is available under the EDB End User License Agreement.
Reddit
reddit.com › r/postgresql › when is the time to upgrade postgresql?
r/PostgreSQL on Reddit: When is the time to upgrade PostgreSQL?
April 23, 2022 -
I'm using v12. When is the time to upgrade? I have no idea at all. I'm using PostgreSQL for my Django app. For Django, there is an LTS. Is it the same case for db?
Top answer 1 of 5
8
Upgrade mayor versions when postgres brings new features or improvements that would be useful for your business model, and upgrade minor versions whenever possible (unless it's an important security fix. Then upgrade fast) You can see the lts dates here https://www.postgresql.org/support/versioning/
2 of 5
7
Postgres currently supports the 5 most recent major releases. Given you are on 12, I would start the process immediately. I say "process", because it's always a good idea to have an upgrade playbook, and test it on a dev and stage environment with all apps that depend on it. Depending on the organization, this can take a very long time. I've seen companies that border on 2 years for various reasons. Others only need a month or two. You know your situation best. Meanwhile the clock is always ticking, so it's good you asked this question now rather than remain complacent. Imagine if you were at one of those companies that take forever to upgrade and you were on version 10. I've seen companies still on 9.4, or even 8.2 in extreme cases, that are just now scrambling to upgrade because they fell too far behind and are now desperate. That said, there's an upgrade path which isn't mentioned in the official documentation on the subject. You can create a logical replica between major versions starting with 10, or 9.4 if you use pglogical. This lets you run the new version in a separate cluster concurrently. The main benefit to this approach is the vastly reduced switch time between the versions, since all you need to do is change the database connection target of your apps. If you use a VIP or some kind of proxy like pgBouncer, that comes down to a handful of commands and takes seconds at most. I personally try to stay on a yearly cycle, because that's the same cadence Postgres uses. Nearly every September sees a new major version. If you always have a testing pipeline, you can be ready for the xx.1 release most tend to wait for. Unless there's a huge security or corruption bug, minor versions happen quarterly, giving you about 3 months to verify the new release in your stack. Good luck!
pgPedia
pgpedia.info › postgresql-versions › index.html
PostgreSQL major versions - pgPedia - a PostgreSQL Encyclopedia
PostgreSQL documentation PostgreSQL feature matrix PostgreSQL versioning policy PostgreSQL latest versions @pgpedia.info (Bluesky)