migrating your app from mysql to psql the nice way

today i want to talk about something that might be of growing interest in the near future. how to get all your data from that dying old mysql database to your shiny new postgresql without all the heavy lifting?