Attempting to query Aurora PostgresDB (can't make query using internal tools/server times on on connection with external)

Question

a company's SQL developer has left and I've been asked to build a series of queries for their postgres DB on an Aurora Postgres server in the interim. I can log into the RDS interface, but the query editor doesn't support Aurora Postgres. PGadmin from the outside times out when attempting to use the associated instance name and port number gathered from RDS (same with IP address).

This is a pretty broad question as my AWS Postgres access experience is low, but Is there anything special to getting a postgres client to connect to an AWS postgres server? I'm wondering if their DB has whitelisted (allowlist) access rules, or is maybe to be accessed from within the AWS environment only.

Its a real small shop so I don't expect their setup to be super complex. If you have any direction to point in I'd appreciate it. Thanks

Accepted Answer

Hello.

Depending on how Aurora is configured, you may need to allow your public IP address in the security group configured for Aurora if public access is enabled.  
You can check whether public access is enabled by selecting the target Aurora instance and checking the "Connectivity & security" tab.  
https://repost.aws/knowledge-center/rds-connectivity-instance-subnet-vpc  
![a](/media/postImages/original/IMvpv2g8JxStmr7TtVwI8Qrw)

If public access is disabled, it is possible that you were connecting to EC2 etc. as a stepping stone instance.  
For example, they may have been using port forwarding via SSH or port forwarding via 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/

Answer

Thank you for the pointers. That has moved me much further in the process of getting connected.

Attempting to query Aurora PostgresDB (can't make query using internal tools/server times on on connection with external)

Relevant content