How to Upgrade AWS RDS PostgreSQL With Extensions(4)

In another three posts, we have upgraded from AWS PostgreSQL RDS 9.5 to 9.6, 9.6 to 10.15, and 10.15 to 11.10 respectively.

how to Upgrade AWS RDS PostgreSQL with Extensions(1) from 9.5 to 9.6
How to Upgrade AWS RDS PostgreSQL with Extensions(2) from 9.6 to 10.15
How to Upgrade AWS RDS PostgreSQL with Extensions(3) from 10.15 to 11.10

According to AWS doc about PostGIS extension:

If a database uses the PostGIS extension, you can’t skip major versions for some source to target combinations. For these circumstances, upgrade in steps to the next major version one step at a time until you reach the desired target version.

So in this post, we will show how to upgrade AWS PostgreSQL RDS 11.10 with PostGIS extension to AWS PostgreSQL RDS 12.5.

Subscribe to get access

Read more of this content when you subscribe today.