MySQL to PGLoader migration error on Managed database
I’m trying to migrate to a managed database, both hosted in DigitalOcean, one is a MySQL cluster, the other is a POSTGRES one.
When I enter this command:
pgloader mysql://<DB_USER>:<DB_PASS>@<DB_HOST>:<DB_PORT>/<DB_NAME "postgresql://<DB_USER>:<DB_PASS>@<DB_HOST>:<DB_PORT>/<DB_NAME>"
I get this error:
Failed to connect to pgsql at "MY-HOST" (port MY-PORT) as user "MY-USER": Database error 28000: no pg_hba.conf entry for host <MY_PC_IPV4>, user "MY-USER", database "MY-DB", SSL off
Can somebody help me? I’m banging my head against the wall as I seem to be doing something very wrong.
I created the clusters normally and they are accepting all incoming connections (no IP restrictions).