The following bug has been logged on the website:
Bug reference: 11910
Logged by: nissam
Email address: nisam76@gmail.com
PostgreSQL version: 9.3.5
Operating system: Windows 7
Description:
Number of database connection reaching the limit 100 though my application
doesn't do any activity.
The log says continuous update as below and each of this looks like creating
a new connection and not closing the same.
I set the following property in the postgresql.conf already.
extra_float_digits = 3
Appreciate your help on this.
LOG: execute <unnamed>: SET extra_float_digits = 3
LOG: duration: 0.000 ms
LOG: connection received: host=127.0.0.1 port=62175
LOG: connection authorized: user=admin database=truesight
LOG: duration: 0.000 ms
LOG: duration: 0.000 ms
LOG: execute <unnamed>: SET extra_float_digits = 3
LOG: duration: 0.000 ms
LOG: connection received: host=127.0.0.1 port=62192
LOG: connection authorized: user=admin database=truesight
LOG: duration: 0.000 ms
LOG: duration: 0.000 ms
LOG: execute <unnamed>: SET extra_float_digits = 3
LOG: duration: 0.000 ms
LOG: connection received: host=127.0.0.1 port=62208
LOG: connection authorized: user=admin database=truesight
LOG: duration: 0.000 ms
LOG: duration: 0.000 ms
LOG: execute <unnamed>: SET extra_float_digits = 3
LOG: duration: 0.000 ms
LOG: connection received: host=127.0.0.1 port=62226
LOG: connection authorized: user=admin database=truesight
LOG: duration: 0.000 ms
LOG: duration: 0.000 ms
LOG: execute <unnamed>: SET extra_float_digits = 3
LOG: duration: 0.000 ms
