I’ve been able to load my Sqlite database to Postgres using pgloader in terminal.
pgloader --debug --verbose --type sqlite '/PATHTOSTRAPI/.tmp/data.db' pgsql://USER:PASSWORD@HOST/DBNAME
Warning, It wasn’t working for me when PATHTOFILE had spaces. I moved the file in a directory without spaces and it worked.