Required settings
- Host name
- Port (default is
5432
) - Service account
- Database name (with logical replication enabled)
Provider specific instructions
Additional features
PostgreSQL 16
PostgreSQL 16
Logical replication on standby replicas is not available for Amazon Aurora.
- Create
dbz_publication
publication on the primary database
- Enable
hot_standby_feedback
on the standby server
WAL_LEVEL
is set tological
on the standby server
Heartbeats
Heartbeats
Once you selected
Enable heartbeats
under Advanced settings, you will then need to run the following command:Customize publications mode
Customize publications mode
Don’t want to enable publications to capture all the tables? You can change this behavior by selecting 
Filtered
under the Pipeline advanced settings.If you change this to be filtered, you are responsible for adding and removing any captured tables from the publication. Our validation will check that the publications is configured correctly.
Changing the behavior of Postgres publications
TOAST columns
TOAST columns
TOAST (The Oversized-Attribute Storage Technique) is a mechanism used by Postgres to store large column values to alleviate the page size limit. TOAST columns may be different data types such as
text
, jsonb
, bytea
, array
, etc.One thing that is special about TOAST columns is that if the column value has not changed, the column value will not be included in WAL if the table’s replica identity is set to default
. Artie has automatic detection built-in to detect an unchanged TOAST column and will conditionally replicate this into the target database.Our built-in process will detect if an incoming CDC event has an unchanged TOAST column and will not update the column value in the target database. We are able to do all of this without having to increase your table replica identity.Monitoring
Monitoring
We have regular monitors that provide additional guardrails around your database replication, and will do the following:
- Regularly check and monitor your replication slot size in 15-minute intervals and notify if the slot exceeds a certain threshold.
- Heartbeats verification. For folks that are leveraging heartbeats, we will alert you if a heartbeat query fails.
- Terminate any idle queries that are lingering for more than a day. You can avoid having this problem by setting
idle_in_transaction_session_timeout
.