when I using this command to migrate data from mysql 5.17.1 to postgresql 13 in my macOS Catalina 10.15.7:
pgloader mysql://root:[email protected]:3309/common postgresql://postgres:[email protected]:5432/dolphin
shows this error:
2021-02-02T14:35:18.015000Z LOG pgloader version "3.6.2"
2021-02-02T14:35:18.017000Z LOG Data errors in '/private/tmp/pgloader/'
KABOOM!
FATAL error: Failed to connect to pgsql at "postgres.dolphin.com" (port 5432) as user "postgres": 10 fell through ECASE expression. Wanted one of (0 2 3 4 5 6 7 8).
An unhandled error condition has been signalled:
Failed to connect to pgsql at "postgres.dolphin.com" (port 5432) as user "postgres": 10 fell through ECASE expression. Wanted one of (0 2 3 4 5 6 7 8).
What I am doing here?
Failed to connect to pgsql at "postgres.dolphin.com" (port 5432) as user "postgres": 10 fell through ECASE expression. Wanted one of (0 2 3 4 5 6 7 8).
(base)
I read the issue has the same problem but still not figure out where is the problem. What should I do to fix this problem?
password_encryptionset to inpostgresql.conffor the Postgres 13 server? 2) What are the contents of thepg_hba.conffile for the server? 3) Where are you runningpgloader? 4) What version ofpgloader? Add answers as update to your question. - Adrian Klaver