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

Unable to connect to Azure SQLServer with Pgloader #1611

Open
srinivasmummareddy opened this issue Sep 13, 2024 · 2 comments
Open

Unable to connect to Azure SQLServer with Pgloader #1611

srinivasmummareddy opened this issue Sep 13, 2024 · 2 comments

Comments

@srinivasmummareddy
Copy link

srinivasmummareddy commented Sep 13, 2024

migrate.load file data:

LOAD DATABASE
    FROM mssql://user:pass@test-sqlserver.database.windows.net/Configuration
    INTO postgresql://user:pass@test-postges-poc.postgres.database.azure.com/Configuration?sslmode=require


WITH include no drop, create tables, create indexes, reset sequences,
    data only

SET work_mem to '16MB',
    maintenance_work_mem to '512 MB';

I'm getting the following error but not able to see any clear log:
pgloader --verbose migrate.load
2024-09-13T04:19:46.000000Z NOTICE Starting pgloader, log system is ready.
2024-09-13T04:19:46.010000Z LOG pgloader version "3.6.3~devel"
2024-09-13T04:19:46.010000Z LOG Data errors in '/tmp/pgloader/'
2024-09-13T04:19:46.010000Z LOG Parsing commands from file #P"/home/srinim/migrate.load"
2024-09-13T04:19:49.130000Z LOG Migrating from #<MSSQL-CONNECTION mssql://user@test.sqlserver.database.windows.net:1433/Configuration {100800E423}>
2024-09-13T04:19:49.130000Z LOG Migrating into #<PGSQL-CONNECTION pgsql://usern@postges-poc.postgres.database.azure.com:5432/Configuration {100800FF03}>
2024-09-13T04:19:49.990000Z ERROR mssql: Failed to connect to mssql at "test-sqlserver.database.windows.net" (port 1433) as user "user": Connection to the database failed for an unknown reason.

Note: I'm able to connect to ms sql server from other utilities only having issue with pgloader

@srinivasmummareddy
Copy link
Author

@dimitri

@jdeckcurago
Copy link

I'm having a similar issue. Will post details soon. I have a config that authenticates though, but then it throws a max connections error.

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

2 participants