Pgloader

Ubuntu fix

apt update && apt install -y build-essential sbcl

curl -LO https://github.com/dimitri/pgloader/releases/download/v3.6.2/pgloader-bundle-3.6.2.tgz
tar xf pgloader-bundle-3.6.2.tgz
cd pgloader-bundle-3.6.2
make

cp bin/pgloader /usr/local/bin/pgloader

/usr/local/bin/pgloader

example of grafana

load database
    from sqlite://grafana.db
    into postgresql://:5432/grafana?sslmode=require
    with include drop, create tables, create indexes, reset sequences
    set work_mem to '16MB', maintenance_work_mem to '512 MB';