PostgreSQL Streaming(Hot Standby) Replication
Автор: DBWise
Загружено: 2021-09-22
Просмотров: 1858
Описание:
https://m.do.co/c/02680c522b4f
centos-master - 10.139.0.2
centos-slave - 10.139.0.3
yum install nmap
nmap 10.139.0.2
https://www.digitalocean.com/communit...
sudo firewall-cmd --zone=home --change-interface=eth0
sudo firewall-cmd --set-default-zone=home
https://www.digitalocean.com/communit...
sudo yum install postgresql12-server
sudo /usr/pgsql-12/bin/postgresql-12-setup initdb
sudo systemctl start postgresql-12
sudo systemctl enable postgresql-12
sudo firewall-cmd --zone=home --permanent --add-service=postgresql
sudo firewall-cmd --reload
sudo firewall-cmd --zone=home --list-services
edit pg_hba.conf and postgresql.conf to open port for remote server
restart postgresql
• listen_addresses - *
• wal_level - Replica
• hot_Standby. – On
Create user repl_user with replication encrypted password 'Duryodhan@814';
/usr/pgsql-12/bin/pg_basebackup -h 10.139.0.2 -U repl_user -p 5432 -D /var/lib/pgsql/12/data -Fp -Xs -P -R -C -S repl_slot
validations.
master:
\x
select * from pg_stat_replication;
select * from pg_current_wal_lsn();
select * from pg_wal_lsn_diff('0/271D1158','0/271D1158');
select round(34/(1024*1024)) MB;
SELECT pg_walfile_name(pg_current_wal_lsn());
ALTER SYSTEM SET synchronous_standby_names TO '*';
restart postgresql
commit first on standby
slave :
select pg_is_in_recovery();
select * from pg_last_wal_receive_lsn();
select pg_promote();
bash-4.2$ /usr/pgsql-11/bin/pg_ctl promote -D /var/lib/pgsql/11/data
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке: