I’m finally getting around to look into converting my database from mysql to postgresql. What’s the best way to go about doing this?
When my instance’s performance tanked a long time ago, I upgraded and blogged about it. The procedure will probably have changed slightly as additional tables have been added, but it worked well for me.
Be absolutely sure to tailor your postgres configuration. You can use https://pgtune.leopard.in.ua/ to generate a good config for your hardware.