Extended suport postgree 12.19

Hi,

Based on this table, if you upgrade to v16, you are good until 2029 with Standard Support and until 2030 if you go with v17.

Source: https://docs.aws.amazon.com/AmazonRDS/latest/PostgreSQLReleaseNotes/postgresql-release-calendar.html

Best,

Didier

Thank you for your question about PostgreSQL versions and extended support on Amazon RDS. Let me clarify a few points for you.

First, you're correct that PostgreSQL 12.19 will reach end of standard support on February 28, 2025. It's good that you're planning ahead for this transition.

Regarding PostgreSQL 16.3, which is currently the latest version available on Amazon RDS, it's important to note that the end of standard support date for major version 16 is actually November 2028, not September 2025 as you mentioned. This gives you a much longer window of standard support than you initially thought.

When you upgrade to PostgreSQL 16.3, you will indeed be able to take advantage of future minor version upgrades within the 16.x series as they become available. These minor version upgrades often include important security patches and bug fixes.

As for extended support, Amazon RDS typically offers this for major versions that are nearing end of standard support. While extended support options may not be visible for version 16 right now, this is because it's still relatively new and far from its end of standard support date. Extended support options usually become available closer to the end of standard support date for a given major version.

It's also worth noting that Amazon RDS continually works on making newer PostgreSQL versions available. By the time you need to consider upgrading from version 16, there will likely be newer major versions available with even later support end dates.

For now, upgrading to PostgreSQL 16.3 would be a good move, as it will provide you with standard support until November 2028, which is a significant extension compared to your current version. As you approach that date, you'll have options to either upgrade to a newer major version that will be available by then or potentially use extended support if needed.

Remember to regularly check the Amazon RDS documentation and announcements for the most up-to-date information on PostgreSQL versions, support dates, and available upgrade paths.
Sources
Amazon RDS for PostgreSQL supports minor versions 16.3, 15.7, 14.12, 13.15, and 12.19
[Announcement] Amazon RDS for PostgreSQL 12 will reach end of standard support on February 28, 2025. Upgrade your database before March 1, 2025. | AWS re:Post
Amazon RDS Extended Support with Amazon RDS - Amazon Relational Database Service