Hi Spico, I use 9 bolts with parallelism of 1 and with 1 task for each bolt(default) and I'm not using any ConnectionPool for connecting to postgres.Just using jdbc classe examples here is source example http://storm.apache.org/releases/2.0.0-SNAPSHOT/storm-jdbc.html. I will check by using the ConnectionPool.
Thank you. *Best regards,* *K.Sai Dilip Reddy.* On Thu, Apr 28, 2016 at 12:19 PM, Spico Florin <spicoflo...@gmail.com> wrote: > Hello! > How many tasks do you have for inserting the data to your database? Are > you using ConnectionPool for connecting to Postgres? If your number of task > superseeds the number of max connections provided in connection pool then > your have a problem. > Please also check the number of max connections that your db accepts. > I hope that these help. > Regards, > Florin > > On Thu, Apr 28, 2016 at 7:09 AM, Sai Dilip Reddy Kiralam < > dkira...@aadhya-analytics.com> wrote: > >> Hi, >> >> I have topology that make connection with postgresdb and insert the >> fields into tables of a test db.my topology is working fine but when I >> submit the topology it is establishing all the connections of db.but I >> don’t know why it is taking all the max connections. >> >> >> below attached the pics of pg_stat_activity. >> >> >> *Best regards,* >> >> *K.Sai Dilip Reddy.* >> > >
