Difference between revisions of "Ssh tunnel"

From wikieduonline
Jump to navigation Jump to search
Line 3: Line 3:
  
 
https://stackoverflow.com/questions/16835761/postgresql-via-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]
 
  [[ssh -L]] 1111:localhost:5432 [email protected]
 
  [[psql -h]] localhost -p 1111 -U your-db-username database-name
 
  [[psql -h]] localhost -p 1111 -U your-db-username database-name

Revision as of 11:54, 20 February 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]
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: