PostgreSQL 的 FDW 访问远程 Mysql_server 报错 - V2EX
lewin5

PostgreSQL 的 FDW 访问远程 Mysql_server 报错

  •  
  •   lewin5 Jun 14, 2019 3988 views
    This topic created in 2531 days ago, the information mentioned may be changed or developed.

    创建了对应的 mysql_fdw 和 mysql_srv,远程也能连接 mysql 服务器, 但是执行 import foreign schema tpch from server mysql_svr into public; 建立映射 import 对应库 tpch 到 pg 内创建 schema 的时候报错 ERROR: failed to connect to MySQL: Unknown MySQL server host '' (-2)

    test=# select * from pg_foreign_server; srvname | srvowner | srvfdw | srvtype | srvversion | srvacl | srvoptions
    -----------+----------+--------+---------+------------+--------+---------------------------------- mysql_svr | 10 | 16394 | | | | {host=192.168.137.233,port=3306} (1 row)

    查询 msyql_svr 对应 host 是 ok 的,报错 host 对应的是'',有碰到过这个问题解决的朋友吗?

    2 replies    2019-06-17 11:42:31 +08:00
    beginor
        1
    beginor  
       Jun 14, 2019 via Android
    只用过 fdw 访问 PG 数据库,异构数据库还是 ETL 吧
    lewin5
        2
    lewin5  
    OP
       Jun 17, 2019
    @beginor 现在已经确定了用 PG 原生的 fdw 来访问 mysql 数据库,后面验证了下好像跟 mysql 的版本有关,5.X 版本跟 8.0 版本的 mysql 对应访问会出现 host 报错的问题,5.7 跟 5.6 就没有上面问题。谢谢了。
    About     Help     Advertise     Blog     API     FAQ     Solana     3066 Online   Hihest 6679       Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 59ms UTC 12:22 PVG 20:22 LAX 05:22 JFK 08:22
    Do have faith in what you're doing.
    ubao msn snddm index pchome yahoo rakuten mypaper meadowduck bidyahoo youbao zxmzxm asda bnvcg cvbfg dfscv mmhjk xxddc yybgb zznbn ccubao uaitu acv GXCV ET GDG YH FG BCVB FJFH CBRE CBC GDG ET54 WRWR RWER WREW WRWER RWER SDG EW SF DSFSF fbbs ubao fhd dfg ewr dg df ewwr ewwr et ruyut utut dfg fgd gdfgt etg dfgt dfgd ert4 gd fgg wr 235 wer3 we vsdf sdf gdf ert xcv sdf rwer hfd dfg cvb rwf afb dfh jgh bmn lgh rty gfds cxv xcv xcs vdas fdf fgd cv sdf tert sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf shasha9178 shasha9178 shasha9178 shasha9178 shasha9178 liflif2 liflif2 liflif2 liflif2 liflif2 liblib3 liblib3 liblib3 liblib3 liblib3 zhazha444 zhazha444 zhazha444 zhazha444 zhazha444 dende5 dende denden denden2 denden21 fenfen9 fenf619 fen619 fenfe9 fe619 sdf sdf sdf sdf sdf zhazh90 zhazh0 zhaa50 zha90 zh590 zho zhoz zhozh zhozho zhozho2 lislis lls95 lili95 lils5 liss9 sdf0ty987 sdft876 sdft9876 sdf09876 sd0t9876 sdf0ty98 sdf0976 sdf0ty986 sdf0ty96 sdf0t76 sdf0876 df0ty98 sf0t876 sd0ty76 sdy76 sdf76 sdf0t76 sdf0ty9 sdf0ty98 sdf0ty987 sdf0ty98 sdf6676 sdf876 sd876 sd876 sdf6 sdf6 sdf9876 sdf0t sdf06 sdf0ty9776 sdf0ty9776 sdf0ty76 sdf8876 sdf0t sd6 sdf06 s688876 sd688 sdf86