Connecting to RDBMS from MacOS

How to connect to the PostgreSQL RDBMS server from MacOS

Follow these steps on a Mac to generate your public/private keys and access the PostgreSQL server.

Access Terminal

Terminal (Terminal.app) is the terminal emulator included in the macOS operating system. You can use this application to generate your SSH key.

Open a new Finder window
Navigate to the Applications folder
Navigate to the Utilities folder
Open the Terminal app

Terminal

Generate Key

From Terminal, follow these instructions (see screenshot below):

Type: ssh-keygen -t rsa
Hit return to use the default file / location
Enter a passphrase
Enter your passphrase again
Type: cat ~/.ssh/id_rsa.pub

In the screenshot below:

(a) is the location and filename of your private key
(b) is the location and filename of your public key
(c) are the contents of your public key

Note

You will need to provide the contents of (c) to your Medic contact or RDBMS administrator. It should start with ssh-rsa and end with something that looks like an email address. This information is not sensitive and can be shared over slack, github, etc…

SSH Commands

Connect to PostgreSQL

Once your public SSH key has been installed on RDBMS, the administrator will provide you with login credentials to the SSH server as well as for PostgreSQL. You should be able to access PostgreSQL from a SQL client using those credentials. Some common SQL clients include: pgAdmin, DBeaver, Postico.

From your SQL client, use the settings mentioned below to connect. Be sure to select the Private Key that you generated above.

Field	Value
Host	`localhost`
Host Port	`5432`
User	`<provided by Medic>`
Password	`<provided by Medic>`
Database	`<your project database>`
SSH Host	`rdbms.dev.medicmobile.org`
SSH Port	`33696`
SSH User	`<provided by Medic>`
SSH Password	N/A - Use Private Key
Private Key	Use the private key generated above