PostgreSQL 13 Cookbook: Over 120 recipes to build high-performance and fault-tolerant PostgreSQL database solutions by Vallarapu Naga Avinash Kumar

Author:Vallarapu Naga Avinash Kumar [Kumar, Vallarapu Naga Avinash]
Language: eng
Format: azw3, pdf
Publisher: Packt Publishing
Published: 2021-02-26T00:00:00+00:00

# sudo systemctl enable patroni

Copy the Patroni configuration file from the primary server to the standby server:

# scp /etc/patroni/patroni.yml [email protected]:/tmp

Replace the primary hostname with the standby hostname and the primary IP address with the standby IP address in the Patroni configuration file. Copy the file to an appropriate location where the service expects the configuration file to be:

# sed 's/pg1/pg2/g' /tmp/patroni.yml > /etc/patroni/patroni.yml

Additionally, if you have used any hard-coded IP addresses for nodes, replace them with the appropriate node IP address:

# sed -i 's/192.168.10.1/192.168.10.2/g' /etc/patroni/patroni.yml

Start the Patroni server to let Patroni run pg_basebackup. This will set up the standby and make it part of the Patroni cluster automatically:

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.