Navigation

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Groups

    cloudCanal-PG 安装postgis同步 其他端看不到表

    问答区
    ··
    2
    2
    41
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • Nathan
      Nathan last edited by

      pg 版本 12.2

      PostgreSQL 12.2 (Debian 12.2-2.pgdg100+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 8.3.0-6) 8.3.0, 64-bit� 
      
      -- 扩展PG gis插件
      CREATE EXTENSION postgis;
      CREATE EXTENSION postgis_raster;
      CREATE EXTENSION postgis_sfcgal;
      CREATE EXTENSION fuzzystrmatch;
      CREATE EXTENSION address_standardizer;
      CREATE EXTENSION address_standardizer_data_us;
      CREATE EXTENSION postgis_tiger_geocoder;
      CREATE EXTENSION postgis_topology;
      SET postgis.enable_outdb_rasters = True;
      SET postgis.gdal_enabled_drivers = 'ENABLE_ALL';
      

      问题描述:

      pg.装完 postgis 插件后看不到 同步端看不到创建表,只有几张默认的系统表

      不安装postgis 纯pg 可以看到响应表,可以同步
      这个问题看能有没有解决方法

      junyu-cloudcanal 1 Reply Last reply Reply Quote 0
      • junyu-cloudcanal
        junyu-cloudcanal @Nathan last edited by

        @nathan 这个我们可能场景没验证过,得验证下。

        1 Reply Last reply Reply Quote 0
        • 1 / 1
        • First post
          Last post
        Copyright © 2020 ClouGence, Inc.备案号:浙ICP备20007605号-2