Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
salmanprinterpix opened this issue Jan 31, 2025 · 0 comments
Open

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

salmanprinterpix opened this issue Jan 31, 2025 · 0 comments

Comments

@salmanprinterpix
Copy link

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant