Postgres Retl Setup Guide

Required permissions

The user account, used for authentication, must have these permissions:

• Add, update, and delete rows in your sync's table.

  To grant permissions for a particular table:

  GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE <your_table> TO <your_username>;

  To grant permissions for all tables in a schema:

  GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA <your_schema> TO <your_username>;

• View metadata from the following tables:

  • INFORMATION_SCHEMA.COLUMNS
  • INFORMATION_SCHEMA.TABLE_CONSTRAINTS
  • INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE

  To grant these permissions, run:

  GRANT SELECT ON TABLE information_schema.columns TO your_username;

  GRANT SELECT ON TABLE information_schema.table_constraints TO your_username;

  GRANT SELECT ON TABLE information_schema.constraint_column_usage TO your_username;

Setup Guide

1. Fill in the Username, Password, Hostname, Port and Database for your Postgres database.
2. If the SSL configuration of your database is either allow, require or prefer, set the SSL toggle to ON.
3. Enter a Name for the connector.
4. (Optional) Enter a Description for the connector.
5. Select the Owner of the connector.
6. (Optional) Verify that your Postgres database is successfully connected by clicking on Test Connection.
7. Click Connect.

Supported Sync Modes

• Mirroring