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:
>
> 1. Create uploads table by copying the define_table() call from db (the
> database from the sqlite URI) to dby (the database from the PostGres URI)
> e.g,
> db.define_table('uploadf', ...)
> gets copied to
> dby.define_table('uploadf', ...)
>
> For the table I already used, there was an issue with migration giving the
> correct resulting table files until I changed the table name from "tname"
> to "tname_y" (the error message has been scarred over). I hadn't seen this
> when making a backup sqlite database (called 'dbx'), I didn't need to name
> the backup "tname_x". [2]
> Should I expect to need this dodge in moving uploads?
>
> 2. Do the usual export as CSV from the old table.
>
> 3. Import the CSV in the new table.
>
> (That's essentially the steps I used for the heavy table)
>
> 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)
>
> 2 and 3 as for uploads?
>
> [1] Aside from my issues with switching from pg8000 to psycopg2.
> [2] Before bringing in PostGres, I tried adding a table to db for saving
> some test results longer term than uwsgi lets me keep log messages. The
> "table already exists" errors kept piling up even after I turned off
> migrates, until I noticed the new table didn't have a UUID in its name. I
> "fixed" this by copying the UUID from another table name and renaming the
> new .table file. But I have another .table file with no UUID that works
> fine. This is 2.15.4, though, so could be something fixed since then.
>
> Thanks for the help.
>
> /dps
>
>
Hmmm, I didn't think this was an unanswerable question, but I seem to have
gotten good at such postings lately.
-d
--
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/6e5e0e79-c5e4-4337-8c8e-7173acc041db%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
