Re: How to select the source ip address for a connection to the database server

On 2009-09-02, dimitris(dot)sakellarios(at)telesuite(dot)gr <dimitris(dot)sakellarios(at)telesuite(dot)gr> wrote:
>
> Hi,
>
> I am currently=A0working with PHP5+PGSQL 8.2.13 and i have the =20
> following problem to solve and i need your help.
>
> The server hosting PHP+psql=A0client=A0has 1 physical network =20
> interfaces with multiple=A0subinterfaces using different IPs.
>
> One of those IP=A0is dedicated to my domain, but it is not servers =20
> default IP address since i share the server.
>
> So the problem that i need to solve is how am i going to be able to =20
> use-select my domains IP address as source=A0to connect to the remote =20
> databases.
>
> Is there any configuration to settle default source IP the client will us=
> e?
>
> At the moment all my attempts to connect to the database=A0make use =20
> of=A0servers default interface IP as source.
>
> Thanks in advance for your help.

easiest way it probably by setting a routing rule, you need
root/adimnistrator to do this.