I figured out most of it. I made a Postgres database for my project. Then I changed `local_settings.py` to include connection info for my Postgres database. Then I ran `python manage.py createdb`, which made tables in the designated Postgres database and ran changes/additions to tables.
Now I just need to migrate data from the SQLite to the Postgres On Wednesday, January 3, 2018 at 2:15:05 PM UTC-5, Tom Tanner wrote: > > Ah, I found dev.db. How can I switch my Mezzanine project from using this > SQLite database to a Postgres one? Then how do I migrate the SQLite data? > > On Tuesday, January 2, 2018 at 7:10:06 PM UTC-5, Eduardo Rivas wrote: >> >> Hi Tom. >> >> If you configured postgres as your database backend, you can use pgAdmin >> or any other viewer to access your tables. >> >> If you started a Mezzanine project and didn't change the database >> configuration, you're probably using a sqlite database. This is just a >> regular file in your project folder, should be named dev.db. I don't know >> of any tools to view those, but I recommend you search online for "sqlite >> viewer" or something of that sort. >> >> On Jan 2, 2018 5:44 PM, "Tom Tanner" <[email protected]> wrote: >> >> When I made my Mezzanine project, I used `python manage.py createdb >> --noinput` when making the database. How do I view the database and its >> tables from a GUI? For instance, pgAdmin, if the database was made in >> PostgreSQL? >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Mezzanine Users" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> For more options, visit https://groups.google.com/d/optout. >> >> >> -- You received this message because you are subscribed to the Google Groups "Mezzanine Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
