How to Connect Private RDS PostgreSql Instance using Pgadmin locally?
0
- My goal is to connect RDS Postgresql Engine from my pgadmin locally and to build a dashboard using tableau from that RDS Database.
- My Ec2 instance will do data extraction process and store it into DB, Now I need to access the database whenever my EC2 instance is turned off or directly connect to DB from my pgadmin locally, However it should present in private subnet. Any guidance and help will be really thankful to you. As I'm beginner please help to solve this problem. 🙏🙂🙏
2回答
- 新しい順
- 投票が多い順
- コメントが多い順
2
You're right that the DB should be in a private subnet. In an enterprise environment you typically access it from local desktops via Direct Connect or site-to-site VPN. In other situations you have a few options including Client VPN, an EC2 jump/proxy server to tunnel through or using an AWS Workspace to run pgadmin.
0
To add on @skinsman answer, In addition to setting up network (VPN or DirectConnect), You will have to ensure that <br/>
- Security group should allows IP range of your client machines (postgreSQL clients) to Amazon RDS
- You would also need to resolve DNS from onpremise, you will require DNS Resolver to resolve RDS DNS from onpremise. REF: https://aws.amazon.com/blogs/security/how-to-set-up-dns-resolution-between-on-premises-networks-and-aws-using-aws-directory-service-and-amazon-route-53/
回答済み 2年前
First thankyou for your comment, I'll try your solution and I hope this will solve my problem🙂🙏