I have a RDS instance in amazon I want to modify the allocated storage for, it's currently at 500GB but I want it at 50GB. However when I try changing this in the console I receive the following error: Invalid storage size for engine name postgres and storage type standard: 60
I have a Elasticbeanstalk application that had no RDS instance associated with it, after reading around I've read that some people needed to have an instance with the same specs as the RDS you're trying to modify, however that didn't work either.
Any help here?
You can't decrease allocate storage for your RDS. It can only be increased. From docs:
You can only increase the allocated storage. You can't reduce the allocated storage.
You would have to migrate your database to new RDS instance with smaller storage.