How to access a DB in an AWS EC2 port, using Datagrip or Pgadmin locally

Question

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 the local Tables, but in the EC2 instance I don’t know what access data to use.

Answer 1

instance has Public IP? If so, you need to ensure that your ACL/Secgroup clears access at port 5432 (or the one configured for Postgres). However, be careful not to expose to any source.