Install source metabase for PostgreSQL - Connect_CDC - aws_mainframe_modernization_service - connect_cdc_mimix_share - 6.x

Connect CDC Getting Started Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (MIMIX Share)
Version
6.x
Language
English
Product name
Connect CDC
Title
Connect CDC Getting Started Guide
Copyright
2024
First publish date
2003
Last updated
2024-10-15
Published on
2024-10-15T20:38:41.117981
After you have defined a server, you can run any copy, synchronization request from PostgreSQL as a source to a target.
Note: For PostgreSQL on-prem, You need to set ALTER SYSTEM SET wal_level to logical otherwise metabase creation will fail. By default, the variable is replica. Also, set the number of max replication slots in the postgresql.conf. PostgreSQL service needs to be restarted to save the changes.
  1. Right-click the server and select Install Source Metabase in the menu that displays.
  2. Enter a user ID and password with administrative privileges and click OK.
  3. Specify the password for the replication user (the owner of the database which contains the metabase objects), then click OK.
    The Install Source Metabase dialog opens with actions that will be performed.

  4. To complete the operation of installing PostgreSQL as a source, see the above steps 5-7 in Install Target Only Metabase.

PostgreSQL AWS

  1. Go to Parameter groups and create a new parameter group.
  2. Choose the Db paramter family as Postgres13(preferred) and keep the type as it is.
  3. Edit the parameter rds.logical_replication to 1 and Save changes.
  4. Go to the Rds db instance and select and modify that db instance.
  5. Go to the parameter groups section and change it to the newly created one.
  6. Need to reboot the database instance.