To resize the disk size of a PostgreSQL RDS instance using the AWS CLI, you need to follow these steps but before that try to get the used and free space by running these commands from my artical
1.First, stop the RDS instance.
aws rds stop-db-instance --db-instance-identifier <instance_name>
Modify the RDS instance’s disk size using the modify-db-instance command:
aws rds modify-db-instance --db-instance-identifier <instance_name> --allocated-storage <new_size_in_gb>
start the instance
aws rds start-db-instance --db-instance-identifier <instance_name>
Note: The size change will only occur when you stop and start the instance. Also, back up your data before performing any disk size changes.
