Replication pgsql

Z wiki
Skočit na navigaci Skočit na vyhledávání
master db -> 

postgresql.conf
listen_addresses = '*'
wal_level = replica
max_wal_senders = 10  #if valuechange, slave have to have the same value


CREATE ROLE replica_user WITH REPLICATION LOGIN PASSWORD 'pwd';
SELECT pg_create_physical_replication_slot('slave_node_1');


pg_hba.conf
##host    replication     all             0.0.0.0/0               scram-sha-256
host    replication     all             10.200.201.0/24         md5




slave ->
rm -rf /var/lib/postgresql/12/main/*
##pg_basebackup -h 10.200.200.4 -p 9005 -D /var/lib/postgresql/12/main/ -U replica_user -P -R -X stream -c fast -S slave_node_1 #pwd
pg_basebackup -h 10.200.201.6 -p 5432 -D /var/lib/postgresql/12/main/ -U replica_user -P -R -X stream -c fast -C -S slave_node_1 #pwd
systemctl start postgresql


master -> 
SELECT * FROM pg_stat_replication;