Re: Java proxies connection to postgres

From: "Donald Fraser" <postgres(at)kiwi-fraser(dot)net>
To: "[JDBC]" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Java proxies connection to postgres
Date: 2010-08-09 11:47:18
Message-ID: 7BF0F1662EE14F6FA6F3C8EFE951A69F@DEVELOP1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Please look at the attached source taken from a patched version of the 7.4
driver, which is a little out of date with respect to the latest drivers.
However it gives you the idea of what you need to do in order to modify one
of the latest drivers.
The main problem with all HTTP style proxies is that you can only specify
ports 80, 443 and sometimes 8080 and or 8000.
I've spent a lot of time with proxies and to get a reliable connection you
need to use SSL on port 443.
This means you must redirect incomming requests, on the firewall that serves
requests to your PostgreSQL server, from port 443 to port 5432. Which also
means that you cannot have a secure web-server on the same IP address as
your PostgreSQL server!

Regards
Donald Fraser

Attachment Content-Type Size
PGStream.java application/octet-stream 14.2 KB

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Craig Ringer 2010-08-09 11:56:20 Re: Java proxies connection to postgres
Previous Message Dave Cramer 2010-08-09 10:53:57 Re: Java proxies connection to postgres