Accessing the PostgreSQL cartridge from your local machine

In the Adding the PostgreSQL cartridge to your application recipe, you learned how to access the PostgreSQL database by performing SSH into the application gear. In this recipe, you will learn how to connect with the PostgreSQL database from your local machine.

Getting ready

To complete this recipe, you will need an application with the PostgreSQL cartridge. Please refer to the Adding the PostgreSQL cartridge to your application recipe in this chapter to learn how to install the PostgreSQL cartridge. Also, you will need the psql command-line client on your machine. You can download the PostgreSQL server from the official website, http://www.postgresql.org/download/.

How to do it…

Perform the following steps to access the PostgreSQL cartridge from your local machine:

1. Open a command-line terminal and change the directory to the myapp application directory. Execute the following command to forward remote ports to the local machine:

   $ rhc...