title: Using Navicat to login to Postgresql via SSH - what are the correct settings?
body: <p>I am trying to log into PostgreSQL on my EC2 server via SSH using Navicat.</p>
  
  <p>I get the following error message:</p>
  
  <p>"80070007: SSH Tunnel: Socket error on connecting. WSAGetLastError return 10061($274D)"</p>
  
  <p>On the server, the "role" postgres already exists, and there is already a database called postgres. I have assigned a password to postgres (using ALTER NAME command via Putty).</p>
  
  <p>The SSH settings I am using in Navicat are:
  Port: 5432
  User Name: [admin user name]
  Authentication Method: Public Key</p>
  
  <p>The Connection settings are:
  Host Name: localhost
  Port: 3306
  Initial Database: postgres
  User Name: postgres
  Password: [password]</p>
  
  <p>When I connect to the MySQL server on the same machine, the settings are exactly the same except for:</p>
  
  <p>SSH to Port 22
  User Name (for connection): root (with corresponding password)</p>
  
  <p>I have tried the SSH to port 22, in which case the error message is:</p>
  
  <p>"could not connect to server: Connection refused (0x0000274D/10061)
  Is the server running on host "localhost" and accepting TCP/IP connections on port 60122?
  received invalid response to SSL negotiation:4"</p>
  
  <p>Any ideas on what settings I need to change to get this to work?</p>