awsdocs / amazon-rds-user-guide

The open source version of the Amazon RDS docs. You can submit feedback & requests for changes by submitting issues in this repo or by making proposed changes & submitting a pull request.
Other
150 stars 231 forks source link

Add pg_repack upgrade notes #156

Closed vigneshgurusamy closed 2 years ago

vigneshgurusamy commented 2 years ago

Issue #, if available:

Description of changes:

pg_repack does not have an extension update path. So to upgrade the extension, it should be dropped and created.

If you are upgrading from a previous version of pg_repack or pg_reorg, just drop the old version from the database as explained above and install the new version.

I have spent a day trying to figure this information out. Because it was not mentioned in the AWS upgrade guide.

By submitting this pull request, I confirm that you can use, modify, copy, and redistribute this contribution, under the terms of your choice.

kwiseth-AWS commented 2 years ago

Hi @vigneshgurusamy , thanks for your comments and for this addition to the docs. We appreciate your help.