Thread: PGPool II V3.3.3 and Jboss-7.2.0

PGPool II V3.3.3 and Jboss-7.2.0

From
irrusappan
Date:
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.


Re: PGPool II V3.3.3 and Jboss-7.2.0

From
Matheus de Oliveira
Date:

On Thu, May 29, 2014 at 5:13 AM, irrusappan <irrusappan.p@tcs.com> wrote:
My aim is to employ PGPool II for postgresql connection pooling.

Honestly, pgPool-II is a great tool for some tasks (like load-balancing), but it is not very good at connection pooling.

For this specific task I strongly recommend you using pgbouncer [1] instead. It is faster and more flexible than pgPool-II.

 
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

The pgPool-II IP/port should be configured in your application (for pgbouncer the same applies).
 
and with Postgresql my application
works without any issue but with PG POOL it is not connecting.

We need more information, what error did your application throw? Also, messages on pgPool's log would be nice.

But really, you should try pgbouncer instead.

[1] https://wiki.postgresql.org/wiki/PgBouncer

Best regards,
--
Matheus de Oliveira
Analista de Banco de Dados
Dextra Sistemas - MPS.Br nível F!
www.dextra.com.br/postgres

Re: PGPool II V3.3.3 and Jboss-7.2.0

From
irrusappan
Date:
Dear Matheus,

Thanks for your time and suggestions.

I shall try with Pgbouncer.

Request you to guide me by sharing suitable link which he help me in achieving connection pooling using pgbouncer.

Sincerely,

Irusappan Panner Selvam
Tata Consultancy Services
Ph:- +91 44 6616 3125
Cell:- 8903692756
Mailto: [hidden email]
Website:
http://www.tcs.com
____________________________________________
Experience certainty.        IT Services
                       Business Solutions
                       Consulting
____________________________________________



From:"Matheus de Oliveira [via PostgreSQL]" <[hidden email]>
To:irrusappan <[hidden email]>
Date:29-05-2014 14:11
Subject:Re: PGPool II V3.3.3 and Jboss-7.2.0






On Thu, May 29, 2014 at 5:13 AM, irrusappan <[hidden email]> wrote:
My aim is to employ PGPool II for postgresql connection pooling.

Honestly, pgPool-II is a great tool for some tasks (like load-balancing), but it is not very good at connection pooling.

For this specific task I strongly recommend you using pgbouncer [1] instead. It is faster and more flexible than pgPool-II.

 

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


The pgPool-II IP/port should be configured in your application (for pgbouncer the same applies).
 
and with Postgresql my application
works without any issue but with PG POOL it is not connecting.


We need more information, what error did your application throw? Also, messages on pgPool's log would be nice.

But really, you should try pgbouncer instead.

[1]
https://wiki.postgresql.org/wiki/PgBouncer

Best regards,
--
Matheus de Oliveira
Analista de Banco de Dados
Dextra Sistemas - MPS.Br nível F!

www.dextra.com.br/postgres





If you reply to this email, your message will be added to the discussion below:
http://postgresql.1045698.n5.nabble.com/PGPool-II-V3-3-3-and-Jboss-7-2-0-tp5805367p5805369.html
To unsubscribe from PGPool II V3.3.3 and Jboss-7.2.0, click here.
NAML

=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain
confidential or privileged information. If you are
not the intended recipient, any dissemination, use,
review, distribution, printing or copying of the
information contained in this e-mail message
and/or attachments to it are strictly prohibited. If
you have received this communication in error,
please notify us by reply e-mail or telephone and
immediately and permanently delete the message
and any attachments. Thank you



View this message in context: Re: PGPool II V3.3.3 and Jboss-7.2.0
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.

Re: PGPool II V3.3.3 and Jboss-7.2.0

From
Matheus de Oliveira
Date:

On Thu, May 29, 2014 at 6:21 AM, irrusappan <irrusappan.p@tcs.com> wrote:
Request you to guide me by sharing suitable link which he help me in achieving connection pooling using pgbouncer.


Check some tutorials and information, if you have any trouble, came back here for help.

Regards,
--
Matheus de Oliveira
Analista de Banco de Dados
Dextra Sistemas - MPS.Br nível F!
www.dextra.com.br/postgres

Re: PGPool II V3.3.3 and Jboss-7.2.0

From
akbar
Date:
Dear Matheus.

I have almost the same problem. I want to use postgres 9.3 with pgbouncer
and jboss eap 6. My database port is 5444 and pgbouncer port is 6432.
In datasource I use the connection url like :
<connection-url>jdbc:edb://localhost:6432/mforce</connection-url>
But jboss cannot connect to the database and shows errors :
/Throwable while attempting to get a new connection: null:
javax.resource.ResourceException: Could not create connection/

Where did I do wrong?
Thanks,
Akbar



--
View this message in context: http://postgresql.nabble.com/PGPool-II-V3-3-3-and-Jboss-7-2-0-tp5805367p5836793.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.