ssh tunnel

https://stackoverflow.com/questions/16835761/postgresql-via-ssh-tunnel

Run on your jump server or bastion host:

• ssh -L 1111:localhost:5432 [email protected]

Connecto to the tunnel:

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

ssh -N -f -L 1111:localhost:5432 [email protected]

2023-02-03 17:06:31.995 UTC [36921] postgres@postgres DETAIL:  User "postgres" has no password assigned

Related

• ssh -L
• ~/.pg_service.conf
• Reverse SSH tunneling

See also

• Bastion Host, Azure Bastion, Jump server, Linux Bastion Hosts on AWS
• SSH: ssh, TLS, .ppk, .pem, .crt, .pub, ED25519, Key exchange method (KEX), public key, private key, ssh -Q kex, IAMUserSSHKeys, known_hosts, ssh tunnel, Dropbear