Обсуждение: PGPool II V3.3.3 and Jboss-7.2.0
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.
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.
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
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
Matheus de Oliveira
Analista de Banco de Dados
Dextra Sistemas - MPS.Br nível F!
www.dextra.com.br/postgres
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
____________________________________________
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
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.
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.
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
Matheus de Oliveira
Analista de Banco de Dados
Dextra Sistemas - MPS.Br nível F!
www.dextra.com.br/postgres
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.