Connect AWS RDS Postgres
Colleen Schnettler
March 21, 2024
If you’d like to connect an AWS RDS database on a private VPC to HelloQuery, there are a few additional steps you’ll have to take to whitelist our IPs.
The initial step in establishing a connection between your AWS RDS instance and HelloQuery involves configuring your database to be publicly accessible. This configuration does not expose your database to the public internet indiscriminately but is necessary for specifying more granular inbound security rules that will control access.
Access the Database Dashboard:
Select Your Database Instance:
Modify the Database Instance:
See the screenshow below for reference:
Next, click on “Additional configuration”
Next select “Publicly Accessible”. Click on “Continue” and then “Save”.
Next you’ll need to edit the inbound security rules of your database's VPC security group. If the database instance was created in a VPC, it must have a VPC security group that authorizes connections.
Should you encounter any difficulties or require additional information, AWS provides comprehensive documentation on this topic, available at AWS RDS Security Group Documentation.
You can modify your existing security group or create a new one. From your database page, click on your security group as shown in the screenshot below.
Continue to click through to your security group ID.
Click on “Edit Inbound Rules”
In the security group section you need to add the HelloQuery IPs.
Add Whitelist Rules:
34.238.108.61/32
and 34.239.17.55/32
. The /32
suffix denotes a single IP address. Finalize the Rules:
After configuring the inbound security rules in your AWS RDS security group, the next step is to verify that HelloQuery can successfully connect to your AWS RDS instance. This preliminary test ensures that the credentials and network configurations are correctly set up for a secure connection.
Sign In to HelloQuery:
Configure a Test Connection:
Click “Test Connection”:
If you are having issues connecting, you can temporarily allow all IP addresses to access your database to figure out the problem. If you cannot connect successfully with 0.0.0.0 inbound there is an error in your credentials. If you can, there's an error with the whitelisting. Please reach out to [email protected] for assistance.
Note: This step is for testing purposes only and should be reversed after the test to maintain security.
Add a New Inbound Rule:
0.0.0.0/0
to temporarily allow all IP addresses. This setting will enable you to test the connectivity without IP restrictions.
Apply the Rule:
0.0.0.0
Your AWS RDS instance is securely connected, and you're ready to use HelloQuery. Dive into data analysis and management with confidence, knowing our support team is here if you need us. Thank you for choosing HelloQuery. Let the report building begin!