GCP Cloud SQL

WAL level

Logical replication is turned off by default. To turn it on, you have to update the cloud flag: cloudsql.logical_decoding = on. This will need a restart of your instance before SHOW wal_level; returns logical.

Connection

Run the below command and then you can connect with the same credentials on the Bemi dashboard!

-- Grant replication permission to allow using replication slots
ALTER USER [user] WITH REPLICATION;