Hi,
I am trying to get a connection to my postgresql db remotely. The problem isn´t
clear as I have can connect with SSH and Putty, but not with pgAdmin.
Is there anyone who could help me either with a possible iptables issue? or is
there a simpler answer which I am missing here?
I have installed the opengeosuite on linux ubuntu hardy, but I dont think it´s a
suite issue, rather a server issue.
yours,
Robert Buckley
You have to open a tunnel through the SSH connection.
Something like:
ssh www.myserver.org -L 5432:localhost:5432
With Putty it's the same thing, you have to fill in the tunnel configuration settings.
Such connection means that you have the prompt shell of your server, and you have a tunnel as well.
This tunnel connects the port 5432 on your pc with the same port on your server, where postgresql is listening.
So with your PgAdmin3 you can connect to localhost:5432, and it will actually connect to port 5432 on you serverIf you have a postgresql instance running on your local pc, then you cannot bind to the same 5432 port.
In this case, open the tunnel with different ports on its ends.
Let's say you choose port 5435; it must be a free port on your pc.
Then you run:
ssh www.myserver.org -L 5435:localhost:5432
and connect PgAdmin3 to localhost:5435
HTH
Cheers,
Vito Meuli
----- Messaggio originale -----
Da: "Robert Buckley" <robertdbuckley@anonymised.com>
A: geoserver-users@lists.sourceforge.net
Inviato: Sabato, 16 ottobre 2010 20:57:13 GMT +01:00 Amsterdam/Berlino/Berna/Roma/Stoccolma/Vienna
Oggetto: [Geoserver-users] connect to postgresql through pgAdmin3 not successful
Hi,
I am trying to get a connection to my postgresql db remotely. The problem isn´t
clear as I have can connect with SSH and Putty, but not with pgAdmin.
Is there anyone who could help me either with a possible iptables issue? or is
there a simpler answer which I am missing here?
I have installed the opengeosuite on linux ubuntu hardy, but I dont think it´s a
suite issue, rather a server issue.
yours,
Robert Buckley
--
ing. Vito Meuli
Tecnologie Avanzate s.r.l.
via B. Croce 49
70015 Noci
BARI
web: www.tecnologieavanzate.it
tel. +390804979652
fax. +390804979263