OpenShift: How to connect to postgresql from my PC

by

As shown below, after running the “rhc port-forward $appname” command, you would need to connect to the ip address of 127.0.0.1 and port that shows up next to it to connect to the service you want to reach, such as postgresql. In the below example, i would connect to 127.0.0.1, port 5432. If you already have something running locally on the postgresql port, it will select another port and display it in the table. But the connection will be forwarded to your openshift gear and postgresql on your gear.

Corey-Red-Hat:~ cdaley$ rhc port-forward rt2
Checking available ports ... done
Forwarding ports ...

To connect to a service running on OpenShift, use the Local address

Service    Local               OpenShift
---------- -------------- ---- ---------------
httpd      127.0.0.1:8080  =>  127.7.74.1:8080
postgresql 127.0.0.1:5432  =>  127.7.74.2:5432

Press CTRL-C to terminate port forwarding

You can refer to the OpenShift Developer Portal for more information about using the PostgreSQL cartridge here: https://developers.openshift.com/en/databases-postgresql.html

More Related Contents:

  1. How to reset postgres’ primary key sequence when it falls out of sync?
  2. PostgreSQL LIKE query performance variations
  3. How to import CSV file data into a PostgreSQL table
  4. The forgotten assignment operator “=” and the commonplace “:=”
  5. Equivalent to unpivot() in PostgreSQL
  6. Passing user id to PostgreSQL triggers
  7. PostgreSQL: ERROR: 42601: a column definition list is required for functions returning “record”
  8. I forgot the password I entered during postgres installation
  9. Do nullable columns occupy additional space in PostgreSQL?
  10. how to emulate “insert ignore” and “on duplicate key update” (sql merge) with postgresql?
  11. How do I do large non-blocking updates in PostgreSQL?
  12. How to configure PostgreSQL to accept all incoming connections
  13. Postgresql : Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections [duplicate]
  14. Dynamic SQL (EXECUTE) as condition for IF statement
  15. Disable PostgreSQL foreign key checks for migrations
  16. uWSGI, Flask, sqlalchemy, and postgres: SSL error: decryption failed or bad record mac
  17. Prevent recursive trigger in PostgreSQL
  18. Spark Dataframes UPSERT to Postgres Table
  19. PostgreSQL Error: Relation already exists
  20. Using row_to_json() with nested joins
  21. Optimize Postgres query on timestamp range
  22. Use variable set by psql meta-command inside of DO block
  23. pgAdmin III Why query results are shortened?
  24. How do I handle opening/closing Db connection in a Go app?
  25. How do I alter the date format in Postgres?
  26. How to add a conditional unique index on PostgreSQL
  27. Select from a table variable
  28. Postgres default sort by id – worldship
  29. Loop through columns of RECORD
  30. How to drop PostgreSQL database through command line [closed]

Leave a Comment