PostgreSQL via SSH Tunnel
Your pg_hba.conf appears to permit connections from localhost. The easiest way of causing your SSH tunnel connections to appear from localhost is to make them to localhost. The following SSH command connects to remote.example.com as user “user”, and causes your ssh client to listen on localhost, port 1111/tcp. Any connections made to that port will … Read more