Replication pgsql: Porovnání verzí
Skočit na navigaci
Skočit na vyhledávání
založena nová stránka s textem „ <pre> master db -> postgresql.conf listen_addresses = '*' wal_level = replica max_wal_senders = 10 CREATE ROLE replica_user WITH REPLICATION LOGIN PASSWORD 'pwd'; pg_hba.conf host replication all 0.0.0.0/0 scram-sha-256 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 #pwd systemctl start postgresql…“ |
Bez shrnutí editace |
||
| (Není zobrazena jedna mezilehlá verze od stejného uživatele.) | |||
| Řádek 6: | Řádek 6: | ||
listen_addresses = '*' | listen_addresses = '*' | ||
wal_level = replica | wal_level = replica | ||
max_wal_senders = 10 | max_wal_senders = 10 #if valuechange, slave have to have the same value | ||
CREATE ROLE replica_user WITH REPLICATION LOGIN PASSWORD 'pwd'; | CREATE ROLE replica_user WITH REPLICATION LOGIN PASSWORD 'pwd'; | ||
SELECT pg_create_physical_replication_slot('slave_node_1'); | |||
pg_hba.conf | pg_hba.conf | ||
host replication all 0.0.0.0/0 scram-sha-256 | ##host replication all 0.0.0.0/0 scram-sha-256 | ||
host replication all 10.200.201.0/24 md5 | |||
| Řádek 20: | Řádek 22: | ||
slave -> | slave -> | ||
rm -rf /var/lib/postgresql/12/main/* | 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 #pwd | ##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 | systemctl start postgresql | ||
Aktuální verze z 12. 8. 2026, 15:44
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;