PGAdmin and Linux Postgres Connectivity via SSH Tunnel Configuration

• PostgresDB installed on Linux Machine

Step 1:

• Download and Install PGAdmin software in your windows box from link( https://sourceforge.net/projects/pgadminportable/)

Step 2:

• In you have installed postgres, open pg_hba.conf, and check  IP-127.0.0.1 is used in that file. If so, we can use localhost for SSH tunneling to connect PGAdmin.

                                                                       (Or)

• If you have changed to 0.0.0.0 in  pg_hba.conf, we can use either localhost or Linux IP  for SSH tunneling to connect PGAdmin

Step 3:

• Open putty and input IP, Select SSH->Auth->Tunnels. Enter Source port as 5432,  and Destination as localhost:5432. (See screenshot below)                                                                                                                                                                      

Step 4:

• Browse and select the PPK file for opening that box. (See screenshot below)

Step 6:

• Click Open and check the login screen opens. (See screenshot below)

Step 7:

• Check 5432 port is listening using the netstat command in linux box. (See screenshot below)

Step 8:

• Click and open installed PgAdminPortable on your windows box. (See screenshot below)

Step 9:

• Choose File -> Add Server. (See screenshot below)

Step 10:

• Give the details Name, Host, Port and Password in server registration window. (See screenshot below)

Step 11:

• Click OK for password. (See screenshot below) 

Step 12:

• Postgres Databases are configured successfully. (See screenshot below)