Enable logical replication on Google Cloud SQL
If you have not enabled logical replication on Google Cloud SQL
PostgreSQL® already, the following instructions shows how to set the
cloudsql.logical_decoding
parameter to On
.
-
Set the logical replication parameter for your Cloud SQL PostgreSQL® database.
-
Authorize the Aiven for PostgresSQL® IP to connect to Cloud SQL, using the network CIDR.
-
Set replication role to PostgreSQL user (or the user will be used for migration) in Cloud SQL PostgreSQL:
ALTER ROLE postgres REPLICATION;