Document a MySQL to Postgres Conversion process
We currently have a converter (https://github.com/gitlabhq/mysql-postgresql-converter/tree/gitlab) that works, but at a minimum doesn't create trigram indices: https://github.com/gitlabhq/mysql-postgresql-converter/issues/13
@dblessing suggested a possible short-term workaround is removing the trigram migrations and re-running them to generate the indices.
We should figure out:
- What else may be missed
- Document it
- Come up with a tool that is a "easy" way to convert.
I played with pgloader http://pgloader.io/ but ran into some issues w/ Docker & Mac (which may now be resolved - https://github.com/dimitri/pgloader/issues/583) If someone from Dev can pick this up so we can work on it ASAP it would be super helpful.
/cc @stanhu