Re: Java proxies connection to postgres - Mailing list pgsql-jdbc

From Donald Fraser
Subject Re: Java proxies connection to postgres
Date
Msg-id 7BF0F1662EE14F6FA6F3C8EFE951A69F@DEVELOP1
Whole thread Raw
In response to Java proxies connection to postgres  (- <grandebuzon@gmail.com>)
Responses Re: Java proxies connection to postgres  (Samuel Gendler <sgendler@ideasculptor.com>)
List 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

pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: Java proxies connection to postgres
Next
From: Craig Ringer
Date:
Subject: Re: Java proxies connection to postgres