I want to decrease the storage size of my Amazon Relational Database Service (Amazon RDS) instance. How can I do this? 

After an instance is created, you can't modify the size of the instance to decrease the storage space it uses. To decrease the storage size of your RDS DB instance, create a new Amazon RDS instance that has less storage space. Then, migrate your data into the new RDS DB instance using one of the following methods:

  • Using the database engine's native dump and restore method.
  • Using AWS Database Migration Service (AWS DMS) for minimal downtime.

DB dump and restore

  1. Open the Amazon RDS console, and then choose Databases from the navigation pane.
  2. Choose Create database.
  3. Launch a new Amazon RDS instance that has a smaller storage size.
  4. Use your database engine's native tools to dump your existing RDS instance (the instance you want to decrease in size). Then, restore the database in your new Amazon RDS instance. For example, you can use the pg_dump utility for PostgreSQL and the mysqldump utility for Amazon RDS for MySQL.

Replication with AWS DMS

You can use AWS DMS to set up homogeneous replication between your two RDS DB instances. For more information, see Getting Started with AWS Database Migration Service.

Did this page help you? Yes | No

Back to the AWS Support Knowledge Center

Need help? Visit the AWS Support Center

Published: 2019-02-26