News for hackers. Stuff that matters.
Re:MySQL to PostgreSQL converter by jeltz on Saturday February 28, 2015 @10:13AM (#9123848)
I would recommend using pgloader (http://pgloader.io/) instead. It is simple to use in the default case, but can be configured with rules for how data types should be converted if necessary. It can also clean up weird timestamps like 0000-00-00 00:00:00.
Re:MySQL to PostgreSQL converter by adamferguson on Saturday February 28, 2015 @01:07PM (#9124448)
Upvote for pgloader. Moving data from SQL Server into Postgres with PGLoader has been fairly seamless and the maintainer is very responsive on Github.
Re:MySQL to PostgreSQL converter by louthy on Saturday February 28, 2015 @04:59PM (#9125207)
There doesn't seem to be any mention of SQL Server on the site? I am in the process of researching a move to Postgres from SQL Server, so if you have any other info on how you achieved this that'd be very much appreciated.

EDIT I see it now. Still, anything that you think useful would be great :)

Re:MySQL to PostgreSQL converter by jeltz on Saturday February 28, 2015 @09:59PM (#9125876)
Nice to hear that it works so well already. It is a very new feature which was sponsored by the company I work for only a couple of months ago. We are not even done migrating our database yet (we have to convert stored procedures and the queries in the application too).
Re:MySQL to PostgreSQL converter by scrollaway on Saturday February 28, 2015 @01:03PM (#9124436)
Seconded. Used pgloader to turn a massive mysql database into postgres. Turned out great.
Re:MySQL to PostgreSQL converter by anacleto on Saturday February 28, 2015 @04:39PM (#9125161)
+1 pgloader.