Failed to connect to pgsql at "127.0.0.1" (port 5432) as user "postgres": Database error: Socket error in "connect": ECONNREFUSED (Connection refused)

[tanktank47]

I have MySQL 9.5 and PostgreSQL 18.1 and installed pgloader in a Docker Engine environment.
MySQL 9.5 and PostgreSQL 18.1 are now running.

While executing the pgloader command in PowerShell with the following command,
an error occurred.
The error message indicates that the PostgreSQL connection was refused.
No matter what I try, I cannot find the cause of the issue.
However, PostgreSQL is connecting fine in DBeaver.

① PowerShell Command:
docker run --rm -it pgloader-image pgloader -v --debug
"mysql://root:rootpassword@127.0.0.1:3306/MY" `
"postgres://postgres:mysecretpassword@127.0.0.1:5432/postgres"

② Error Message:
Failed to connect to pgsql at "127.0.0.1" (port 5432) as user "postgres": Database error: Socket error in "connect": ECONNREFUSED (Connection refused)

Have a Good Day!

[zll600]

Generally, the Docker container uses an isolated network with the host(your WSL here).
I guess in your situation.

1. Your PostgreSQL is running on the host 127.0.0.1:5432
2. Your pgloader sees the dsn "postgres://postgres:mysecretpassword@127.0.0.1:5432/postgres", and try to connect to 127.0.0.1, which is the pgloader container itself instead of your host.