Migration sqlite to PostgreSQL

i moved the database from SQLITE to POSTGRESQL using pgloader. Migration was successful.
But now i see the error in the log file :

t=2018-09-12T11:43:10+0300 lvl=eror msg=“Failed to get system stats” logger=metrics error=“pq: invalid input syntax for integer: "true"”

What it means ?

Can anyone help ? How can fix it ?

I appears that when migrating from sqlite to postgres, certain columns need to be cast to booleans (SQLite has no dedicated boolean type) so there is no totally direct way to do this. I’m going to try to come up with a tool to do it. I will link it here if/ when that happens.

@qhartman , I am facing the same issue after migration from sqlite to postgressql through pgloader. Is there any solution or tool for this to resolve? or do I need to make changes manually?

Man, this was a long time ago. I did ultimately overcome the problem, but I don’t recall the solution exactly. I expect I dumped the data out of sqlite and wrote a throwaway script to coerce the necessary data to booleans. Sorry I can’t be of more help.

1 Like