repmgr安装部署

秒速五厘米 2022-05-22 10:54 165阅读 0赞

[https://repmgr.org/][https_repmgr.org]

官方操作手册Documentation

[https://repmgr.org/docs/4.0/index.html][https_repmgr.org_docs_4.0_index.html]

下载URL

[https://rpm.2ndquadrant.com/site/content/][https_rpm.2ndquadrant.com_site_content]    rpm

[https://repmgr.org/download/repmgr-4.0.5.tar.gz][https_repmgr.org_download_repmgr-4.0.5.tar.gz]  source code

**编译安装**

/home/zhaowzh/pg/pg966/  为 pg源码安装文件目录

从 [yum.postgresql.org][]为系统安装适当的存储库RPM

\[root@vlnx107002 repmgr\]\# wget  [https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86\_64/pgdg-centos96-9.6-3.noarch.rpm][https_download.postgresql.org_pub_repos_yum_9.6_redhat_rhel-7-x86_64_pgdg-centos96-9.6-3.noarch.rpm]

\[root@vlnx107002 repmgr\]\# rpm -i pgdg-redhat96-9.6-3.noarch.rpm

安装用于构建PostgreSQL的先决条件：

\[root@vlnx107002 repmgr\]\# yum check-update

\[root@vlnx107002 repmgr\]\# yum groupinstall "Development Tools"

\[root@vlnx107002 repmgr\]\# yum install yum-utils openjade docbook-dtds docbook-style-dsssl docbook-style-xsl

\[root@vlnx107002 repmgr\]\# yum-builddep postgresql96

开始安装 repmgr

\[root@vlnx107002 ~\]\# mkdir -p /home/zhaowzh/pg/pg966/contrib/repmgr

\[root@vlnx107002 ~\]\#  cp -R /home/zhaowzh/repmgr/repmgr405/\* /home/zhaowzh/pg/pg966/contrib/repmgr/

注意 确保目标PostgreSQL版本的pg\_config位于 $ PATH中   即 pg\_config所在的目录要与 ./configure --prefix=/usr/local/postgresql  下的bin 目录中。

\[root@vlnx107002 repmgr\]\# yum install gcc-c++

\[root@vlnx107002 repmgr\]\# ./configure --prefix=/usr/local/postgresql

\[root@vlnx107002 repmgr\]\#  make

\[root@vlnx107002 repmgr\]\# make install

![70][]

验证：

\[postgres@vlnx107002 ~\]$ repmgr --version

\[postgres@vlnx107002 ~\]$ repmgrd --version

![70 1][]

\[root@vlnx107002 9.6\]\# vim /etc/sudoers

Defaults:postgres !requiretty

postgres ALL = NOPASSWD: /usr/bin/systemctl stop postgresql-9.6, \\

/usr/bin/systemctl start postgresql-9.6, \\

/usr/bin/systemctl restart postgresql-9.6 \\

/usr/bin/systemctl reload postgresql-9.6

![70 2][]

配置本部分是为了 repmgr后续维护（节点提升 promote 等操作），如果不设置将会在做类似

repmgr -f /etc/repmgr/9.6/repmgr.conf  standby follow 命令时失败或报错

[https_repmgr.org]: https://repmgr.org/
[https_repmgr.org_docs_4.0_index.html]: https://repmgr.org/docs/4.0/index.html
[https_rpm.2ndquadrant.com_site_content]: https://rpm.2ndquadrant.com/site/content/
[https_repmgr.org_download_repmgr-4.0.5.tar.gz]: https://repmgr.org/download/repmgr-4.0.5.tar.gz
[yum.postgresql.org]: http://yum.postgresql.org/
[https_download.postgresql.org_pub_repos_yum_9.6_redhat_rhel-7-x86_64_pgdg-centos96-9.6-3.noarch.rpm]: https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/pgdg-centos96-9.6-3.noarch.rpm
[70]: /images/20220522/432be731835e4b61bd32a5843c394a4b.png
[70 1]: /images/20220522/0d52a491790344eca75b51234ee5007f.png
[70 2]: /images/20220522/ac42da1c96024c4f8d5b19abafc7467b.png