Peter Thornton via Mailman-users writes:

 > We have a legacy environment with:
 > there are two sqlite3 dbs for mailman core and mailman web.
 > 
 > I've staged a new environment
 > there is a single postgres db here for both core and web.

This is known to be problematic.  Try searching the archives
https://lists.mailman3.org/archives/list/mailman-users@mailman3.org/
for "sqlite postgres migration" (or maybe use "sqlite3" and/or
"postgresql", and don't surround the phrase with quotes).

I would start by configuring the postgres db on the new host with
separate databases.  If you decide you want a single db, I guess it's
easier to add the tables from the mailmanweb db to the mailman db than
it is to get pgloader to do the right thing.

ISTR that the most straightforward approach was rather than using
pgloader, you should create the databases in Postgres then dump the
databases (text) and load them.  You probably need to edit them.
(This is very unreliable advice!)

It's almost 2am here, so I'm off to bed.  You should consider all of
the above advice except "known problematic" to be unreliable.


-- 
GNU Mailman consultant (installation, migration, customization)
Sirius Open Source    https://www.siriusopensource.com/
Software systems consulting in Europe, North America, and Japan
_______________________________________________
Mailman-users mailing list -- mailman-users@mailman3.org
To unsubscribe send an email to mailman-users-le...@mailman3.org
https://lists.mailman3.org/mailman3/lists/mailman-users.mailman3.org/
Archived at: 
https://lists.mailman3.org/archives/list/mailman-users@mailman3.org/message/FRIBUJRG6FPYBIXI3AWQKWVE4QQFNHMF/

This message sent to arch...@mail-archive.com

Reply via email to