X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 653EED1B191 for ; Thu, 15 Jul 2004 16:35:51 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 31461-10 for ; Thu, 15 Jul 2004 19:35:48 +0000 (GMT) Received: from stamp.musicrebellion.com (unknown [209.120.177.10]) by svr1.postgresql.org (Postfix) with ESMTP id 925FBD1B1C7 for ; Thu, 15 Jul 2004 16:35:45 -0300 (ADT) Received: from dsl093-203-229.ind1.dsl.speakeasy.net ([66.93.203.229] helo=musicrebellion.com) by stamp.musicrebellion.com with asmtp (Exim 4.30 #2 (Debian)) id 1BlC17-0008Nc-85 for ; Thu, 15 Jul 2004 14:35:41 -0500 Message-ID: <40F6DC6F.4000707@musicrebellion.com> Date: Thu, 15 Jul 2004 14:35:11 -0500 From: Kris Kiger User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.0) Gecko/20020623 Debian/1.0.0-0.woody.1 X-Accept-Language: en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: Connection pooling/sharing software help References: <40F6A366.5040701@musicrebellion.com> <40F6B86B.3020400@spacemonkeylabs.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200407/182 X-Sequence-Number: 14250 This looks exactly like what we want. Currently we are using JDBC to maintain persistent connections. The advantage to this is that you can use the JDBC driver written specifically for your version of Postgres (level 1 or level 4, I forget which is the closest). Do you have any idea how close sqlrelay could be considered or if there is another pooling software that fits the description, but fits into JDBC some how? I appreciate your help! Kris >> Here is the scenario I am running into: >> I have a cluster of databases. I also have another cluster of >> machines that will have to talk with some of the database machines. >> Rather than set up a connection to each databases from each of the >> 'talking' machines, is it possible to share a single connection to a >> database between machines? Does such a connection pooling/sharing >> software exist? Thanks in advance for the advice! > > Yep, called SQL Relay and can be found at > http://sqlrelay.sourceforge.net/ > > I find it especially handy with Oracle, as OCI connections incur > pretty big overhead. > > -- Mitch