Migration from MySQL to Postgres fails

Troubleshooting
7

Hi@all,

so I have some news. I used newest pgloader soureces and then I was able to copy whole database to postgress via the follwoing pgloader config:

LOAD DATABASE
FROM mysql://mmuser:password@localhost:3306/mattermost
INTO pgsql://mmuser:password@localhost:5432/mattermost

 WITH include drop, create tables, create indexes, reset sequences

 SET maintenance_work_mem to '128MB', work_mem to '12MB', search_path to 'mattermost'

 CAST type datetime to timestamptz drop default drop not null using zero-dates-to-null,
      type date drop not null drop default using zero-dates-to-null

 BEFORE LOAD DO

$$ SET search_path TO mattermost; $$,
$$ DROP SCHEMA IF EXISTS mattermost CASCADE; $$,
$$ CREATE SCHEMA mattermost; $$;

Afterwards I removed by hand schema public and renamed Schema mattermost to public with the following commands:

DROP SCHEMA IF EXISTS public CASCADE;
ALTER SCHEMA mattermost RENAME TO public;

Then I can see old posts and users.

What do you think will it work with that approach? Or do I have to do some more manual work?
Im not able to test it until next week…