Pgloader: A High-Speed PostgreSQL Swiss Army Knife, Written in Lisp

by kesor on 9/26/2021, 7:27 AM with 12 comments
  • by jabiko on 9/26/2021, 6:22 PM

    A few years back I had some experience using this tool to migrate a MySQL database to a PostgreSQL. As far as I remember it was quite pleasant.

    I had the some trouble with MySQL accepting invalid dates (like 0000-00-00) while Postgres rejects such dates. However, there was an option to convert such dates to NULL which saved the day.

    Also you have to manually rewrite your views. Since we had a lot and also very complicated views I ended up materializing each MySQL view, manually porting it to Postgres and then comparing the result. That worked quite well.

  • by throwthere on 9/26/2021, 3:40 PM

    This is from the same person that wrote The Art of PostgreSQL.

  • by jamal-kumar on 9/26/2021, 5:21 PM

    I liked this tool. Just be sure that if you want to do stuff like transformations on the data that you are migrating that if you don't already know a dialect of lisp that you're going to have to pick that up real fast.

    Might be viable if you have time to do that but if not strongly consider writing your own migration scripts in python or whatever you already know.

  • by spacemanmatt on 9/27/2021, 1:27 PM

    I had a great experience with pg_loader in 2014 but I had to use SBCL to make it work reliably. I'm curious if someone can inform my experience there -- I'm not a regular CLisper, I just followed some advice I found on a forum.

  • by recentdarkness on 9/26/2021, 3:37 PM

    I wanted to use it as well on windows the other day. Because I wanted to migrate a mssql database to PostgreSQL. However AFAIR there were no builds I could find and from what I read in the issues it is quite discouraging, a pity

  • by sigjuice on 9/26/2021, 4:04 PM
  • by on 9/26/2021, 4:04 PM

    undefined