Migrating a Rails project from MySQL to PostgreSQL
This brief guide is written from my own experience with migrating a large (~5GB) MySQL database to PostgreSQL for a Rails project.
No warranties, guarantees, support etc. Use at your own risk and, as always, ENSURE YOU MAKE BACKUPS FIRST!
I chose [
pgloader] because it's extremely fast. YMMV.
config/database.ymlfor PostgreSQL. I used [Rails' template] as a starting point.