BUG #6102: JDBC BIND Source IP Address - Mailing list pgsql-bugs

From Angel Dabov
Subject BUG #6102: JDBC BIND Source IP Address
Date
Msg-id 201107081509.p68F9ZrP035079@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #6102: JDBC BIND Source IP Address
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: "Dmitry"
Date:
Subject: BUG #6101: ALTER TABLE hangs with AccessExclusiveLock
Next
From: Tom Lane
Date:
Subject: Re: BUG #6097: Server crash when enabling custom_variable_classes