[web2py] Re: web2py Scheduler with Postgres creates idle in transaction connections

2015-02-19 Thread stingpan
I actually get an error using your trick: Traceback (most recent call last): File gluon/scheduler.py, line 1512, in module main() File gluon/scheduler.py, line 1506, in main utc_time=options.utc_time) File gluon/scheduler.py, line 588, in __init__ self.define_tables(db,

[web2py] web2py Scheduler with Postgres creates idle in transaction connections

2015-02-18 Thread stingpan
web2py version: 2.9.12-stable Postgres server: 9.1 I have 3 databases for my application, only one is designated for Scheduler and its tables. What I noticed is that when I start scheduler (using upstart deployment and running start web2py-scheduler as root), all 3 databases are immediately