2 Answers
- Newest
- Most votes
- Most comments
0
Hi, auto-scaling for RDS only works to increase volume, you or the auto-scaling option can't decrease the size of the storage. If you want to do that you need to create another database with lower storage (using dump backup-restore or DMS service) [1].
Another option is to use Aurora Postgres, which can increase or decrease the storage [2].
[1] https://repost.aws/knowledge-center/rds-db-storage-size
[2] https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Overview.StorageReliability.html
answered 9 months ago
0
It is documented "After a DB instance has been autoscaled, its allocated storage can't be reduced."
The only way to recover from this scenario is to migrate the databases to a new instance with appropriate allocated storage.
answered 9 months ago
Relevant content
- asked 2 years ago
- asked 6 months ago
- asked 15 days ago
- AWS OFFICIALUpdated 4 years ago
- AWS OFFICIALUpdated 2 years ago
- How do I resolve the storage full issue on my RDS for MySQL instance or my RDS for MariaDB instance?AWS OFFICIALUpdated 9 months ago