I'm using the RDS Postgres database and the current version is 11.13 and want to upgrade it to 12.10. My instance storage is 5000 GB and almost all storage is occupied. Now only ~500 GB are available.

How can we know if the storage is sufficient for a major version upgrade?

  • 1
    Space requirements wholly depend on the chosen upgrade method, and since you've tagged your question with "amazon-rds", you'll have to ask the AWS support about that.
    – mustaccio
    Jun 24, 2022 at 13:00
  • 1
    With a "vanilla" Postgres you can use pg_upgrade with the --link parameter which means the additional space overhead during migration is extremely small
    – user1822
    Jun 24, 2022 at 13:28
  • 3
    Just out of curiosity why are you upgrading to a version 2 full releases behind with the 3rd major release shortly coming. Current release v14.4/ Shortly coming v15.
    – Belayer
    Jun 24, 2022 at 19:14
  • @Belayer For now, don't want to upgrade it to the latest version. Jun 25, 2022 at 6:45
  • @a_horse_with_no_name Any idea on how much time it takes for AWS to upgrade 5TB of the database? Jun 25, 2022 at 6:45


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.