How to Upgrade AWS RDS PostgreSQL With Extensions(5)

In another four posts, we have upgraded from AWS PostgreSQL RDS 9.5.23-R1 to 9.6.20-R1, 9.6.20-R1 to 10.15, 10.15 to 11.10 and 11.10 to 12.5 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
How to Upgrade AWS RDS PostgreSQL with Extensions(4) from 11.10 to 12.5

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 12.5 with PostGIS extension to AWS PostgreSQL RDS 13.1.

Subscribe to get access

Read more of this content when you subscribe today.

Tasks of After Major Version Upgrade

  • Run the ANALYZE operation to refresh the pg_statistic table.
  • Optionally, use Amazon RDS to view two logs that the pg_upgrade utility produces. These are pg_upgrade_internal.log and pg_upgrade_server.log. Amazon RDS appends a timestamp to the file name for these logs. You can view these logs as you can any other log. For more information, see Amazon RDS database log files.You can also upload the upgrade logs to Amazon CloudWatch Logs. For more information, see Publishing PostgreSQL logs to CloudWatch Logs.
  • To verify that everything works as expected, test your application on the upgraded database with a similar workload. After the upgrade is verified, you can delete this test instance.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.