Re: PGPool II V3.3.3 and Jboss-7.2.0 - Mailing list pgsql-admin
| From | irrusappan |
|---|---|
| Subject | Re: PGPool II V3.3.3 and Jboss-7.2.0 |
| Date | |
| Msg-id | OFE23418C3.7FCE50C5-ON65257CE7.003316BD-65257CE7.00335D44@tcs.com Whole thread Raw |
| In response to | Re: PGPool II V3.3.3 and Jboss-7.2.0 (Matheus de Oliveira <matioli.matheus@gmail.com>) |
| Responses |
Re: PGPool II V3.3.3 and Jboss-7.2.0
|
| List | pgsql-admin |
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.
pgsql-admin by date: