Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WpvTE-0000Ze-QQ for pgsql-admin@arkaria.postgresql.org; Thu, 29 May 2014 08:13:53 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WpvTD-0004yH-Ri for pgsql-admin@arkaria.postgresql.org; Thu, 29 May 2014 08:13:51 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1WpvTB-0004y8-R0 for pgsql-admin@postgresql.org; Thu, 29 May 2014 08:13:49 +0000 Received: from sam.nabble.com ([216.139.236.26]) by magus.postgresql.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1WpvT6-0006An-Rp for pgsql-admin@postgresql.org; Thu, 29 May 2014 08:13:48 +0000 Received: from [192.168.236.26] (helo=sam.nabble.com) by sam.nabble.com with esmtp (Exim 4.72) (envelope-from ) id 1WpvT1-000412-Qr for pgsql-admin@postgresql.org; Thu, 29 May 2014 01:13:39 -0700 Date: Thu, 29 May 2014 01:13:39 -0700 (PDT) From: irrusappan To: pgsql-admin@postgresql.org Message-ID: <1401351219744-5805367.post@n5.nabble.com> Subject: PGPool II V3.3.3 and Jboss-7.2.0 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: 0.6 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org Dear Expert, I would like to get an expert suggestion on using PGPool II for PostgreSQL connection Pooling. We are developing a Quality Assurance tool in our organization. So far, i have used jboss-5.1.0 and PostgreSQL8.2.13 to deploy the application. Now as part of our next release, i am planning to move jboss-7.2.0 Final and PostgreSQL 9.2.4. and i have completed the migration as well. My aim is to employ PGPool II for postgresql connection pooling. I was able to install PGPool II v3.3.3 in Linux RHEL 5.5 platform.But my doubt is how to configure data source.In the jboss standalone-full.xml, should i provide IP and port of PostgreSQL or PGPool II and with Postgresql my application works without any issue but with PG POOL it is not connecting.SO can anyone help me on how do i use PGPool II for connection pooling. What is the relevant configuration needs to be done.Request your help and guidance. -- View this message in context: http://postgresql.1045698.n5.nabble.com/PGPool-II-V3-3-3-and-Jboss-7-2-0-tp5805367.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin