Обсуждение: BUG #6102: JDBC BIND Source IP Address

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?

Thank You,
Angel

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. +