snippetsqlMinor
AWS Postgres RDS "storage-full" and not responding. How to bring back online?
Viewed 0 times
fullpostgresrespondingbringstorageonlinebackawshowand
Problem
I cannot reboot nor stop the DB in AWS console. I cannot connect it with PG Admin. My Java app also print error like this.
And And I just realize the storage has been decreasing all the way to zero after the DB is down. I find it really astonishing since the amount of QPS is sparse and low. How can the storage decrease so steadily?
org.postgresql.util.PSQLException:
Connection to xxxx.us-east-1.rds.amazonaws.com: 5432 refused.
Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.And And I just realize the storage has been decreasing all the way to zero after the DB is down. I find it really astonishing since the amount of QPS is sparse and low. How can the storage decrease so steadily?
Solution
Turns out in this "storage-full" status you cannot connect to the instance. Only thing you can do is to increase storage.
https://aws.amazon.com/premiumsupport/knowledge-center/rds-autoscaling-low-free-storage/
https://aws.amazon.com/premiumsupport/knowledge-center/rds-autoscaling-low-free-storage/
Context
StackExchange Database Administrators Q#286580, answer score: 3
Revisions (0)
No revisions yet.