Explains the difference between restart_lsn and confirmed_flush_lsn in PostgreSQL replication slots for troubleshooting and optimization.
Investigates unexpected WAL growth in an idle Postgres database due to an inactive replication slot, with analysis and solution.
Investigates unexpected WAL growth and disk space consumption in an idle Postgres database due to an inactive logical replication slot.
Overview of methods and tools for streaming data changes from Oracle databases into Apache Kafka, including CDC options.
Using KSQL to flatten nested CDC data from Kafka for use with the JDBC Sink connector.
