Some Tables are migrated, the most are not.
Any helpful error message given, neither in the logs.
LOAD DATABASE
FROM postgres://pgmigrator@:6432/foo_system_slot0
INTO pgsql://postgres@/foo_slot0
WITH include drop, create tables, create indexes, reset sequences
SET PostgreSQL PARAMETERS
maintenance_work_mem to '128MB',
work_mem to '12MB'
alter schema 'public' rename to 'foo_slot0'
;
$ pgloader pgloader.conf
2022-11-17T17:39:53.012001Z LOG pgloader version "3.6.7~devel"
2022-11-17T17:39:53.072001Z LOG Migrating from #<PGSQL-CONNECTION pgsql://pgmigrator@UNIX:6432/foo_system_slot0 {1006434383}>
2022-11-17T17:39:53.072001Z LOG Migrating into #<PGSQL-CONNECTION pgsql://postgres@UNIX:5432/foo_slot0 {100645E1B3}>
KABOOM!
TYPE-ERROR: The value
NIL
is not of type
PGLOADER.CATALOG:COLUMN
An unhandled error condition has been signalled:
The value
NIL
is not of type
PGLOADER.CATALOG:COLUMN
What I am doing here?
The value
NIL
is not of type
PGLOADER.CATALOG:COLUMN
Some Tables are migrated, the most are not. Any helpful error message given, neither in the logs.
LOAD DATABASE FROM postgres://pgmigrator@:6432/foo_system_slot0 INTO pgsql://postgres@/foo_slot0
WITH include drop, create tables, create indexes, reset sequences
SET PostgreSQL PARAMETERS maintenance_work_mem to '128MB', work_mem to '12MB'
alter schema 'public' rename to 'foo_slot0' ;
$ pgloader pgloader.conf 2022-11-17T17:39:53.012001Z LOG pgloader version "3.6.7~devel" 2022-11-17T17:39:53.072001Z LOG Migrating from #<PGSQL-CONNECTION pgsql://pgmigrator@UNIX:6432/foo_system_slot0 {1006434383}> 2022-11-17T17:39:53.072001Z LOG Migrating into #<PGSQL-CONNECTION pgsql://postgres@UNIX:5432/foo_slot0 {100645E1B3}> KABOOM! TYPE-ERROR: The value NIL is not of type PGLOADER.CATALOG:COLUMN An unhandled error condition has been signalled: The value NIL is not of type PGLOADER.CATALOG:COLUMN
What I am doing here?
The value NIL is not of type PGLOADER.CATALOG:COLUMN