PostgreSql sudenly blocking local connections

Question

Hey guys!

I'm having a strange behavior on my RDS Postgre instance.

My team always connected to the instance, setting their IP on inbound security group.

This week it stopped sudenly and we can't connect to anymore.

Interestingly, restoring some backups, I'm sometimes able to connect to these new instances and sometimes not.

Has anyone seen this behavior?

Answer

Hi there,

This sounds like it could be related to security groups, firewall, or a proxy if you're behind one. Try using at least a /24 when setting inbound rules to your RDS instance. The IP address of RDS instances is also dynamic, meaning it changes, so this could have implications if you're behind a firewall or proxy.

These guides are great for troubleshooting common issues and setup though so read through these to see if the answer is in there:
- https://repost.aws/knowledge-center/rds-cannot-connect
- https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ConnectToPostgreSQLInstance.html
- https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Troubleshooting.html#CHAP_Troubleshooting.Connecting

I hope that helps :)

PostgreSql sudenly blocking local connections

Contenus pertinents