PostgreSQL 13 Cookbook by Unknown

Author:Unknown
Language: eng
Format: epub
Published: 2021-02-26T10:13:04+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.