pgloader icon indicating copy to clipboard operation
pgloader copied to clipboard

pgloader failed to find schema "public" in target catalog.

Open salmanprinterpix opened this issue 11 months ago • 0 comments

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

salmanprinterpix avatar Jan 31 '25 21:01 salmanprinterpix