How can I set up CDC for Managed Postgres Instance...
# replication-troubleshooting
k
How can I set up CDC for Managed Postgres Instance on GCP?
m
k
Cloud SQL for PostgreSQL is a managed service, so it restricts access to certain system procedures and tables that require advanced privileges. In Cloud SQL, customers cannot create or have access to users with superuser attributes. https://cloud.google.com/sql/docs/postgres/users#superuser_restrictions According to my understanding, postgres instances require superuser privileges to create replication slots, and based on the documentation, I doubt Google provides this level of support. This prompted me to consider how I could perform incremental load using airbyte (Update and Insert) Please let me know if you have implemented this or something similar.
m
As you read from the documentation maybe using the managed instance you can’t use incremental reads.