Migrate individually historical data, pgloader

Create user on PostgreSQL server:

PGPORT=7412 createuser --pwprompt zabbix

Create DB on PostgreSQL server:

dropdb zabbixDB && createdb -O zabbix zabbixDB

Structure without historical data:

cat << 'EOF' > without.history.conf
LOAD DATABASE
FROM mysql://root:zabbix@10.133.80.228:3307/z42
INTO postgresql://zabbix:zabbix@10.133.112.87:7412/zabbixDB
WITH include no drop,
truncate,
create no tables,
create no indexes,
no foreign keys,
reset sequences,
data only
SET maintenance_work_mem TO '256MB', work_mem to '64MB'
ALTER SCHEMA 'z42' RENAME TO 'public'
EXCLUDING TABLE NAMES MATCHING ~/history*/, ~/trends*/
BEFORE LOAD EXECUTE create.sql
AFTER LOAD EXECUTE alter.sql
;
EOF

History only:

cat << 'EOF' > history.trends.conf
LOAD DATABASE
FROM mysql://root:zabbix@10.133.80.228:3307/z42
INTO postgresql://zabbix:zabbix@10.133.112.87:7412/zabbixDB
WITH include no drop,
truncate,
create no tables,
create no indexes,
no foreign keys,
reset sequences,
data only
SET maintenance_work_mem TO '256MB', work_mem to '64MB'
ALTER SCHEMA 'z42' RENAME TO 'public'
including only table names matching ~/history*/, ~/trends*/
;
EOF