On Tuesday, August 20, 2019 at 10:14:17 PM UTC-7, Dave S wrote: > > > > On Tuesday, August 13, 2019 at 2:46:31 AM UTC-7, Dave S wrote: >> >> >> >> On Tuesday, May 21, 2019 at 6:19:38 PM UTC-7, Dave S wrote: >>> >>> I've got my AWS linux system ticking along nicely with my heavy table >>> under PostGres [1], but I still have uploads, Auth, and Scheduler under >>> sqlite. I'd like to move them to PostGres, so I'm double checking that I'm >>> using the appropriate steps to get there: >>> [...] >>> Auth and Scheduler have the define_tables() on the inside, so all I need >>> to do is? >>> >>> 1. Change the instantiation from >>> auth = Auth(db) >>> scheduler = Scheduler(db, migrate=False) >>> to >>> auth = Auth(dby) >>> scheduler = Scheduler(dby, migrate=True) >>> (and then migrate=False soon after) >>> >> >> I've now done this for the Scheduler of one application. Early on, >> things look good, but I picked the app where a miss by the scheduler >> wouldn't be too painful. >> > > Oops, I've been having memory issues ... the postgres thread supporting > the scheduler seems to grow ... up to 9.6% memory after a couple of hours, > and so of course there are a couple times a day when the thread ... and the > scheduler with it ... get killed. > > [...] > >> [1] Aside from my issues with switching from pg8000 to psycopg2. >>> >> >> > Is this a pg8000 symptom? >
I finally got things working with psycopg2 <URL:https://groups.google.com/d/msg/web2py/lDjyyWYxRt0/qZegtCUyBQAJ> and am beginning a new round of memory watching. /dps -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/03389add-d8df-4af5-aaf8-511be6970efe%40googlegroups.com.