JSON
.
Create Mirror Screen
Click on Mirrors tab and then enter new Mirror screen
Mirror Type
Mirror Name
prod_pg_to_kafka_v1
or dev_pg_to_kafka
.Select Source and Destination Peers
source and destination drop down
Mirror Configuration
peerdb_publication
), don’t forget adding that in this field.JSON
or you can create your own script, see: Scripting.Replication Slot Name
Table Selection
<source_schema>.<source_table>
.topic.creation.enable
property. The default value for the property is true
, enabling automatic topic creation, as shown in the following example:Table Selection
Review and Create
Validate Mirror
button. If there are any errors, you will see them on the screen. If there are no errors, you will see a success message. Once you see the success message, click on the Create Mirror
button to create the mirror ✨.TOAST
columns, it’s essential to configure the replica identity to FULL
to enable PeerDB to accurately capture changes to these columns.
Setting REPLICA IDENTITY FULL
on tables that include primary keys—or when operating on PostgreSQL 16 — typically imposes minimal overhead on the primary server.
For an in-depth analysis, refer to this detailed blog post on the performance implications.