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@klawitter.de                             http://www.klawitter.de