📄️ Amazon RDS/Aurora PostgreSQL CDC setup guide
Amazon Relational Database Service (RDS) and Amazon Aurora, both fully managed by Amazon Web Services (AWS), offer scalable and reliable infrastructures for running PostgreSQL databases in the cloud. This document will guide you through configuring PostgreSQL on Amazon RDS or Aurora, including setting up Change Data Capture (CDC) to efficiently track and capture database changes.
📄️ Google Cloud PostgreSQL CDC setup guide
Google Cloud SQL is a fully managed database service that simplifies the process of setting up, maintaining, managing, and administering relational databases on the Google Cloud Platform (GCP). With the capability of Change Data Capture (CDC), Cloud SQL allows you to capture and replicate data changes in real-time from your database instances. This feature can be enabled by configuring logical decoding within your Cloud SQL instances.
📄️ Configuring PostgreSQL CDC replication slots and publications
Replication is a key feature in database management systems that allows the synchronization of data between multiple database instances. It is commonly used for various purposes, such as high availability, disaster recovery, and data distribution. In some replication setups, publication slots are used to control the flow of changes between the master and replica databases.
