How to access a DB in an AWS EC2 instance, using DataGrip or PgAdmin locally

Question

How to access a DB in an AWS EC2 instance, using DataGrip or PgAdmin locally

Navigation

#1 by (-1 votes)

0

I have an instance on AWS EC2 that has a Database on Postgres (Not on Amazon RDS). I would like to access it using some tool like DataGrip or PgAdmin on my local computer.

Is it possible? How to do?

Locally I can use Datagrip and PgAdmin to access local tables, but in EC2 instance I do not know what access data to use.

postgresql aws ec2

asked by anonymous 20.12.2018 / 18:25

1 answer

Problems with google Oauth Spacing Error

score -1 · Answer 1

Does the instance have Public IP? If so, you need to ensure that your ACL / SecGroup releases access on port 5432 (or the one that is configured for Postgres). However, be careful not to expose yourself to any source.