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" <[email protected]> A: [email protected] 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 ------------------------------------------------------------------------------ Download new Adobe(R) Flash(R) Builder(TM) 4 The new Adobe(R) Flex(R) 4 and Flash(R) Builder(TM) 4 (formerly Flex(R) Builder(TM)) enable the development of rich applications that run across multiple browsers and platforms. Download your free trials today! http://p.sf.net/sfu/adobe-dev2dev _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
