How to connect to the PostgreSQL RDBMS server from MacOS
Connecting to RDBMS from Windows
Connecting to RDBMS, the PostgreSQL server, is pretty stratightforward in nix systems. In Windows there are a couple of things you need to do to get it up and running.
SSH Key Generation and Importing
Download Puttygen from here
Run Puttygen Go to Windows Start menu → All Programs → PuTTY→ PuTTYgen.
Create a new key pair for your computer.
- Convert the key generated from ssh2 format to openssh. Puttygen supports this.
1. Open PuttyGen 2. Click Load 3. Load your private key 4. Go to Conversions->Export OpenSSH and export your private key 5. Copy your private key to ~/.ssh/id_dsa (or id_rsa). 6. Create the RFC 4716 version of the public key using ssh-keygen ssh-keygen -e -f ~/.ssh/id_dsa > ~/.ssh/id_dsa_com.pub 6. Convert the RFC 4716 version of the public key to the OpenSSH format: ssh-keygen -i -f ~/.ssh/id_dsa_com.pub > ~/.ssh/id_dsa.pub
- Import the file using PuTTYgen:
- Save it as PuTTY Private Key File .ppk:
- Add the key (.ppk) to Pageant (PuTTY authentication agent):
- Now you can connect to RDBMS using PuTTY:
If you are connecting to rdbms in order to use a PostgreSQL client. You may not need to tunnel the connection. The client can do it for you.
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.