Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-4814

spatial_ref_sys table should be excluded in Postgres connector

XMLWordPrintable

    • False
    • False
    • Hide

      Launch standard debezium server with postgres-example container. Notice the spatial_ref_sys table synced.

      Show
      Launch standard debezium server with postgres-example container. Notice the spatial_ref_sys table synced.

      Not sure if this is a bug or enhancement - 

      When the GIS plugin is installed in Postgres, it creates the spatial_ref_sys table within the user schema by default. This table seems to be a data dictionary table and not part of the user data. 
      Currently, if a exclude list is not provided, it gets synced by default. In the postgres-example, the GIS module is installed, resulting in this system table being synced as part of the standard example demo setup.
      I suggest to exclude this table by default within the Postgres connector's settings.

            Unassigned Unassigned
            zalmane Oren Elias (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: