Re: PgSQL behind a firewall

nmilet wrote:
>
> The question now is how can I set a ssh tunnel (I try to recompile postgres
> with openssl support
> but I did not succeed), and then can I use a ssh tunnel from Java (perharps
> yes by specifying the
> port number in connection).

That's not difficult:

1.) Establish a ssh connecton from the client formwaarding to the
dbhost (port is the port number on the local host being forwarded):
ssh -L port:dbhost:5432 dbhost
or (as I regularly do)
ssh -2 -n -N -L port:dbhost:5432 dbhost
You'll probably have to set up some identities to make this
work conveniently.

2.) Then you can connect to the remote database by using
db = DriverManager.getConnection
( "jdbc:postgresql://localhost:"+port+"/"+dbname, user, pass );
Where post is the local port and dbname is the (remove) database
name.

With kind regards / Mit freundlichem Gruß
Holger Klawitter
--
Holger Klawitter
holger(at)klawitter(dot)de http://www.klawitter.de