In this article, we will see the solution for AWS RDS PostgreSQL connectivity from pgadmin.
Error saving properties Unable to connect to server: timeout expired
Reason is any of the following:
To fix this we have to configure below values properly.
1. Public accessibility must be set to Yes to allow external connections. To modify the Public access setting, see Modifying an Amazon RDS DB instance.
2. Add IP by editing inbound rules of security group.
3. Add port in inbound rules of security group.
Fix this AWS Unable to connect Server by following steps:
1. Click on database from RDS instances. Then click on connection and security table as highlighted below. Then click on VPC security group.
2. Then select inbound rules and click on edit inbound rules.
3. Click on Add rule.
4. Here actual setting i.e. port number or port range and IP type.
Check Public Accessibility enabled or not:
1. Select the database(RDS) and click on modify.
2. Check Public Accessibility then bottom click on continue to save the changes.
After above checks issue should be fixed.