Difference between revisions of "Pgloader"
Jump to navigation
Jump to search
(Created page with "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 pgloa...") |
(No difference)
|
Latest revision as of 17:53, 12 October 2021
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';