How to reduce storage(scale down) my RDS instance?

postgresql amazon-web-services amazon-rds
Hello lad picture Hello lad · Apr 20, 2016 · Viewed 17.7k times · Source

I have a RDS(Postgres) instance with Storage SSD 1000GB, but the data is only 100GB of size.

How can I scale down the storage resource of RDS easily ?

Answer

Mark B picture Mark B · Apr 20, 2016

RDS does not allow you to reduce the amount of storage allocated to a database instance, only increase it.

To move your database to less storage you would have to create a new RDS instance with your desired storage space, then use something like pg_dump/pg_restore to move the data from the old database to the new one.

Also be aware that an RDS instance with 1,000GB of SSD storage has a base IOPS of 3,000. An RDS instance with 100GB of SSD storage has a base IOPS of 300, with occasional bursts of up to 3,000.

Related questions

AWS RDS PostgreSQL error "remaining connection slots are reserved for non-replication superuser connections"

In the dashboard I see there are currently 22 open connections to the DB instance, blocking new connections with the error: remaining connection slots are reserved for non-replication superuser connections. I'm accessing the DB from web service API running on EC2 …

Read More
Setting up PostGis on Amazon RDS

Ok, so I am fairly new to RDS and AWS, but I can't for the life of me, get my database that I created on my laptop, onto amazon RDS, I did move it to my test VPS and also …

Read More
Rename the Amazon RDS master username

Changing the password is easily done through the console. Is there any way to change the master username after creation on RDS for PostgreSQL? If so, how?

Read More