MySQL to PostgreSQL, a tricky move for ISKsense

I just finished migrating ISKsense to PostgreSQL. This was more of a move for convenience’s sake, as MySQL on my server is basically deprecated because PostgreSQL rocks so hard. ISKsense is the last major app to move, and by far the trickiest. The move comes as I prepare to move the server to Ruby 1.9.1 from Ruby 1.8.7, a major change; I had the ISKsense source checked out on my staging server for 1.9.1 testing and decided to go ahead and move the db.

This is kinda a documentation post to describe the move and how you, too, can migrate your databases with a relative amount of sanity remaining intact, unlike me. Continue reading MySQL to PostgreSQL, a tricky move for ISKsense