PostgreSQL 13 logical replication configuration

Prerequisite: Two VM hosts with PostgreSQL 13 preinstalled. Master Node: pg13-master; 192.168.56.71 Standby Node: pg13-replica; 192.168.56.72 Logical replication uses a publish and subscribe model with one or more subscribers subscribing to one or more publications on a publisher node. Subscribers pull data from the publications they subscribe to and may subsequently re-publish data to allow…

PostgreSQL 13 stream replication configuration using rsync in Linux

Prerequisite: Two VM hosts with PostgreSQL 13 preinstalled. Master Node: pg13-master; 192.168.56.69 Standby Node: pg13-standby; 192.168.56.70 rsync should be installed on the nodes to transfer WAL files to the standby node. Configuration Steps: Configure passwordless authentication as continuous WAL archiving will be performed using rsync from master to standby node. On the master, execute ssh-keygen…

PostgreSQL 13 log shipping replication configuration using rsync in Linux

Prerequisite: Two VM hosts with PostgreSQL 13 preinstalled. Master Node: pg13-master; 192.168.56.67 Standby Node: pg13-standby; 192.168.56.68 rsync should be installed on the nodes to transfer WAL files to the standby node. Configuration Steps: Configure passwordless authentication as continuous WAL archiving will be performed using rsync from master to standby node. On the master, execute ssh-keygen…