I have an EC2 instance that's configured to connect to my RDS instance. I'm trying to use Beekeeper Studio on my Windows machine to access my PostgreSQL database. What steps do I need to follow to set up the connection? I also use TablePlus on my Mac, but right now I'm focused on getting it working with Beekeeper Studio on Windows.
3 Answers
If you want to tunnel into the RDS via EC2, you've got the right idea! Just add your IP to the security group, but if you're running into issues connecting, have you thought about using AWS Systems Manager (SSM) for a secure connection without needing SSH?
Check out the AWS documentation on connecting to RDS. It has all the details you might need, from setting up the right security group rules to step-by-step instructions on using different GUI clients.
To connect your PostgreSQL GUI like Beekeeper Studio to your RDS instance on EC2, you need to make sure your security group allows your IP address. You might also consider setting up an SSH tunnel for added security. It would look something like `ssh -L 5432:rds-endpoint:5432 ec2-user@ec2-ip`, and then connect to localhost:5432 from your GUI. Just remember to disable the SSH tunnel when you're done for security.
Related Questions
How To Get Your Domain Unblocked From Facebook
How To Find A String In a Directory of Files Using Linux