Build comprehensive audit logging systems with Postgres change data capture (CDC).
Select the source
Select the message type
Leave message grouping default
Specify backfill
action
of read
.Configure sink-specific settings
Update your application code
idempotency_key
which is intended for use by your application to reject any possible duplicate messages.
The idempotency key is available in the message metadata as metadata.idempotency_key
. For example, in a change message it would look like:
timestamp
or date
uuid
decimal
, bigint
, etc. based on precision needschanges
without retention, you can backfill from the source table. The change messages will be of action read
and will only include the value currently in the database. Old values and deleted rows are not included.