Membuat Koneksi Ke Postgre Di Remote Server Via SSH Tunneling Dengan gSTM

Studi kasus :

Remote server
IP : 192.168.100.69
Port SSH : 5666
Port postgre : 5432

Localmachine :
Port 5666 akan digunakan untuk koneksi ke postgre via ssh tunneling

User SSH
username : user_ssh
password : password_ssh

Login Postgre di remote server :
username : user_postgre
password : password_postgre

#1 Install gnome SSH Tunneling Manager (gSTM)


sudp apt-get install gstm

#2 Buka gSTM

#3 Buat tunneling baru dengan konfigurasi

Name : Tes Tunneling (bebas)
Host : 192.168.100.69
Login : user_ssh
Port : 5666

Kemudian Add Port Redirection dengan konfigurasi sbb :
Type : Local
Port : 5666
To Host : localhost
Port : 5432

#4 Mulai tunneling dengan mengklik tombol start

#5 Buka pgadmin

#6 Buat koneksi baru dengan konfigurasi

Name : Tes koneksi (bebas)
Host : localhost
port : 5666
username : user_postgre
password : password_postgre

Buka koneksi

No comments yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s