Skip site navigation (1) Skip section navigation (2)

Re: BUG #6102: JDBC BIND Source IP Address

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Angel Dabov <onzi(at)ustrem(dot)org>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6102: JDBC BIND Source IP Address
Date: 2011-07-12 21:50:54
Message-ID: 201107122150.p6CLosh14383@momjian.us (view raw or flat)
Thread:
Lists: pgsql-bugs
Angel Dabov wrote:
> 
> The following bug has been logged online:
> 
> Bug reference:      6102
> Logged by:          Angel Dabov
> Email address:      onzi(at)ustrem(dot)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(at)momjian(dot)us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +

In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2011-07-12 22:25:59
Subject: Re: Window function bug
Previous:From: Tom LaneDate: 2011-07-12 19:54:18
Subject: Re: BUG #6115: Two similar object giving slightly different results

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group