rds.logical_replication
is 1 and wal_sender_timeout
is 0. These settings should mostly be pre-configured if you are migrating from another data replication tool.
Checking if the logical replication is already enabled
rds.logical_replication
set to 1; and wal_sender_timeout
set to 0.
Where to find Parameter groups in RDS?
Changing rds.logical_replication
Changing wal_sender_timeout
Modifying RDS Postgres with new parameter group
Reboot RDS Postgres
peerdb_user
. Below example shows granting 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
Inbound rules
of the Security group
in which your
RDS Postgres (OR the Jump Server/Bastion if you are using SSH tunneling) is located.
Where to find security group in RDS Postgres?
Edit inbound rules for the above security group
peerdb_user
that you created in the previous step.
Create peer drop down
Create RDS Postgres Peer