cloudsql. logical_decoding
is on and wal_sender_timeout
is 0. These settings should mostly be pre-configured if you are migrating from another data replication tool.
Edit Button in CloudSQL Postgres
cloudsql.logical_decoding
to on and wal_sender_timeout
to 0. These changes will need restarting your Postgres server.Change cloudsql.logical_decoding to on
Changed cloudsql.logical_decoding and wal_sender_timeout
Restart Server
peerdb_user
. Below example shows setting up permissions for the public
schema. If you want to grant access to multiple schemas, you can run these three commands for each schema.
Generate a key-pair
peerdb_key.pem
) and a public key (peerdb_key.pub
).Add public key to your jump server
~/.ssh/authorized_keys
file on the jump server.Add private key to the connection
CloudSQL Connection Connection Section
Networking Sub Section in the Conenction Section
Add PeerDB Networks
PeerDB Networks Added
peerdb_user
that you created in the previous step.
Choose PostgreSQL Peer
Peer Creation and Validation
Created Peer