Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id CA11B6340CD for ; Mon, 7 Sep 2009 07:50:01 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 22497-10 for ; Mon, 7 Sep 2009 10:49:45 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from titania.wxnz.net (titania.wxnz.net [58.28.4.13]) by mail.postgresql.org (Postfix) with ESMTP id 0E2556340BD for ; Mon, 7 Sep 2009 07:49:50 -0300 (ADT) Received: from gonzo (ip-118-90-135-193.xdsl.xnet.co.nz [118.90.135.193]) by titania.wxnz.net (Postfix) with ESMTP id 3CAD0109806C for ; Mon, 7 Sep 2009 22:49:47 +1200 (NZST) Received: from news by gonzo with local (Exim 4.69) (envelope-from ) id 1Mkbn9-0000HS-AX for pgsql-php@postgresql.org; Mon, 07 Sep 2009 22:49:47 +1200 To: pgsql-php@postgresql.org Path: not-for-mail From: Jasen Betts Newsgroups: gmane.comp.db.postgresql.php Subject: Re: How to select the source ip address for a connection to the database server Date: 7 Sep 2009 10:49:42 GMT Organization: Dis (not Dat) Organisation Lines: 22 Message-ID: References: <20090902202318.hp0bplmn4kkc48k0@zeus.netdynamics.gr> <4AA30914.7080102@lightlink.com> NNTP-Posting-Host: localhost Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: reversiblemaps.ath.cx 1252320582 14143 127.0.0.1 (7 Sep 2009 10:49:42 GMT) X-Face: ?)Aw4rXwN5u0~$nqKj`xPz>xHCwgi^q+^?Ri*+R(&uv2=E1Q0Zk(>h!~o2ID@6{uf8s; a +M[5[U[QT7xFN%^gR"=tuJw%TXXR'Fp~W; (T"1(739R%m0Yyyv*gkGoPA.$b,D.w:z+<'"=-lVT?6 {T?=R^:W5g|E2#EhjKCa+nt":4b}dU7GYB*HBxn&Td$@f%.kl^:7X8rQWd[NTc"P"u6nkisze/Q; 8 "9Z{peQF,w)7UjV$c|RO/mQW/NMgWfr5*$-Z%u46"/00mx-,\R'fLPe.)^ User-Agent: slrn/pre1.0.0-2 (Linux) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.154 tagged_above=-10 required=5 tests=AWL=-0.044, BAYES_05=-1.11 X-Spam-Level: X-Archive-Number: 200909/10 X-Sequence-Number: 4068 On 2009-09-06, Dimitris Sakellarios wrote: > > That is the way sockets normally work, the primary address is always > used for outgoing connections. It can not be changed without some low > level programming. It is necessary to bind the socket to the specific IP > address before opening the connection. I have done it with Perl, but not > PHP. > > Bob McConnell > N2SPP > basically what you need to do is take the libpq source extend the conneection-string facility to include bind-to-port and bind-to-address parameters which bind the outgoing connection to the named resources and then recompile it and get it installed on your server no changes are likely to be needed to PHP