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: