Received: from localhost (uranus.hub.org [200.46.204.60]) by postgresql.org (Postfix) with ESMTP id A8D319FA61D for ; Thu, 2 Nov 2006 05:45:31 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.60]) (amavisd-new, port 10024) with ESMTP id 70383-01 for ; Thu, 2 Nov 2006 05:45:28 -0400 (AST) X-Greylist: delayed 10:31:01.622625 by SQLgrey- Received: from perth.mailnetwork.co.uk (perth.mailnetwork.co.uk [80.175.28.46]) by postgresql.org (Postfix) with ESMTP id A62229FA4A5 for ; Thu, 2 Nov 2006 05:45:28 -0400 (AST) Received: from [213.146.143.243] (port=61792 helo=[172.16.208.165]) by perth.mailnetwork.co.uk with esmtpa (Exim 4.63) (envelope-from ) id 1GfZ8Z-0002vd-2O; Thu, 02 Nov 2006 09:45:27 +0000 Message-ID: <4549BEAF.9010609@mailnetwork.co.uk> Date: Thu, 02 Nov 2006 09:47:27 +0000 From: "Andy Shellam (Mailing Lists)" User-Agent: Thunderbird 1.5.0.7 (Windows/20060909) MIME-Version: 1.0 To: Dirk Becker CC: pgsql-php@postgresql.org Subject: Re: cant conect to dynamic host-URL References: <4548E934.5090904@adocom.de> <1d7288990611011311u6e8c17bbt49a5e67a45faeffb@mail.gmail.com> <45492A53.6070707@mailnetwork.co.uk> <4549AB1C.2010204@adocom.de> In-Reply-To: <4549AB1C.2010204@adocom.de> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/5 X-Sequence-Number: 3623 > Could it be that pg_connect cant connect through real URLs ? The only difference with a dynamic URL is that the DNS expiry (time-to-cache) is much lower (usually 5 minutes as opposed to a day.) DNS clients don't see it any differently. I would try a newer PHP version (latest in the 4 series is 4.4.4). I must admit I've never had a problem with pg_connect not seeing a domain the server itself can. Is the PostgreSQL server on the same box as PHP? Have you tried connecting through domain sockets instead? Andy. Dirk Becker wrote: > Andy Shellam (Mailing Lists) wrote: >> Connects fine from my box. How about firewalls? We had a weird case >> at work a while back where a router somewhere along the line was >> blocking all connections until it was ping'd - then after it received >> a ping, it'd keep the connection open for 20 minutes or so, then >> start blocking again. Turned out to be faulty! >> >> One thing I would check is the domain name lookup. Make sure your >> DNS servers are properly configured and respond timely (within 2 >> seconds.) from your client for a minute and see if any time out >> and/or fail. >> >> Andy. > > Thanks, but the error only apears while using php / pg_connect() > With pgsql i can connect through the dynamic url without problems :/ > Could it be that pg_connect cant connect through real URLs ? > > I run php 4.3.3 and PostgreSQL 8.1.0 > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend > > !DSPAM:37,4549ab3440414261817806! > >