Migrating diaspora from mysql to postgres

So I decided also on the update to move to postgresql. I found http://blog.koehn.com/technology/2014/08/21/diaspora-mariadb-to-postgres.html to be my best place to start, however I had lots of crap in my DB to also solve.

First I have open_aspects and password_salt in my users table that should have dropped, so I did.

Second, I had tons of created_at and updated_at that were NULL and that wont work to move to postgres so I populated them with now() as the date, hope that does not wonk things up a ton.

From the example post above I just needed to add the 3 new tables around chat and I was ready to run. The pod seems 3x faster now, running a tag search is now 1 second from 30. Should be a good move.

 

Sponsored post:

Clarke Morley

My Photo Gallery

Leave a Reply

Your email address will not be published. Required fields are marked *

This blog is kept spam free by WP-SpamFree.