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? /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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/b65b5a98-48ca-4475-b061-aa8407916d78%40googlegroups.com.
