Migration-assist tool hits a roadblock - migrating from mysql 8 to postgresql 15--Cannot connect to migrated postgresql db

Troubleshooting
5

Thanks, we always keep updating the docs. But please feel free to send a PR!

Re: your latest issue, the problem seems to be that your search_path has somehow set to null. That should not be the case.

I’d suggest to log in to the DB. psql -h localhost -U mmuser -d mattermost, again verify you are in the right database with select current_database();.

Now type select current_schema();. This should return nil. Then show search_path; should also be empty.

To fix this, run ALTER user mmuser in database mattermost set search_path to 'public';

And then logout, and login again. And run select current_schema(); to confirm that you see public in the output.

That should fix it.

3 Likes