wal_level
is set to logical
. This setting should mostly be pre-configured if you are migrating from another data replication tool.
Server Parameters
wal_level
to logical
Change wal_level to logical
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.
wal_sender_timeout
to 0 for peerdb_user
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
Add PeerDB IPs to Firewall
peerdb_user
that you created in the previous step.
Choose PostgreSQL Peer
Peer Creation and Validation
Created Peer