Question about new toro-portal ant installer and Postgresql

0 views
Skip to first unread message

Paul

unread,
Dec 11, 2007, 2:44:05 PM12/11/07
to Toro Projects
After checking the toro-portlets googlecode page the other day, I
noticed that everything is now linking to the new toro-portal ant
installer package. After reading through what documentation was
available, I decided to try it and see if it could help to quickly
deploy a portal for testing on different machines.

Well, everything seems to go ok until the tomcat server is restarted
and then the errors start. The main problem I am seeing is that for
every possible Postgresql connection available, that many get created.
So if the configuration of Postgresql is set to allow 100 connections,
then 100 connections will immediately be created at portal start.
Looking further in the logs leads to the Fatal error of connection
limit exceeded for non-superusers.

Doing some research online has led me to believe this is some type of
tomcat/uportal database pooling issue. I am not sure where to look
from here because I do not know if the problem is in tomcat's
configuration or in uPortal. With all previous uPortal installs, I
have not used any connection pooling that I know of, and instead used
rdbm.properties to define the connection.

So, can anyone tell me how to fix this issue? This could be in the
form of disabling connection pooling and again using rdbm.properties
or correcting the pooling issue

Thanks for any help,
Paul
Reply all
Reply to author
Forward
0 new messages