pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPGPool II V3.3.3 and Jboss-7.2.0
5+ messages / 3 participants
[nested] [flat]
* PGPool II V3.3.3 and Jboss-7.2.0
@ 2014-05-29 08:13 irrusappan <irrusappan.p@tcs.com>
2014-05-29 08:40 ` Re: PGPool II V3.3.3 and Jboss-7.2.0 Matheus de Oliveira <matioli.matheus@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: irrusappan @ 2014-05-29 08:13 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: PGPool II V3.3.3 and Jboss-7.2.0
2014-05-29 08:13 PGPool II V3.3.3 and Jboss-7.2.0 irrusappan <irrusappan.p@tcs.com>
@ 2014-05-29 08:40 ` Matheus de Oliveira <matioli.matheus@gmail.com>
2014-05-29 09:21 ` Re: PGPool II V3.3.3 and Jboss-7.2.0 irrusappan <irrusappan.p@tcs.com>
0 siblings, 1 reply; 5+ messages in thread
From: Matheus de Oliveira @ 2014-05-29 08:40 UTC (permalink / raw)
To: irrusappan <irrusappan.p@tcs.com>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: PGPool II V3.3.3 and Jboss-7.2.0
2014-05-29 08:13 PGPool II V3.3.3 and Jboss-7.2.0 irrusappan <irrusappan.p@tcs.com>
2014-05-29 08:40 ` Re: PGPool II V3.3.3 and Jboss-7.2.0 Matheus de Oliveira <matioli.matheus@gmail.com>
@ 2014-05-29 09:21 ` irrusappan <irrusappan.p@tcs.com>
2014-05-29 09:49 ` Re: PGPool II V3.3.3 and Jboss-7.2.0 Matheus de Oliveira <matioli.matheus@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: irrusappan @ 2014-05-29 09:21 UTC (permalink / raw)
To: 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: irrusappan.p@tcs.com
Website: http://www.tcs.com
____________________________________________
Experience certainty. IT Services
Business Solutions
Consulting
____________________________________________
From:
"Matheus de Oliveira [via PostgreSQL]"
<ml-node+s1045698n5805369h51@n5.nabble.com>
To:
irrusappan <irrusappan.p@tcs.com>
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: http://postgresql.1045698.n5.nabble.com/PGPool-II-V3-3-3-and-Jboss-7-2-0-tp5805367p5805371.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: PGPool II V3.3.3 and Jboss-7.2.0
2014-05-29 08:13 PGPool II V3.3.3 and Jboss-7.2.0 irrusappan <irrusappan.p@tcs.com>
2014-05-29 08:40 ` Re: PGPool II V3.3.3 and Jboss-7.2.0 Matheus de Oliveira <matioli.matheus@gmail.com>
2014-05-29 09:21 ` Re: PGPool II V3.3.3 and Jboss-7.2.0 irrusappan <irrusappan.p@tcs.com>
@ 2014-05-29 09:49 ` Matheus de Oliveira <matioli.matheus@gmail.com>
2015-02-05 07:49 ` Re: PGPool II V3.3.3 and Jboss-7.2.0 akbar <arofah.akbar@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: Matheus de Oliveira @ 2014-05-29 09:49 UTC (permalink / raw)
To: irrusappan <irrusappan.p@tcs.com>; +Cc: pgsql-admin
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.
Sure, try that:
http://lmgtfy.com/?q=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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: PGPool II V3.3.3 and Jboss-7.2.0
2014-05-29 08:13 PGPool II V3.3.3 and Jboss-7.2.0 irrusappan <irrusappan.p@tcs.com>
2014-05-29 08:40 ` Re: PGPool II V3.3.3 and Jboss-7.2.0 Matheus de Oliveira <matioli.matheus@gmail.com>
2014-05-29 09:21 ` Re: PGPool II V3.3.3 and Jboss-7.2.0 irrusappan <irrusappan.p@tcs.com>
2014-05-29 09:49 ` Re: PGPool II V3.3.3 and Jboss-7.2.0 Matheus de Oliveira <matioli.matheus@gmail.com>
@ 2015-02-05 07:49 ` akbar <arofah.akbar@gmail.com>
0 siblings, 0 replies; 5+ messages in thread
From: akbar @ 2015-02-05 07:49 UTC (permalink / raw)
To: pgsql-admin
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.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2015-02-05 07:49 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2014-05-29 08:13 PGPool II V3.3.3 and Jboss-7.2.0 irrusappan <irrusappan.p@tcs.com>
2014-05-29 08:40 ` Matheus de Oliveira <matioli.matheus@gmail.com>
2014-05-29 09:21 ` irrusappan <irrusappan.p@tcs.com>
2014-05-29 09:49 ` Matheus de Oliveira <matioli.matheus@gmail.com>
2015-02-05 07:49 ` akbar <arofah.akbar@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox