Re: Defining local IP address when opening connections to database

Hi David,

thanks for your quick reply.

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

yes, I was referring to the latter. I have a client machine which as
several network adapters, but I would like to always have the connection
to the database using exactly one of the IPs available to my client. I
couldn't find a way to specify this IP.

Yes, the routing table might be one solution. But in my case we're
actually having two services running on the client, and both connect to
the same database. And both services should use a different IP. In which
case the routing table won't help. There doesn't seem to be a way of
doing this with JDBC, is there? Since on
http://jdbc.postgresql.org/documentation/head/connect.html
there are a few connection parameters, but none that lets me set my
local IP for the connection.

Cheers,

Michael