pgloader failed to find schema "public" in target catalog.
I am doing MSSQL Server to PostgreSQL Migration . i have created table using pgloader after that migrating data into tables. I am getting this error.
2025-01-31T21:31:42.028511Z INFO Stopping monitor
What I am doing here?
pgloader failed to find schema "public" in target catalog.
On PostgreSQL side schema.
PrinterPixGB-TEST=# \dn List of schemas Name | Owner --------+------------------- dbo | pg_database_owner out | postgres switch | postgres (3 rows)
This is my load file .
LOAD DATABASE FROM mssql://###################/PrinterPixGB INTO postgresql://postgres:#####################PrinterPixGB-TEST
WITH include no drop, create no tables, prefetch rows = 100, max parallel create index = 1, data only ALTER SCHEMA 'dbo' RENAME TO 'public' SET work_mem to '16MB', maintenance_work_mem to '2GB';
pgloader version :-pgloader version "3.6.9" compiled with SBCL 2.2.10-1.rhel9