Re: Defining local IP address when opening connections to database

> -----Original Message-----
> From: pgsql-jdbc-owner(at)postgresql(dot)org [mailto:pgsql-jdbc-
> owner(at)postgresql(dot)org] On Behalf Of Michael Bauland
> Sent: Wednesday, March 07, 2012 11:20 AM
> To: pgsql-jdbc(at)postgresql(dot)org
> Subject: [JDBC] Defining local IP address when opening connections to
> database
>
> Hi,
>
> I've got a problem when using the PostgreSQL JDBC driver to open a
> connection to a database (not using SSL). The server on which I'm using
the
> driver has several IPs configured, but I would like to use a certain IP
(since
> only for that IP the firewalls have been set-up to allow the connection to
the
> database). Looking at the documentation I couldn't find a way to define
this
> local IP.
> Have I missed something? If not, would it be possible to add this feature
of
> defining the local IP when setting up a connection?
>
> Cheers,
>
> Michael

Are you missing the obvious, in which case read Kevin's and Dave's
responses, or do you mean that on the "client" machine (i.e., the one using
JDBC) you have multiple network adapters and only one of them is allowed to
connect to the database?

If the latter is the case I am not sure about JDBC but I would presume you
could setup some form of routing table on your machine so that any traffic
to the server IP address is forced to be routed through the appropriate
network card.

David J.