On 07/17/2018 10:05 PM, Joe Steeve wrote:
On Tue, 2018-07-17 at 22:04 -0700, Mark Sapiro wrote:
You would need to stop Mailman core and all Django processes including cron jobs and WSGI processes to ensure nothing is accessing the SQLite database, update the database section in mailman.cfg and the DATABASES settings in your Django settings, use SQLite tools to dump the relevant database(s) and PostgreSQL tools to create and load them, and finally restart Mailman core and all Django processes.
Fantastic. I'll give it a shot and update.
It occurs to me, it might be trickier than that in that dumping the SQLite database(s) and then loading them into PostgreSQL might result in table/column definitions in PostgreSQL that are inconsistent with the models because of differences in what SQLite and PostgreSQL support.
If this is the case, it might be necessary to let Mailman core and Django create (empty) PostgreSQL tables and then just load the data from SQLite.
-- Mark Sapiro <mark@msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan