我最近在我的机器上安装了postgreSQL 12。我在本地具有PostgreSQL兼容的MySQL数据库转储abc-postgres.sql.gz。我还使用brew install pgloader

不确定如何将其加载到我的PostgreSQL 12服务器上。

我在这里找到的命令是-

pgloader mysql://user@host/db_name postgresql://user@host/db_name

我不确定如何利用这一点。任何帮助都将使我真正地继续进行数据库项目。

尝试过此操作，但仍然无法使用

mysql://localhost:pass@host/f1db postgresql://localhost:pass@host/postgres
2020-09-05T19:29:06.023000+01:00 LOG pgloader version "3.6.2"
2020-09-05T19:29:06.025000+01:00 LOG Data errors in '/private/tmp/pgloader/'
KABOOM!
FATAL error: Failed to connect to pgsql at "host" (port 5432) as user "localhost": Database error: Name service error in "getaddrinfo": 8 (nodename nor servname provided,or not known)
An unhandled error condition has been signalled:
   Failed to connect to pgsql at "host" (port 5432) as user "localhost": Database error: Name service error in "getaddrinfo": 8 (nodename nor servname provided,or not known)




What I am doing here?

Failed to connect to pgsql at "host" (port 5432) as user "localhost": Database error: Name service error in "getaddrinfo": 8 (nodename nor servname provided,or not known)

谢谢