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: 270
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