ppppppppppppppp

listen_addresses = '*'

wal_level = replica
max_wal_senders = 10
max_replication_slots = 10
wal_keep_size = 1GB

hot_standby = on
================================
# Replication
host    replication     replicator     172.16.26.162/32    scram-sha-256

# App access
host    all             all             172.16.26.0/24     scram-sha-256
==================================
sudo -u postgres psql <<EOF
CREATE ROLE replicator WITH REPLICATION LOGIN PASSWORD 'StrongReplicationPass!';
EOF
===============
sudo -u postgres psql -c "\du"
Créé il y a 4 semaines.