Angel Dabov wrote:
>
> The following bug has been logged online:
>
> Bug reference: 6102
> Logged by: Angel Dabov
> Email address: onzi@ustrem.org
> PostgreSQL version: JDBC 8.3
> Operating system: Windows
> Description: JDBC BIND Source IP Address
> Details:
>
> Hi,
>
> We have Tomcat Windows server with five applications which listen on
> different IP addresses. Every application connects Postgres DB on different
> server. These IP addresses are aliases on one NIC in same subnet.
> The problem:
> Every connection to the DB from JDBC driver bind different IP for source
> address. We have firewall before DBs and need to use specific source ip
> address for every application.
> Is there any chance to fix in PGstream.java
> socket(host, port) with socket(host, port, sourceaddress, null) and give us
> prop to set sourceaddress?
I think you should ask this on the PG jdbc email list:
http://archives.postgresql.org/pgsql-jdbc/
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +