PostgreSQL Streaming(Hot Standby) Replication

Описание: 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