pgloader index test

this demo project is for gitlab table migration

export data

pg_dump  -h hostip  -p 5432 -U postgres   -t members -d postgres > members.sql

pg_dump  -h hostip  -p 5432 -U postgres   -t users -d postgres > users.sql

import test data

import externel data from pg 2 local test pg source

psql -h 127.0.0.1 -U postgres -p 5432 -d postgres < users.sql
psql -h 127.0.0.1 -U postgres -p 5432 -d postgres < members.sql

exec pgloader for data import

• start local test pg dbs

docker-compose up -d postgres postgres2

• exec load datas

docker-compose up pgloader-pg

some refs

pg2pg-pgloader