Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 9E29D2E0068 for ; Sun, 23 Mar 2008 14:34:19 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 21243-02 for ; Sun, 23 Mar 2008 14:34:12 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from gauss.credativ.com (gauss.credativ.com [212.112.227.254]) by postgresql.org (Postfix) with ESMTP id 61F772E0054 for ; Sun, 23 Mar 2008 14:34:14 -0300 (ADT) Received: from feivel (p54BBFDC5.dip.t-dialin.net [84.187.253.197]) (using TLSv1 with cipher ADH-AES256-SHA (256/256 bits)) (No client certificate requested) by gauss.credativ.com (Postfix) with ESMTP id 91E3777535; Sun, 23 Mar 2008 18:34:10 +0100 (CET) Received: by feivel (Postfix, from userid 1000) id 3F558D6D74; Sun, 23 Mar 2008 18:34:10 +0100 (CET) Date: Sun, 23 Mar 2008 18:34:10 +0100 From: Michael Meskes To: Edmund Bacon Cc: pgsql-interfaces@postgresql.org Subject: Re: ECPG connection timeouts Message-ID: <20080323173410.GB6560@feivel.credativ.de> Mail-Followup-To: Edmund Bacon , pgsql-interfaces@postgresql.org References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.17+20080114 (2008-01-14) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/3 X-Sequence-Number: 6710 On Tue, Mar 18, 2008 at 04:47:51PM -0600, Edmund Bacon wrote: > Is it possible to control how long ECPG takes when trying to connect to > a database on a remote system (e.g. connect to tcp:postgres//remote/db) With ecpg calling libpq's connect functions you can just look here for possible options: http://www.postgresql.org/docs/8.3/interactive/libpq-connect.html You should use something like tcp:postgresql://server/database?connect_timeout=14 as database name in a connect statement. However, you will notice that this doesn't work as I just found that the parser doesn't like the "=14" part. I will fix this in a minute. Michael -- Michael Meskes Email: Michael at Fam-Meskes dot De, Michael at Meskes dot (De|Com|Net|Org) ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes@jabber.org Go VfL Borussia! Go SF 49ers! Use Debian GNU/Linux! Use PostgreSQL!