logical
. If not, run:
peerdb_user
and peerdb_password
with your desired username and password.Also, remember to use the same publication name when creating the mirror in PeerDB.pg_hba.conf
file to allow connections to the PeerDB user from the PeerDB IP addresses. An example entry in the pg_hba.conf
file would look like:
Create the PostgreSQL Peer
max_slot_wal_keep_size
parameter for your PostgreSQL instance to a higher value (at least 100GB or 102400
) by updating the postgresql.conf
file.