can not connect via SSH to a remote Postgresql database

Posted by tartox on Server Fault See other posts from Server Fault or by tartox
Published on 2010-06-02T14:26:33Z Indexed on 2010/06/02 14:34 UTC
Read the original article Hit count: 249

Filed under:
|
|

I am trying to connect via pgAdmin3 GUI to a Postgresql database on a remote server myHost on port 5432.

Server side :

  • I have a Unix myUser that match a postgresql role.
  • pg_hba.conf is :
    local all all trust
    host all all 127.0.0.1/32 trust

Client side :

  • I open an ssh tunnel : ssh -L 3333:myHost:5432 myUser@myHost
  • I connect to the server via pgAdmin3 ( or via psql -h localhost -p 3333 ).

I get the following error message :
server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request.

I have tried to access a specific database with the superuser role using psql -h localhost -p 3333 --dbname=myDB --user=mySuperUser with no more success.

What did I forget in the setup ?
Thank you

© Server Fault or respective owner

Related posts about ssh

Related posts about postgresql