Sample B — AWS worked example — Single RDS PostgreSQL 12 instance in US East (Ohio) reproducing the AWS pricing-page example: $0.100/vCPU-hr to 28 Feb 2027, then $0.200 from 1 Mar 2027 (4 vCPUs = $292/month, then $584/month at 730 h).

Pgpilot report

As of Sat 21 Nov 2026 · Planning aid, not a vendor quote.

Download Markdown · Download CSV · Plan another fleet

1 of 1 database will pay for Extended Support: 1 is already paying for Extended Support (since 1 Mar 2025). If nothing moves: $298/month from 1 Dec 2026, $8,160 by 29 Feb 2028. Start with aws-worked-example-db (already paying).

Fleet total if nothing upgrades: $8,160 to 29 Feb 2028. Saving if all upgrade before their first charge: $0.

Monthly figures use 730 hours/month; totals to a deadline use exact hours between dates. Partial hours/minimums follow each provider's bill.

Fleet

DatabaseProvider/regionVersionCommunity EOLStandard endFirst chargeDays leftMonthly if slipTargetBlockersStatus
aws-worked-example-dbRDS us-east-212.22Thu 21 Nov 2024Fri 28 Feb 2025Sat 1 Mar 2025-630$292180overdue

Monthly fleet cost

MonthFleet cost
November 2026$288
December 2026$298
January 2027$298
February 2027$269
March 2027$595
April 2027$576
May 2027$595
June 2027$576
July 2027$595
August 2027$595
September 2027$576
October 2027$595
November 2027$576
December 2027$595
January 2028$595
February 2028$538

Blockers

aws-worked-example-db (PG12 → 18)

Enrolled in Extended Support: charges run from the first charge date until you upgrade or delete the database.

Charges begin the day after the RDS end of standard support date for enrolled databases. Disabling enrolment when already past that date triggers an automatic upgrade.

Release-note changes by jump

12 → 18

Next steps

  1. Sat 28 Nov 2026 [aws-worked-example-db] Week of 28 Nov 2026: rehearse the 12 → 18 upgrade on a snapshot-restored copy of aws-worked-example-db (staging rehearsal first, production last). (rds-upgrade-prechecks)
  2. Sat 19 Dec 2026 [aws-worked-example-db] By 19 Dec 2026: upgrade aws-worked-example-db (prod) to PostgreSQL 18 — already paying Extended Support since Sat 1 Mar 2025; each month costs $292. (aws-calendar)
  3. Sat 19 Dec 2026 [aws-worked-example-db] After upgrading aws-worked-example-db: run ANALYZE, update extensions to their target versions, and recreate any logical replication slots you dropped. (rds-upgrade-prechecks)

CTO brief

# Postgres upgrade plan — I need a decision before the first Extended Support bill

I have audited our 1 Postgres database as of 21 Nov 2026. 1 of them will start paying for Extended Support, first on 1 Mar 2025. PostgreSQL 14 reached community end of life on 12 Nov 2026 and our clouds now charge to keep running it.

## What waiting costs

- If nothing moves, Extended Support costs us **$8,160** in total to 29 Feb 2028, peaking at **$595 in March 2027**.
- If I upgrade everything before its first charge date, we save **$0** of that.
- Our most expensive database to delay is **aws-worked-example-db** at **$292 per month**, so I want to move it first.

## What I am asking for

I need approval to run the dated upgrade plan below: rehearse each upgrade on a snapshot copy, do staging before production, and finish each production upgrade at least two weeks before its first charge date where that date is still ahead of us — and within four weeks for databases already paying. I also need a short maintenance window per production database. If we slip, the meter is already priced — each month of delay is a bill, not a backlog item.

## What could block us

- **aws-worked-example-db**: PG17: Rename I/O block read/write timing statistics columns of pg_stat_statements (release-17); 23 other release-note changes for 12 → 18 — see 'Release-note changes by jump' in the full report.

## The plan

- **28 Nov 2026** — Week of 28 Nov 2026: rehearse the 12 → 18 upgrade on a snapshot-restored copy of aws-worked-example-db (staging rehearsal first, production last).
- **19 Dec 2026** — By 19 Dec 2026: upgrade aws-worked-example-db (prod) to PostgreSQL 18 — already paying Extended Support since Sat 1 Mar 2025; each month costs $292.
- **19 Dec 2026** — After upgrading aws-worked-example-db: run ANALYZE, update extensions to their target versions, and recreate any logical replication slots you dropped.

I will report back after the first rehearsal with timings and any extension blockers I find. The full per-database breakdown, blockers and sources are in the Pgpilot report this brief came from.

— Sam, Platform Engineering

Pgpilot · Daily Ships · Planning aid, not a vendor quote. Dates and Extended Support rates follow postgresql.org, AWS, Microsoft and Google Cloud documentation (checked 21 Nov 2026); your provider's bill and console decide.

Why not just use…

Sources