Difference between revisions of "Ssh tunnel"
Jump to navigation
Jump to search
(→Errors) |
|||
| (5 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
{{lc}} | {{lc}} | ||
| − | + | TOMERGE: [[Reverse SSH tunneling]] | |
https://stackoverflow.com/questions/16835761/postgresql-via-ssh-tunnel | https://stackoverflow.com/questions/16835761/postgresql-via-ssh-tunnel | ||
| Line 11: | Line 11: | ||
| − | [[ssh -N]] [[-f]] [[-L]] 1111:localhost:5432 [email protected] | + | [[ssh -N]] [[-f]] [[ssh -L|-L]] 1111:localhost:5432 [email protected] |
| − | |||
| + | == Errors == | ||
2023-02-03 17:06:31.995 UTC [36921] postgres@postgres DETAIL: User "[[postgres]]" [[has no password assigned]] | 2023-02-03 17:06:31.995 UTC [36921] postgres@postgres DETAIL: User "[[postgres]]" [[has no password assigned]] | ||
| + | [[kex_exchange_identification: Connection closed by remote host]] | ||
== Related == | == Related == | ||
* <code>[[ssh -L]]</code> | * <code>[[ssh -L]]</code> | ||
| + | * <code>[[ssh -R]]</code> | ||
| + | * <code>[[ssh -p]]</code> | ||
* <code>[[~/.pg_service.conf]]</code> | * <code>[[~/.pg_service.conf]]</code> | ||
* [[Reverse SSH tunneling]] | * [[Reverse SSH tunneling]] | ||
Latest revision as of 12:43, 25 January 2024
TOMERGE: Reverse SSH tunneling
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]
Errors[edit]
2023-02-03 17:06:31.995 UTC [36921] postgres@postgres DETAIL: User "postgres" has no password assigned kex_exchange_identification: Connection closed by remote host
Related[edit]
See also[edit]
Advertising:
