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. It seems I had to remove the old scheduler tables, as well, to help with the migration. Now I've got a new question: If 2 apps are scheduling, and both are using Postgres, are they both using the same table? >From psql, it doesn't look like there's anything in the table creation to isolate it from other applications (that is, \dS scheduler_task doesn't show anything to uniquify the table, but there is an "application_name" field, and then the select * for a sample task has app1/default in that field). Will Auth also be shared? The .schema auth_user doesn't have application_name. > [1] Aside from my issues with switching from pg8000 to psycopg2. > See other thread, but it seems to an issue of where the DAL looks for the driver, and I've gotten it wrong so far. Thanks Dave S /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/4a1b5b3e-9861-40e1-918a-824e06cf0351%40googlegroups.com.
