SSH tunnelling: Difference between revisions

no edit summary
No edit summary
No edit summary
Line 173: Line 173:
</pre>
</pre>


By running this command you will be connected to cedar (like any other ssh connection). Now, you can use another x-term and connect to database server directly from your desktop. The connection requires a password which is your computecanada password. The connection will remain open as long as your have your first ssh connection. In above example "PORT" is a arbitrary port number. For cedar <pre> PORT > 40000 </pre>. Since this port number needs to be open in firewall of cedar head node, please before running this command send a request to support@computecanada.ca and we will assign a port number for you.
By running this command you will be connected to cedar (like any other ssh connection). Now, you can use another xterm and connect to database server directly from your desktop. Here is the command:
 
<pre>
psql -h 127.0.0.1 -P PORT -U <your username> -W
</pre>
 
The connection requires a password which is your computecanada password. The postgres connection will remain open as long as your have your ssh connection. In above example "PORT" is a arbitrary port number and it should be opened in firewall of cedar head node. So, please before running this command send a request to support@computecanada.ca and we will assign a port number for you.
cc_staff
159

edits