7

Today I want to know if it is possible to manage a PostgreSQL on OpenShift using pgAdmin, in the same way that we can manage an Amazon RDS database?

cap7
  • 482
  • 5
  • 24

2 Answers2

8

Use port forwarding on your local machine to establish a connection to your remote server:

rhc port-forward -a applicationName

Now check the output on your command line to which port the postgres database service is mapped, if available this will be 5432 by default.

A step by step documentation about port forwarding is available at Getting Started with Port Forwarding on OpenShift.

timo.rieber
  • 3,727
  • 3
  • 32
  • 47
  • [although useful answer](http://stackoverflow.com/questions/20960407/openshift-how-to-connect-to-postgresql-fro%E2%80%8C%E2%80%8Bm-my-pc#answer-20965511) – Alex Silkovsky Oct 18 '15 at 11:30
4

Another way would be to configure the ssh-tunnel into your connection.

ssh-tunnel window

Tunnel-Host would be your applications name

Username the beginning string, when ssh'ing to that connection: XXX@application-name


Identity file would be id_rsa in .ssh fodler in your home directory

password your openshift password

Zahtu
  • 93
  • 4
  • If you use Identity file for authentication (as above) then you must use the passphrase of your id_rsa (private key). – Lyndon Aug 25 '16 at 15:28