Is possible to manage an OpenShift Database with pgAdmin?

Question

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?

Answer 1

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.

Answer 2

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

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