Geek Answers Handbook

Can I manage an OpenShift database using pgAdmin?

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

+7
database postgresql cloud openshift pgadmin
source share
2 answers

Use port forwarding on the local computer to establish a connection to the remote server:

rhc port-forward -a applicationName

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

Step-by-step port forwarding documentation is available at Getting started with port forwarding on OpenShift .

+7
source share

Another way is to configure ssh-tunnel in your connection.

ssh-tunnel window

Tunnel-Host will be your application name

What is the start line when ssh'ing to this connection: XXX @ application name


The identity file will be id_rsa in the .ssh fodler in your home directory

password of your password with opening shift

+4
source share

More articles:


All Articles