Revision as of 07:27, 19 April 2020

Tunneling Protocols

Tunnel postgres from local machine to server (most common)

ssh -L 1111:localhost:5432 user@remote.example.com

psql -h localhost -p 1111 -U your-db-username database-name

-g option allows remote hosts to connect to local forwarded ports

Tunneling is nice when using tools like https://www.sqlmanager.net/en/products/postgresql/manager or https://www.dbvis.com/ which are convenient for complex datastores.

Remote Forwarding Tunnel is another option to look at but if you have ssh access/perms to server the above is usually what you will do

sshfs

sshfs jtest22@127.0.0.1: /home/busk/mnt -o follow_symlinks
fusermount -u mnt

@@ Line 24: / Line 24: @@
 ssh server
 - https://www.thegeekdiary.com/centos-rhel-how-to-set-up-sftp-to-chroot-jail-only-for-specific-group/
+sshfs
+```
+sshfs jtest22@127.0.0.1: /home/busk/mnt -o follow_symlinks
+fusermount -u mnt
+```