ODK number of connections in PosgreSQL

Development
#1

Hi,

What would be the 'normal' number of connections per ODK installation on
postgres.

I had a FATAL error in postgres cause Maximum number of connections issue
in postgres and saw that there were ~100 idle connections from ODK. I
restarted tomcat, and now I have ~30 connections. Is this number of
connections considered OK? I'm worried that ODK is not closing the
connection and I cannot explain why I had ~100 connections..

ps. I have an instance of tomcat with two instances of ODK which connect to
two different DBs, one a MySQL, the other a Postgresql.

Best,
piqo

#2

Piqo,

https://groups.google.com/d/msg/opendatakit-developers/lv8bc7rd630/pKLY8zr86FMJ
Might help.

Yaw

ยทยทยท -- Need ODK services? http://nafundi.com provides form design, server setup, professional support, and software development for ODK.

On Thu, Jul 2, 2015 at 10:08 AM, piqo piqoni@gmail.com wrote:

Hi,

What would be the 'normal' number of connections per ODK installation on
postgres.

I had a FATAL error in postgres cause Maximum number of connections issue in
postgres and saw that there were ~100 idle connections from ODK. I restarted
tomcat, and now I have ~30 connections. Is this number of connections
considered OK? I'm worried that ODK is not closing the connection and I
cannot explain why I had ~100 connections..

ps. I have an instance of tomcat with two instances of ODK which connect to
two different DBs, one a MySQL, the other a Postgresql.

Best,
piqo

--
You received this message because you are subscribed to the Google Groups
"ODK Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.