Difference between revisions of "Ssh tunnel"
Jump to navigation
Jump to search
| Line 20: | Line 20: | ||
* <code>[[ssh -L]]</code> | * <code>[[ssh -L]]</code> | ||
* <code>[[~/.pg_service.conf]]</code> | * <code>[[~/.pg_service.conf]]</code> | ||
| + | * [[Reverse SSH tunneling]] | ||
== See also == | == See also == | ||
Revision as of 10:36, 4 September 2023
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
See also
Advertising:
