Matrix3.2.2/MySQL -->Matrix3.4/PostgreSQL

Squiz Matrix Installation
1

Is it possible for a database newbie to migrate
Matrix from MySQL to PostgreSQL?

2

It is possible, but you'll have to do some reading into it.
I havnt done a MySQL to PostgreSQL for a while, but what I remember is:


  • MySQL can dump the database to a file with extended inserts (or soemthing) so it can go into the PostgreSQL database fairly easily.
  • Sequences are done differently in MySQL, so you cant just dump them into PostgreSQL. You need to change the MySQL dump so it creats real PostgeSQL sequences and runs the command in PostgreSQL to set the current sequence value.
  • There may have been some PostgreSQL reserved words that MySQL does not quote. I think I just changed the MySQL dump file as I came across them.



    For anyone attempting this, make sure you run your PostgreSQL queries in a transaction so you dont have to keep clearing out the DB :wink: