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 ?