Access to elastic beanstalk DB from pgAdmin

Question

Created an elastic beanstalk application with a postgres database.  Whenever I try to access this DB outside AWS, e.g. from psql or pgAdmin, I get connection timeout.  DB works within application and is "active" and allows input from "all TCP".  I suspect there's a permission issue somewhere  but I don't know where it is.

rePost-User-9474443 · Accepted Answer

I was able to resolve the issue by adding a rule to the Elastic Beanstalk app's VPC security group to allow my mac's IP address.  Steps:
- Navigate  to VPC console
- select security groups
- select database security group added by Elastic Beanstalk
- Add inbound rule.  For source, select a CIDR that includes your IP address (0.0.0.0/0 for all IPV4, e.g.)

Riku_Kobayashi · Answer

Hello.

Are you trying to connect to RDS directly from your local PC with PGAdmin?  
In this case, RDS does not have public access by default, so you need to enable public access and add a route to the Internet gateway in the subnet that RDS is using.  
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_VPC.WorkingWithRDSInstanceinaVPC.html#USER_VPC.Hiding

If you can use AWS ClientVPN, you can also connect using RDS's private IP.  
https://aws.amazon.com/blogs/database/accessing-an-amazon-rds-instance-remotely-using-aws-client-vpn/

If you can use EC2 as a bastion instance, you can also use the port forwarding feature of Systems Manager Session Manager.  
https://aws.amazon.com/jp/blogs/mt/use-port-forwarding-in-aws-systems-manager-session-manager-to-connect-to-remote-hosts/

re:Post Agent · Answer

To access an Elastic Beanstalk PostgreSQL database from outside AWS using pgAdmin or psql, you need to ensure proper configuration and permissions. Here are some steps to troubleshoot and resolve the connection timeout issue:

1. Check the security group: Ensure that the security group associated with your RDS instance allows inbound traffic on the PostgreSQL port (typically 5432) from your IP address or the appropriate range.

2. Verify endpoint and port: Confirm that you're using the correct endpoint and port for your RDS instance. You can find this information in the RDS console or the Elastic Beanstalk environment properties.

3. Check network configuration: If your RDS instance is in a VPC, make sure it's in a public subnet with an Internet Gateway, or set up a VPN or Direct Connect to access private resources.

4. Elastic Beanstalk environment properties: Verify that the environment properties for the database connection (RDS_HOSTNAME, RDS_PORT, RDS_USERNAME, RDS_PASSWORD, RDS_DB_NAME) are correctly set and accessible to your application.

5. Database user permissions: Ensure that the database user has the necessary permissions to connect from external sources.

6. Firewall settings: Check if there are any firewall rules on your local machine or network that might be blocking outbound connections to the database port.

To connect using pgAdmin:

1. Open pgAdmin and add a new server.
2. In the "General" tab, give your server a name.
3. In the "Connection" tab:
   - Host: Enter your RDS endpoint
   - Port: Enter the assigned port (usually 5432)
   - Username: Enter the master username
   - Password: Enter the database password

If you've verified all these settings and still can't connect, you may need to review your Elastic Beanstalk and RDS configurations to ensure they're set up correctly for external access.  
**Sources**  
[Using pgAdmin to connect to a RDS for PostgreSQL DB instance - Amazon Relational Database Service](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ConnectToPostgreSQLInstance.pgAdmin.html)  
[Adding a database to your Elastic Beanstalk environment - AWS Elastic Beanstalk](https://docs.aws.amazon.com/elasticbeanstalk/latest/dg/using-features.managing.db.html)

Access to elastic beanstalk DB from pgAdmin

Add your answer

Relevant content