How to access PostGres RDS ?

[pravin]

I access my Jira DataCenter (Amazon Linux EC2) via bastion box.

The DB (Postgres) is hosted on AWS RDS private subnet.

I am having some issues in accessing the Jira App after integrating with Okta. To run some queries I want to connect to DB but dont know how to.

I am not able to find good instructions on how to install PGADMIN on Bastion box (which is a amazon linux ec2 instance (t2.micro).

And then how to launch PGADMIN from my Mac laptop?

Can you share?

[pravin · Accepted solution]

Install postgres package on bastion - Sudo yum install postgresql 

Connect to the database from bastion - psql -h <db_endpoint> -d <database_name> -U <username>