Настройка репликации Master/Slave Postgrespro-1C-13 на Ubuntu 20.04

ant3k, 04 Июл 2021

Master node

$ sudo -u postgres psql
postgres=# CREATE USER replication WITH REPLICATION ENCRYPTED PASSWORD 'пароль';
postgres=# \q
$ echo "host replication replication *SLAVE_NODE_IP* md5" >> /var/lib/pgpro/1c-13/data/pg_hba.conf

$ sudo -u postgres psql

postgres=# CREATE USER replication WITH REPLICATION ENCRYPTED PASSWORD 'пароль';

postgres=# \q

$ echo "host replication replication *SLAVE_NODE_IP* md5" >> /var/lib/pgpro/1c-13/data/pg_hba.conf

Slave node

$ sudo -u postgres pg_basebackup -h *MASTER_NODE_IP* -U  replication -p 5432 -D /var/lib/pgpro/1c-13/data/ -R -P
$ systemctl enable postgrespro-1c-13.service
$ sudo systemctl start postgrespro-1c-13.service

$ sudo -u postgres pg_basebackup -h *MASTER_NODE_IP* -U replication -p 5432 -D /var/lib/pgpro/1c-13/data/ -R -P

$ systemctl enable postgrespro-1c-13.service

$ sudo systemctl start postgrespro-1c-13.service

Promotion slave to master

$ sudo -u postgres psql
postgres=# select pg_promote();

1 2	$ sudo -u postgres psql postgres=# select pg_promote();

zamru.ru | Заметки ру

Настройка репликации Master/Slave Postgrespro-1C-13 на Ubuntu 20.04

Рубрики

Архивы

Свежие записи

zamru.ru © Все права защищены 2024