This blog is about a fast, script based, setup of a repmgr two node cluster with auto failover. This setup is very easy and the requirements comparing to a patroni setup very low, for exapmle as open port on the firewall we need only port 5432 which ist the default port of PostgreSQL.<\/p>\n\n\n\n
At first some requirements, in my case two VMs with fixed IPs:<\/p>\n\n\n
\n[root@el8-repmgr-1 ~]# cat \/etc\/hosts\n127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4\n192.168.198.131 el8-repmgr-1 el8-repmgr-1.localdomain\n192.168.198.132 el8-repmgr-2 el8-repmgr-2.localdomain\n[root@el8-repmgr-1 ~]#\n<\/pre><\/div>\n\n\nFor the whole installation and cofiguration process I have written some shell scripts, for PostgreSQL installation it is this one:<\/p>\n\n\n
\n###########################################################################################\n# Istalling PostgreSQL on AlmaLinux 8 \/ CentOS 8 \/ Oracle Linux 8 \/ RHEL 8 \/Rocky Linux 8 #\n# By Karsten Lenz dbi-services sa 2020.05.14 #\n###########################################################################################\n\n#!\/bin\/bash\n\necho "PostgreSQL Installation on AlmaLinux 8 \/ CentOS 8 \/ Oracle Linxu 8 \/ RHEL 8 \/ Rocky Linux 8"\necho ""\n\nfunction printHelp() {\n printf "Usage:\\n"\n printf "${progName} [OPTION]\\n\\n"\n printf "Options:\\n"\n printf "\\t -v <PostgreSQL Version>\\t\\tMajor Release of Postgresql (required)\\n"\n printf "\\t -t <PostgreSQL Node Type>\\t\\tIf the System is Primary \/ Single (p) or Secondary (s) in a Cluster (required)\\n"\n printf "\\t -h <Help>\\t\\t\\t\\tprints this help\\n"\n}\n\nwhile getopts v:t:h option 2>\/dev\/null\ndo\n case "${option}"\n in\n v) VERSION=${OPTARG};;\n t) TYPE=${OPTARG};;\n h) printHelp; exit 2;;\n *) printf "Unsupported option or parameter value missing '$*'\\n";\n printf "Run ${progName} -h to print help\\n"; exit 1;;\n esac\ndone\n\necho "Disabling PostgreSQL Packages provided by CentOS 8 or RedHat 8"\ndnf -y module disable postgresql\n\necho "Adding PostgreSQL Repository"\ndnf -y install https:\/\/download.postgresql.org\/pub\/repos\/yum\/reporpms\/EL-8-x86_64\/pgdg-redhat-repo-latest.noarch.rpm\n\necho "Installing PostgreSQL Packages including barman, repmgr and pg_stat_kcache"\n# adaptation needed in fact renamed packages in postgresql 14 for repmgr and pg_stat_kcache\nif [ $VERSION == '14' ]\nthen\n\tdnf -y install postgresql$VERSION postgresql$VERSION-libs postgresql$VERSION-server postgresql$VERSION-contrib pg_stat_kcache_$VERSION repmgr_$VERSION barman\nelif [ $VERSION != '14' ]\nthen\n\tdnf -y install postgresql$VERSION postgresql$VERSION-libs postgresql$VERSION-server postgresql$VERSION-contrib pg_stat_kcache$VERSION repmgr$VERSION barman\nfi\n\necho "Creating override.conf"\n# creating empty override.conf for postgresql service\nmkdir \/etc\/systemd\/system\/postgresql-$VERSION.service.d\n\n# define vriable for tee\nOVERRIDE_CONF=\/etc\/systemd\/system\/postgresql-$VERSION.service.d\/override.conf\ntouch $OVERRIDE_CONF\n\n# adding values to override.conf\necho "[Service]" | tee -a $OVERRIDE_CONF\necho "Environment=PGDATA=\/pgdata\/$VERSION\/data" | tee -a $OVERRIDE_CONF\n\n\nif [ $TYPE == 'p' ]\nthen\n echo "Initialyze PostgreSQL $VERSION"\n \/usr\/pgsql-$VERSION\/bin\/postgresql-$VERSION-setup initdb\n\n echo "Enable PostgreSQL Service"\n systemctl enable postgresql-$VERSION.service\n\n echo "Start PostgreSQL $VERSION"\n systemctl start postgresql-$VERSION.service\n\nelif [ $TYPE == 's' ]\nthen\n echo "Initialyze PostgreSQL $VERSION"\n \/usr\/pgsql-$VERSION\/bin\/postgresql-$VERSION-setup initdb\n\n echo "Enable PostgreSQL Service"\n systemctl enable postgresql-$VERSION.service\nfi\n\n# add user to sudoers\nusermod -aG wheel postgres\n\n# set rights on \/pgdata and \/etc\/repmgr\nchown -R postgres:postgres \/pgdata\nchown -R postgres:postgres \/etc\/repmgr\n\n# open firewall port 5432 for Potsgresql\nfirewall-cmd --zone=public --permanent --add-port 5432\/tcp\nfirewall-cmd --reload\n\n<\/pre><\/div>\n\n\nThe scripts have a help function -h, so they say how to use it:<\/p>\n\n\n
\n[root@el8-repmgr-1 install]# sh pg_install.sh -h\nPostgreSQL Installation on AlmaLinux 8 \/ CentOS 8 \/ Oracle Linxu 8 \/ RHEL 8 \/ Rocky Linux 8\n\nUsage:\n [OPTION]\n\nOptions:\n -v <PostgreSQL Version> Major Release of Postgresql (required)\n -t <PostgreSQL Node Type> If the System is Primary \/ Single (p) or Secondary (s) in a Cluster (required)\n -h <Help> prints this help\n[root@el8-repmgr-1 install]#\n<\/pre><\/div>\n\n\nSo we wil first start wht the primary or leader node:<\/p>\n\n\n
\n[root@el8-repmgr-1 install]# sh pg_setup.sh -v 14 -t p\nPostgreSQL Installation on AlmaLinux 8 \/ CentOS 8 \/ Oracle Linxu 8 \/ RHEL 8 \/ Rocky Linux 8\n\nDisabling PostgreSQL Packages provided by CentOS 8 or RedHat 8\nLast metadata expiration check: 6:31:10 ago on Thu 22 Dec 2022 08:48:47 AM CET.\nDependencies resolved.\n==========================================================================================================================================================================================================================================================================================\n Package Architecture Version Repository Size\n==========================================================================================================================================================================================================================================================================================\nDisabling modules:\n postgresql\n\nTransaction Summary\n==========================================================================================================================================================================================================================================================================================\n\nComplete!\nAdding PostgreSQL Repository\nLast metadata expiration check: 6:31:10 ago on Thu 22 Dec 2022 08:48:47 AM CET.\npgdg-redhat-repo-latest.noarch.rpm 82 kB\/s | 13 kB 00:00\nDependencies resolved.\n==========================================================================================================================================================================================================================================================================================\n Package Architecture Version Repository Size\n==========================================================================================================================================================================================================================================================================================\nInstalling:\n pgdg-redhat-repo noarch 42.0-28 @commandline 13 k\n\nTransaction Summary\n==========================================================================================================================================================================================================================================================================================\nInstall 1 Package\n\nTotal size: 13 k\nInstalled size: 14 k\nDownloading Packages:\nRunning transaction check\nTransaction check succeeded.\nRunning transaction test\nTransaction test succeeded.\nRunning transaction\n Preparing : 1\/1\n Installing : pgdg-redhat-repo-42.0-28.noarch 1\/1\n Verifying : pgdg-redhat-repo-42.0-28.noarch 1\/1\n\nInstalled:\n pgdg-redhat-repo-42.0-28.noarch\n\nComplete!\nInstalling PostgreSQL Packages including barman, repmgr and pg_stat_kcache\nPostgreSQL common RPMs for RHEL \/ Rocky 8 - x86_64 596 B\/s | 195 B 00:00\nPostgreSQL common RPMs for RHEL \/ Rocky 8 - x86_64 1.6 MB\/s | 1.7 kB 00:00\nImporting GPG key 0x442DF0F8:\n Userid : "PostgreSQL RPM Building Project <pgsql-pkg-yum@postgresql.org>"\n Fingerprint: 68C9 E2B9 1A37 D136 FE74 D176 1F16 D2E1 442D F0F8\n From : \/etc\/pki\/rpm-gpg\/RPM-GPG-KEY-PGDG\nPostgreSQL common RPMs for RHEL \/ Rocky 8 - x86_64 1.0 MB\/s | 702 kB 00:00\nPostgreSQL 15 for RHEL \/ Rocky 8 - x86_64 647 B\/s | 195 B 00:00\nPostgreSQL 15 for RHEL \/ Rocky 8 - x86_64 1.6 MB\/s | 1.7 kB 00:00\nImporting GPG key 0x442DF0F8:\n Userid : "PostgreSQL RPM Building Project <pgsql-pkg-yum@postgresql.org>"\n Fingerprint: 68C9 E2B9 1A37 D136 FE74 D176 1F16 D2E1 442D F0F8\n From : \/etc\/pki\/rpm-gpg\/RPM-GPG-KEY-PGDG\nPostgreSQL 15 for RHEL \/ Rocky 8 - x86_64 280 kB\/s | 161 kB 00:00\nPostgreSQL 14 for RHEL \/ Rocky 8 - x86_64 546 B\/s | 195 B 00:00\nPostgreSQL 14 for RHEL \/ Rocky 8 - x86_64 1.6 MB\/s | 1.7 kB 00:00\nImporting GPG key 0x442DF0F8:\n Userid : "PostgreSQL RPM Building Project <pgsql-pkg-yum@postgresql.org>"\n Fingerprint: 68C9 E2B9 1A37 D136 FE74 D176 1F16 D2E1 442D F0F8\n From : \/etc\/pki\/rpm-gpg\/RPM-GPG-KEY-PGDG\nPostgreSQL 14 for RHEL \/ Rocky 8 - x86_64 721 kB\/s | 459 kB 00:00\nPostgreSQL 13 for RHEL \/ Rocky 8 - x86_64 607 B\/s | 195 B 00:00\nPostgreSQL 13 for RHEL \/ Rocky 8 - x86_64 1.6 MB\/s | 1.7 kB 00:00\nImporting GPG key 0x442DF0F8:\n Userid : "PostgreSQL RPM Building Project <pgsql-pkg-yum@postgresql.org>"\n Fingerprint: 68C9 E2B9 1A37 D136 FE74 D176 1F16 D2E1 442D F0F8\n From : \/etc\/pki\/rpm-gpg\/RPM-GPG-KEY-PGDG\nPostgreSQL 13 for RHEL \/ Rocky 8 - x86_64 1.2 MB\/s | 752 kB 00:00\nPostgreSQL 12 for RHEL \/ Rocky 8 - x86_64 600 B\/s | 195 B 00:00\nPostgreSQL 12 for RHEL \/ Rocky 8 - x86_64 1.6 MB\/s | 1.7 kB 00:00\nImporting GPG key 0x442DF0F8:\n Userid : "PostgreSQL RPM Building Project <pgsql-pkg-yum@postgresql.org>"\n Fingerprint: 68C9 E2B9 1A37 D136 FE74 D176 1F16 D2E1 442D F0F8\n From : \/etc\/pki\/rpm-gpg\/RPM-GPG-KEY-PGDG\nPostgreSQL 12 for RHEL \/ Rocky 8 - x86_64 1.1 MB\/s | 899 kB 00:00\nPostgreSQL 11 for RHEL \/ Rocky 8 - x86_64 616 B\/s | 195 B 00:00\nPostgreSQL 11 for RHEL \/ Rocky 8 - x86_64 1.6 MB\/s | 1.7 kB 00:00\nImporting GPG key 0x442DF0F8:\n Userid : "PostgreSQL RPM Building Project <pgsql-pkg-yum@postgresql.org>"\n Fingerprint: 68C9 E2B9 1A37 D136 FE74 D176 1F16 D2E1 442D F0F8\n From : \/etc\/pki\/rpm-gpg\/RPM-GPG-KEY-PGDG\nPostgreSQL 11 for RHEL \/ Rocky 8 - x86_64 1.6 MB\/s | 1.1 MB 00:00\nPostgreSQL 10 for RHEL \/ Rocky 8 - x86_64 644 B\/s | 195 B 00:00\nPostgreSQL 10 for RHEL \/ Rocky 8 - x86_64 1.6 MB\/s | 1.7 kB 00:00\nImporting GPG key 0x442DF0F8:\n Userid : "PostgreSQL RPM Building Project <pgsql-pkg-yum@postgresql.org>"\n Fingerprint: 68C9 E2B9 1A37 D136 FE74 D176 1F16 D2E1 442D F0F8\n From : \/etc\/pki\/rpm-gpg\/RPM-GPG-KEY-PGDG\nPostgreSQL 10 for RHEL \/ Rocky 8 - x86_64 1.0 MB\/s | 700 kB 00:00\nDependencies resolved.\n==========================================================================================================================================================================================================================================================================================\n Package Architecture Version Repository Size\n==========================================================================================================================================================================================================================================================================================\nInstalling:\n barman noarch 3.3.0-1.rhel8 pgdg-common 48 k\n pg_stat_kcache_14 x86_64 2.2.1-2.rhel8 pgdg14 47 k\n postgresql14 x86_64 14.6-1PGDG.rhel8 pgdg14 1.5 M\n postgresql14-contrib x86_64 14.6-1PGDG.rhel8 pgdg14 726 k\n postgresql14-libs x86_64 14.6-1PGDG.rhel8 pgdg14 278 k\n postgresql14-server x86_64 14.6-1PGDG.rhel8 pgdg14 5.7 M\n repmgr_14 x86_64 5.3.3-1.rhel8 pgdg14 284 k\nInstalling dependencies:\n libicu x86_64 60.3-2.el8_1 baseos 8.8 M\n lz4 x86_64 1.8.3-3.el8_4 baseos 102 k\n perl-Carp noarch 1.42-396.el8 baseos 30 k\n perl-Data-Dumper x86_64 2.167-399.el8 baseos 58 k\n perl-Digest noarch 1.17-395.el8 appstream 27 k\n perl-Digest-MD5 x86_64 2.55-396.el8 appstream 37 k\n perl-Encode x86_64 4:2.97-3.el8 baseos 1.5 M\n perl-Errno x86_64 1.28-421.el8 baseos 75 k\n perl-Exporter noarch 5.72-396.el8 baseos 34 k\n perl-File-Path noarch 2.15-2.el8 baseos 38 k\n perl-File-Temp noarch 0.230.600-1.el8 baseos 62 k\n perl-Getopt-Long noarch 1:2.50-4.el8 baseos 63 k\n perl-HTTP-Tiny noarch 0.074-1.el8 baseos 58 k\n perl-IO x86_64 1.38-421.el8 baseos 141 k\n perl-MIME-Base64 x86_64 3.15-396.el8 baseos 30 k\n perl-Net-SSLeay x86_64 1.88-2.module_el8.6.0+2811+fe6c84b0 appstream 378 k\n perl-PathTools x86_64 3.74-1.el8 baseos 90 k\n perl-Pod-Escapes noarch 1:1.07-395.el8 baseos 20 k\n perl-Pod-Perldoc noarch 3.28-396.el8 baseos 86 k\n perl-Pod-Simple noarch 1:3.35-395.el8 baseos 213 k\n perl-Pod-Usage noarch 4:1.69-395.el8 baseos 34 k\n perl-Scalar-List-Utils x86_64 3:1.49-2.el8 baseos 68 k\n perl-Socket x86_64 4:2.027-3.el8 baseos 59 k\n perl-Storable x86_64 1:3.11-3.el8 baseos 98 k\n perl-Term-ANSIColor noarch 4.06-396.el8 baseos 46 k\n perl-Term-Cap noarch 1.17-395.el8 baseos 23 k\n perl-Text-ParseWords noarch 3.30-395.el8 baseos 18 k\n perl-Text-Tabs+Wrap noarch 2013.0523-395.el8 baseos 24 k\n perl-Time-Local noarch 1:1.280-1.el8 baseos 33 k\n perl-URI noarch 1.73-3.el8 appstream 116 k\n perl-Unicode-Normalize x86_64 1.25-396.el8 baseos 82 k\n perl-constant noarch 1.33-396.el8 baseos 25 k\n perl-interpreter x86_64 4:5.26.3-421.el8 baseos 6.3 M\n perl-libnet noarch 3.11-3.el8 appstream 121 k\n perl-libs x86_64 4:5.26.3-421.el8 baseos 1.6 M\n perl-macros x86_64 4:5.26.3-421.el8 baseos 71 k\n perl-parent noarch 1:0.237-1.el8 baseos 20 k\n perl-podlators noarch 4.11-1.el8 baseos 118 k\n perl-threads x86_64 1:2.21-2.el8 baseos 61 k\n perl-threads-shared x86_64 1.58-2.el8 baseos 47 k\n python3-argcomplete noarch 1.9.3-6.el8 appstream 60 k\n python3-barman noarch 3.3.0-1.rhel8 pgdg-common 455 k\n python3-pip noarch 9.0.3-22.el8 appstream 19 k\n python3-psycopg2 x86_64 2.8.6-1.rhel8 pgdg-common 178 k\n python3-setuptools noarch 39.2.0-6.el8 baseos 162 k\n python36 x86_64 3.6.8-38.module_el8.5.0+2569+5c5719bc appstream 18 k\n rsync x86_64 3.1.3-19.el8 baseos 409 k\nInstalling weak dependencies:\n perl-IO-Socket-IP noarch 0.39-5.el8 appstream 47 k\n perl-IO-Socket-SSL noarch 2.066-4.module_el8.6.0+2811+fe6c84b0 appstream 297 k\n perl-Mozilla-CA noarch 20160104-7.module_el8.5.0+2812+ed912d05 appstream 14 k\nEnabling module streams:\n perl 5.26\n perl-IO-Socket-SSL 2.066\n perl-libwww-perl 6.34\n python36 3.6\n\nTransaction Summary\n==========================================================================================================================================================================================================================================================================================\nInstall 57 Packages\n\nTotal download size: 31 M\nInstalled size: 107 M\nDownloading Packages:\n(1\/57): perl-Carp-1.42-396.el8.noarch.rpm 291 kB\/s | 30 kB 00:00\n(2\/57): lz4-1.8.3-3.el8_4.x86_64.rpm 682 kB\/s | 102 kB 00:00\n(3\/57): perl-Data-Dumper-2.167-399.el8.x86_64.rpm 1.2 MB\/s | 58 kB 00:00\n(4\/57): perl-Errno-1.28-421.el8.x86_64.rpm 1.5 MB\/s | 75 kB 00:00\n(5\/57): perl-Exporter-5.72-396.el8.noarch.rpm 1.1 MB\/s | 34 kB 00:00\n(6\/57): perl-File-Path-2.15-2.el8.noarch.rpm 1.3 MB\/s | 38 kB 00:00\n(7\/57): perl-Encode-2.97-3.el8.x86_64.rpm 11 MB\/s | 1.5 MB 00:00\n(8\/57): perl-File-Temp-0.230.600-1.el8.noarch.rpm 2.0 MB\/s | 62 kB 00:00\n(9\/57): perl-HTTP-Tiny-0.074-1.el8.noarch.rpm 1.5 MB\/s | 58 kB 00:00\n(10\/57): perl-Getopt-Long-2.50-4.el8.noarch.rpm 1.5 MB\/s | 63 kB 00:00\n(11\/57): perl-IO-1.38-421.el8.x86_64.rpm 3.8 MB\/s | 141 kB 00:00\n(12\/57): perl-MIME-Base64-3.15-396.el8.x86_64.rpm 783 kB\/s | 30 kB 00:00\n(13\/57): perl-Pod-Escapes-1.07-395.el8.noarch.rpm 658 kB\/s | 20 kB 00:00\n(14\/57): perl-PathTools-3.74-1.el8.x86_64.rpm 2.4 MB\/s | 90 kB 00:00\n(15\/57): perl-Pod-Perldoc-3.28-396.el8.noarch.rpm 2.8 MB\/s | 86 kB 00:00\n(16\/57): perl-Pod-Simple-3.35-395.el8.noarch.rpm 5.1 MB\/s | 213 kB 00:00\n(17\/57): libicu-60.3-2.el8_1.x86_64.rpm 19 MB\/s | 8.8 MB 00:00\n(18\/57): perl-Pod-Usage-1.69-395.el8.noarch.rpm 912 kB\/s | 34 kB 00:00\n(19\/57): perl-Scalar-List-Utils-1.49-2.el8.x86_64.rpm 2.5 MB\/s | 68 kB 00:00\n(20\/57): perl-Term-ANSIColor-4.06-396.el8.noarch.rpm 1.9 MB\/s | 46 kB 00:00\n(21\/57): perl-Storable-3.11-3.el8.x86_64.rpm 3.2 MB\/s | 98 kB 00:00\n(22\/57): perl-Socket-2.027-3.el8.x86_64.rpm 1.6 MB\/s | 59 kB 00:00\n(23\/57): perl-Term-Cap-1.17-395.el8.noarch.rpm 756 kB\/s | 23 kB 00:00\n(24\/57): perl-Text-ParseWords-3.30-395.el8.noarch.rpm 547 kB\/s | 18 kB 00:00\n(25\/57): perl-Text-Tabs+Wrap-2013.0523-395.el8.noarch.rpm 794 kB\/s | 24 kB 00:00\n(26\/57): perl-Time-Local-1.280-1.el8.noarch.rpm 1.3 MB\/s | 33 kB 00:00\n(27\/57): perl-Unicode-Normalize-1.25-396.el8.x86_64.rpm 2.6 MB\/s | 82 kB 00:00\n(28\/57): perl-constant-1.33-396.el8.noarch.rpm 820 kB\/s | 25 kB 00:00\n(29\/57): perl-macros-5.26.3-421.el8.x86_64.rpm 2.4 MB\/s | 71 kB 00:00\n(30\/57): perl-parent-0.237-1.el8.noarch.rpm 629 kB\/s | 20 kB 00:00\n(31\/57): perl-podlators-4.11-1.el8.noarch.rpm 3.3 MB\/s | 118 kB 00:00\n(32\/57): perl-threads-2.21-2.el8.x86_64.rpm 2.2 MB\/s | 61 kB 00:00\n(33\/57): perl-threads-shared-1.58-2.el8.x86_64.rpm 1.8 MB\/s | 47 kB 00:00\n(34\/57): python3-setuptools-39.2.0-6.el8.noarch.rpm 5.1 MB\/s | 162 kB 00:00\n(35\/57): rsync-3.1.3-19.el8.x86_64.rpm 11 MB\/s | 409 kB 00:00\n(36\/57): perl-Digest-1.17-395.el8.noarch.rpm 711 kB\/s | 27 kB 00:00\n(37\/57): perl-libs-5.26.3-421.el8.x86_64.rpm 5.9 MB\/s | 1.6 MB 00:00\n(38\/57): perl-interpreter-5.26.3-421.el8.x86_64.rpm 21 MB\/s | 6.3 MB 00:00\n(39\/57): perl-Digest-MD5-2.55-396.el8.x86_64.rpm 1.0 MB\/s | 37 kB 00:00\n(40\/57): perl-IO-Socket-IP-0.39-5.el8.noarch.rpm 1.4 MB\/s | 47 kB 00:00\n(41\/57): perl-IO-Socket-SSL-2.066-4.module_el8.6.0+2811+fe6c84b0.noarch.rpm 11 MB\/s | 297 kB 00:00\n(42\/57): perl-Mozilla-CA-20160104-7.module_el8.5.0+2812+ed912d05.noarch.rpm 516 kB\/s | 14 kB 00:00\n(43\/57): perl-libnet-3.11-3.el8.noarch.rpm 4.5 MB\/s | 121 kB 00:00\n(44\/57): perl-URI-1.73-3.el8.noarch.rpm 3.7 MB\/s | 116 kB 00:00\n(45\/57): perl-Net-SSLeay-1.88-2.module_el8.6.0+2811+fe6c84b0.x86_64.rpm 6.0 MB\/s | 378 kB 00:00\n(46\/57): python3-argcomplete-1.9.3-6.el8.noarch.rpm 2.0 MB\/s | 60 kB 00:00\n(47\/57): python3-pip-9.0.3-22.el8.noarch.rpm 578 kB\/s | 19 kB 00:00\n(48\/57): python36-3.6.8-38.module_el8.5.0+2569+5c5719bc.x86_64.rpm 673 kB\/s | 18 kB 00:00\n(49\/57): barman-3.3.0-1.rhel8.noarch.rpm 241 kB\/s | 48 kB 00:00\n(50\/57): pg_stat_kcache_14-2.2.1-2.rhel8.x86_64.rpm 1.7 MB\/s | 47 kB 00:00\n(51\/57): python3-psycopg2-2.8.6-1.rhel8.x86_64.rpm 679 kB\/s | 178 kB 00:00\n(52\/57): python3-barman-3.3.0-1.rhel8.noarch.rpm 1.4 MB\/s | 455 kB 00:00\n(53\/57): postgresql14-libs-14.6-1PGDG.rhel8.x86_64.rpm 3.0 MB\/s | 278 kB 00:00\n(54\/57): postgresql14-contrib-14.6-1PGDG.rhel8.x86_64.rpm 2.8 MB\/s | 726 kB 00:00\n(55\/57): repmgr_14-5.3.3-1.rhel8.x86_64.rpm 3.3 MB\/s | 284 kB 00:00\n(56\/57): postgresql14-14.6-1PGDG.rhel8.x86_64.rpm 3.0 MB\/s | 1.5 MB 00:00\n(57\/57): postgresql14-server-14.6-1PGDG.rhel8.x86_64.rpm 8.8 MB\/s | 5.7 MB 00:00\n------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------\nTotal 9.0 MB\/s | 31 MB 00:03\nPostgreSQL common RPMs for RHEL \/ Rocky 8 - x86_64 1.6 MB\/s | 1.7 kB 00:00\nImporting GPG key 0x442DF0F8:\n Userid : "PostgreSQL RPM Building Project <pgsql-pkg-yum@postgresql.org>"\n Fingerprint: 68C9 E2B9 1A37 D136 FE74 D176 1F16 D2E1 442D F0F8\n From : \/etc\/pki\/rpm-gpg\/RPM-GPG-KEY-PGDG\nKey imported successfully\nRunning transaction check\nTransaction check succeeded.\nRunning transaction test\nTransaction test succeeded.\nRunning transaction\n Preparing : 1\/1\n Installing : perl-Digest-1.17-395.el8.noarch 1\/57\n Installing : perl-Digest-MD5-2.55-396.el8.x86_64 2\/57\n Installing : perl-Data-Dumper-2.167-399.el8.x86_64 3\/57\n Installing : perl-libnet-3.11-3.el8.noarch 4\/57\n Installing : perl-Net-SSLeay-1.88-2.module_el8.6.0+2811+fe6c84b0.x86_64 5\/57\n Installing : perl-URI-1.73-3.el8.noarch 6\/57\n Installing : perl-Pod-Escapes-1:1.07-395.el8.noarch 7\/57\n Installing : perl-Time-Local-1:1.280-1.el8.noarch 8\/57\n Installing : perl-IO-Socket-IP-0.39-5.el8.noarch 9\/57\n Installing : perl-Mozilla-CA-20160104-7.module_el8.5.0+2812+ed912d05.noarch 10\/57\n Installing : perl-IO-Socket-SSL-2.066-4.module_el8.6.0+2811+fe6c84b0.noarch 11\/57\n Installing : perl-Term-ANSIColor-4.06-396.el8.noarch 12\/57\n Installing : perl-Term-Cap-1.17-395.el8.noarch 13\/57\n Installing : perl-File-Temp-0.230.600-1.el8.noarch 14\/57\n Installing : perl-Pod-Simple-1:3.35-395.el8.noarch 15\/57\n Installing : perl-HTTP-Tiny-0.074-1.el8.noarch 16\/57\n Installing : perl-podlators-4.11-1.el8.noarch 17\/57\n Installing : perl-Pod-Perldoc-3.28-396.el8.noarch 18\/57\n Installing : perl-Text-ParseWords-3.30-395.el8.noarch 19\/57\n Installing : perl-Pod-Usage-4:1.69-395.el8.noarch 20\/57\n Installing : perl-MIME-Base64-3.15-396.el8.x86_64 21\/57\n Installing : perl-Storable-1:3.11-3.el8.x86_64 22\/57\n Installing : perl-Getopt-Long-1:2.50-4.el8.noarch 23\/57\n Installing : perl-Errno-1.28-421.el8.x86_64 24\/57\n Installing : perl-Socket-4:2.027-3.el8.x86_64 25\/57\n Installing : perl-Encode-4:2.97-3.el8.x86_64 26\/57\n Installing : perl-Exporter-5.72-396.el8.noarch 27\/57\n Installing : perl-Scalar-List-Utils-3:1.49-2.el8.x86_64 28\/57\n Installing : perl-macros-4:5.26.3-421.el8.x86_64 29\/57\n Installing : perl-parent-1:0.237-1.el8.noarch 30\/57\n Installing : perl-Text-Tabs+Wrap-2013.0523-395.el8.noarch 31\/57\n Installing : perl-Unicode-Normalize-1.25-396.el8.x86_64 32\/57\n Installing : perl-File-Path-2.15-2.el8.noarch 33\/57\n Installing : perl-IO-1.38-421.el8.x86_64 34\/57\n Installing : perl-PathTools-3.74-1.el8.x86_64 35\/57\n Installing : perl-constant-1.33-396.el8.noarch 36\/57\n Installing : perl-threads-1:2.21-2.el8.x86_64 37\/57\n Installing : perl-threads-shared-1.58-2.el8.x86_64 38\/57\n Installing : perl-libs-4:5.26.3-421.el8.x86_64 39\/57\n Installing : perl-Carp-1.42-396.el8.noarch 40\/57\n Installing : perl-interpreter-4:5.26.3-421.el8.x86_64 41\/57\n Installing : postgresql14-libs-14.6-1PGDG.rhel8.x86_64 42\/57\n Running scriptlet: postgresql14-libs-14.6-1PGDG.rhel8.x86_64 42\/57\n Installing : python3-setuptools-39.2.0-6.el8.noarch 43\/57\n Installing : python3-pip-9.0.3-22.el8.noarch 44\/57\n Installing : python36-3.6.8-38.module_el8.5.0+2569+5c5719bc.x86_64 45\/57\n Running scriptlet: python36-3.6.8-38.module_el8.5.0+2569+5c5719bc.x86_64 45\/57\n Installing : libicu-60.3-2.el8_1.x86_64 46\/57\n Running scriptlet: libicu-60.3-2.el8_1.x86_64 46\/57\n Installing : python3-psycopg2-2.8.6-1.rhel8.x86_64 47\/57\n Installing : python3-argcomplete-1.9.3-6.el8.noarch 48\/57\n Installing : python3-barman-3.3.0-1.rhel8.noarch 49\/57\n Installing : rsync-3.1.3-19.el8.x86_64 50\/57\n Installing : lz4-1.8.3-3.el8_4.x86_64 51\/57\n Installing : postgresql14-14.6-1PGDG.rhel8.x86_64 52\/57\n Running scriptlet: postgresql14-14.6-1PGDG.rhel8.x86_64 52\/57\n Running scriptlet: postgresql14-server-14.6-1PGDG.rhel8.x86_64 53\/57\n Installing : postgresql14-server-14.6-1PGDG.rhel8.x86_64 53\/57\n Running scriptlet: postgresql14-server-14.6-1PGDG.rhel8.x86_64 53\/57\n Installing : pg_stat_kcache_14-2.2.1-2.rhel8.x86_64 54\/57\n Running scriptlet: pg_stat_kcache_14-2.2.1-2.rhel8.x86_64 54\/57\n Installing : postgresql14-contrib-14.6-1PGDG.rhel8.x86_64 55\/57\n Running scriptlet: repmgr_14-5.3.3-1.rhel8.x86_64 56\/57\n Installing : repmgr_14-5.3.3-1.rhel8.x86_64 56\/57\n Running scriptlet: repmgr_14-5.3.3-1.rhel8.x86_64 56\/57\n Running scriptlet: barman-3.3.0-1.rhel8.noarch 57\/57\n Installing : barman-3.3.0-1.rhel8.noarch 57\/57\n Running scriptlet: barman-3.3.0-1.rhel8.noarch 57\/57\n Verifying : libicu-60.3-2.el8_1.x86_64 1\/57\n Verifying : lz4-1.8.3-3.el8_4.x86_64 2\/57\n Verifying : perl-Carp-1.42-396.el8.noarch 3\/57\n Verifying : perl-Data-Dumper-2.167-399.el8.x86_64 4\/57\n Verifying : perl-Encode-4:2.97-3.el8.x86_64 5\/57\n Verifying : perl-Errno-1.28-421.el8.x86_64 6\/57\n Verifying : perl-Exporter-5.72-396.el8.noarch 7\/57\n Verifying : perl-File-Path-2.15-2.el8.noarch 8\/57\n Verifying : perl-File-Temp-0.230.600-1.el8.noarch 9\/57\n Verifying : perl-Getopt-Long-1:2.50-4.el8.noarch 10\/57\n Verifying : perl-HTTP-Tiny-0.074-1.el8.noarch 11\/57\n Verifying : perl-IO-1.38-421.el8.x86_64 12\/57\n Verifying : perl-MIME-Base64-3.15-396.el8.x86_64 13\/57\n Verifying : perl-PathTools-3.74-1.el8.x86_64 14\/57\n Verifying : perl-Pod-Escapes-1:1.07-395.el8.noarch 15\/57\n Verifying : perl-Pod-Perldoc-3.28-396.el8.noarch 16\/57\n Verifying : perl-Pod-Simple-1:3.35-395.el8.noarch 17\/57\n Verifying : perl-Pod-Usage-4:1.69-395.el8.noarch 18\/57\n Verifying : perl-Scalar-List-Utils-3:1.49-2.el8.x86_64 19\/57\n Verifying : perl-Socket-4:2.027-3.el8.x86_64 20\/57\n Verifying : perl-Storable-1:3.11-3.el8.x86_64 21\/57\n Verifying : perl-Term-ANSIColor-4.06-396.el8.noarch 22\/57\n Verifying : perl-Term-Cap-1.17-395.el8.noarch 23\/57\n Verifying : perl-Text-ParseWords-3.30-395.el8.noarch 24\/57\n Verifying : perl-Text-Tabs+Wrap-2013.0523-395.el8.noarch 25\/57\n Verifying : perl-Time-Local-1:1.280-1.el8.noarch 26\/57\n Verifying : perl-Unicode-Normalize-1.25-396.el8.x86_64 27\/57\n Verifying : perl-constant-1.33-396.el8.noarch 28\/57\n Verifying : perl-interpreter-4:5.26.3-421.el8.x86_64 29\/57\n Verifying : perl-libs-4:5.26.3-421.el8.x86_64 30\/57\n Verifying : perl-macros-4:5.26.3-421.el8.x86_64 31\/57\n Verifying : perl-parent-1:0.237-1.el8.noarch 32\/57\n Verifying : perl-podlators-4.11-1.el8.noarch 33\/57\n Verifying : perl-threads-1:2.21-2.el8.x86_64 34\/57\n Verifying : perl-threads-shared-1.58-2.el8.x86_64 35\/57\n Verifying : python3-setuptools-39.2.0-6.el8.noarch 36\/57\n Verifying : rsync-3.1.3-19.el8.x86_64 37\/57\n Verifying : perl-Digest-1.17-395.el8.noarch 38\/57\n Verifying : perl-Digest-MD5-2.55-396.el8.x86_64 39\/57\n Verifying : perl-IO-Socket-IP-0.39-5.el8.noarch 40\/57\n Verifying : perl-IO-Socket-SSL-2.066-4.module_el8.6.0+2811+fe6c84b0.noarch 41\/57\n Verifying : perl-Mozilla-CA-20160104-7.module_el8.5.0+2812+ed912d05.noarch 42\/57\n Verifying : perl-Net-SSLeay-1.88-2.module_el8.6.0+2811+fe6c84b0.x86_64 43\/57\n Verifying : perl-URI-1.73-3.el8.noarch 44\/57\n Verifying : perl-libnet-3.11-3.el8.noarch 45\/57\n Verifying : python3-argcomplete-1.9.3-6.el8.noarch 46\/57\n Verifying : python3-pip-9.0.3-22.el8.noarch 47\/57\n Verifying : python36-3.6.8-38.module_el8.5.0+2569+5c5719bc.x86_64 48\/57\n Verifying : barman-3.3.0-1.rhel8.noarch 49\/57\n Verifying : python3-barman-3.3.0-1.rhel8.noarch 50\/57\n Verifying : python3-psycopg2-2.8.6-1.rhel8.x86_64 51\/57\n Verifying : pg_stat_kcache_14-2.2.1-2.rhel8.x86_64 52\/57\n Verifying : postgresql14-14.6-1PGDG.rhel8.x86_64 53\/57\n Verifying : postgresql14-contrib-14.6-1PGDG.rhel8.x86_64 54\/57\n Verifying : postgresql14-libs-14.6-1PGDG.rhel8.x86_64 55\/57\n Verifying : postgresql14-server-14.6-1PGDG.rhel8.x86_64 56\/57\n Verifying : repmgr_14-5.3.3-1.rhel8.x86_64 57\/57\n\nInstalled:\n barman-3.3.0-1.rhel8.noarch libicu-60.3-2.el8_1.x86_64 lz4-1.8.3-3.el8_4.x86_64 perl-Carp-1.42-396.el8.noarch perl-Data-Dumper-2.167-399.el8.x86_64\n perl-Digest-1.17-395.el8.noarch perl-Digest-MD5-2.55-396.el8.x86_64 perl-Encode-4:2.97-3.el8.x86_64 perl-Errno-1.28-421.el8.x86_64 perl-Exporter-5.72-396.el8.noarch\n perl-File-Path-2.15-2.el8.noarch perl-File-Temp-0.230.600-1.el8.noarch perl-Getopt-Long-1:2.50-4.el8.noarch perl-HTTP-Tiny-0.074-1.el8.noarch perl-IO-1.38-421.el8.x86_64\n perl-IO-Socket-IP-0.39-5.el8.noarch perl-IO-Socket-SSL-2.066-4.module_el8.6.0+2811+fe6c84b0.noarch perl-MIME-Base64-3.15-396.el8.x86_64 perl-Mozilla-CA-20160104-7.module_el8.5.0+2812+ed912d05.noarch perl-Net-SSLeay-1.88-2.module_el8.6.0+2811+fe6c84b0.x86_64\n perl-PathTools-3.74-1.el8.x86_64 perl-Pod-Escapes-1:1.07-395.el8.noarch perl-Pod-Perldoc-3.28-396.el8.noarch perl-Pod-Simple-1:3.35-395.el8.noarch perl-Pod-Usage-4:1.69-395.el8.noarch\n perl-Scalar-List-Utils-3:1.49-2.el8.x86_64 perl-Socket-4:2.027-3.el8.x86_64 perl-Storable-1:3.11-3.el8.x86_64 perl-Term-ANSIColor-4.06-396.el8.noarch perl-Term-Cap-1.17-395.el8.noarch\n perl-Text-ParseWords-3.30-395.el8.noarch perl-Text-Tabs+Wrap-2013.0523-395.el8.noarch perl-Time-Local-1:1.280-1.el8.noarch perl-URI-1.73-3.el8.noarch perl-Unicode-Normalize-1.25-396.el8.x86_64\n perl-constant-1.33-396.el8.noarch perl-interpreter-4:5.26.3-421.el8.x86_64 perl-libnet-3.11-3.el8.noarch perl-libs-4:5.26.3-421.el8.x86_64 perl-macros-4:5.26.3-421.el8.x86_64\n perl-parent-1:0.237-1.el8.noarch perl-podlators-4.11-1.el8.noarch perl-threads-1:2.21-2.el8.x86_64 perl-threads-shared-1.58-2.el8.x86_64 pg_stat_kcache_14-2.2.1-2.rhel8.x86_64\n postgresql14-14.6-1PGDG.rhel8.x86_64 postgresql14-contrib-14.6-1PGDG.rhel8.x86_64 postgresql14-libs-14.6-1PGDG.rhel8.x86_64 postgresql14-server-14.6-1PGDG.rhel8.x86_64 python3-argcomplete-1.9.3-6.el8.noarch\n python3-barman-3.3.0-1.rhel8.noarch python3-pip-9.0.3-22.el8.noarch python3-psycopg2-2.8.6-1.rhel8.x86_64 python3-setuptools-39.2.0-6.el8.noarch python36-3.6.8-38.module_el8.5.0+2569+5c5719bc.x86_64\n repmgr_14-5.3.3-1.rhel8.x86_64 rsync-3.1.3-19.el8.x86_64\n\nComplete!\nCreating override.conf\n[Service]\nEnvironment=PGDATA=\/pgdata\/14\/data\nInitialyze PostgreSQL 14\nInitializing database ... OK\n\nEnable PostgreSQL Service\nCreated symlink \/etc\/systemd\/system\/multi-user.target.wants\/postgresql-14.service \u2192 \/usr\/lib\/systemd\/system\/postgresql-14.service.\nStart PostgreSQL 14\nsuccess\nsuccess\n[root@el8-repmgr-1 install]#\n<\/pre><\/div>\n\n\nOn the master \/ leader node ist PostgreSQL now running, s we can configure PostgreSQL accoring to given CPU and Memory ressources by the config.sh script, all following scripts need to be uses as postgres user created by the package installation, so we need to change owner on the other scripts.<\/p>\n\n\n
\n[root@el8-repmgr-1 pgsql]# pwd\n\/opt\/pgsql\n[root@el8-repmgr-1 pgsql]# ls -la\ntotal 0\ndrwxr-xr-x. 4 root root 35 Dec 22 14:36 .\ndrwxr-xr-x. 3 root root 19 Dec 22 14:36 ..\ndrwxr-xr-x. 2 root root 154 Dec 22 14:38 config\ndrwxr-xr-x. 2 root root 52 Dec 22 15:15 install\n[root@el8-repmgr-1 pgsql]# chown -R postgres:postgres config\/\n[root@el8-repmgr-1 pgsql]#\n<\/pre><\/div>\n\n\nThe configuration script:<\/p>\n\n\n
\n[postgres@el8-repmgr-1 config]$ cat config.sh\n##############################################\n# PostgreSQL configuration #\n# by Karsten Lenz dbi services sa 04.29.2022 #\n##############################################\n\n#!\/bin\/bash\n\necho "PostgreSQL Configuration"\necho ""\n\nfunction printHelp {\n printf "Usage:\\n"\n printf "${progName} [OPTION]\\n\\n"\n printf "Options:\\n"\n printf "\\t -c <Count of CPU used>\\t\\t\\tAmount of CPU used by this system (required)\\n"\n printf "\\t -m <Amount of Memory>\\t\\t\\tAmount of Memory of this system (required)\\n"\n printf "\\t -o <Max Connections>\\t\\t\\tAmount of Connections of this system (default = 100))\\n"\n printf "\\t -v <PostgreSQL Version>\\t\\tMajor Release of Postgresql (default = 14)\\n"\n printf "\\t -h <Help>\\t\\t\\t\\tprints this help\\n"\n}\n\nwhile getopts c:m:o:v:h option 2>\/dev\/null\ndo\n case "${option}"\n in\n c) CPU=${OPTARG};;\n m) RAM=${OPTARG};;\n o) CONNECTIONS=${OPTARG:=100};;\n v) VERSION=${OPTARG:=14};;\n h) printHelp; exit 2;;\n *) printf "Unsupported option or parameter value missing '$*'\\n";\n printf "Run ${printHelp} -h to print help\\n"; exit 1;;\n esac\ndone\n\n# create ssl certificate and ssl key\nopenssl req -new -newkey rsa:4096 -nodes -x509 -subj "\/C=CH\/ST=DBAAS\/L=ZUERICH\/O=Dis\/CN=www.dbi-services.com" -keyout \/pgdata\/ssl\/pgsql.key -out \/pgdata\/ssl\/pgsql.crt\n\n# define parameters\nrootdir=\/opt\/pgsql\/config\ncd ${rootdir}\n\n# connections\nmax_connections=($CONNECTIONS)\necho max_connections : $max_connections\n\n# memory\nlet shared_buffers=($RAM\/4)\necho shared_buffers : $shared_buffers\nlet effective_cache_size=($RAM-$shared_buffers)\necho effective_cache_size : $effective_cache_size\nlet work_mem=($RAM*256\/$CONNECTIONS)\necho work_mem : $work_mem\nlet maintenance_work_mem=($RAM*256\/8)\necho maintenance_work_mem : $maintenance_work_mem\n\n# cpu\nlet max_worker_processes=($CPU)\necho max_worker_processes : $max_worker_processes\nlet max_parallel_workers=($CPU)\necho max_parallel_workers : $max_parallel_workers\nlet max_parallel_workers_per_gather=($CPU\/2)\necho max_parallel_workers_per_gather : $max_parallel_workers_per_gather\nlet max_parallel_maintenance_workers=($CPU\/2)\necho max_parallel_maintenance_workers : $max_parallel_maintenance_workers\n\n# cpu and memory configuration\npsql -c "alter system set listen_addresses = '*';"\npsql -c "alter system set max_connections = '$max_connections';"\npsql -c "alter system set effective_cache_size = '$effective_cache_size GB';"\npsql -c "alter system set shared_buffers = '$shared_buffers GB';"\npsql -c "alter system set work_mem = '$work_mem MB';"\npsql -c "alter system set maintenance_work_mem = '$maintenance_work_mem MB';"\npsql -c "alter system set max_worker_processes = '$max_worker_processes';"\npsql -c "alter system set max_parallel_workers = '$max_parallel_workers';"\npsql -c "alter system set max_parallel_workers_per_gather = '$max_parallel_workers_per_gather';"\npsql -c "alter system set max_parallel_maintenance_workers = '$max_parallel_maintenance_workers';"\npsql -c "alter system set ssl_cert_file = '\/pgdata\/ssl\/pgsql.crt';"\npsql -c "alter system set ssl_key_file = '\/pgdata\/ssl\/pgsql.key';"\npsql -c "alter system set ssl = on;"\npsql -c "alter system set ssl_ciphers = 'HIGH';"\npsql -c "alter system set ssl_min_protocol_version = 'TLSv1.2';"\npsql -c "alter system set shared_preload_libraries = pg_stat_statements;"\nsudo service postgresql-$VERSION restart\nexit\n[postgres@el8-repmgr-1 config]$\n<\/pre><\/div>\n\n\nSo lets config the master \/ leader node, given are 4 vCPU and 8GB RAM. The script will restart the postgresql service, so it is needed that postgres user is wihtin sudoers.<\/p>\n\n\n\n
Adapt sudoers with visudo:<\/p>\n\n\n
\n## Allows people in group wheel to run all commands\n# %wheel ALL=(ALL) ALL\n\n## Same thing without a password\n%wheel ALL=(ALL) NOPASSWD: ALL\n<\/pre><\/div>\n\n\nAdd postgres user to sudoers:<\/p>\n\n\n
\n[root@el8-repmgr-1 pgsql]# usermod -aG wheel postgres\n[root@el8-repmgr-1 pgsql]#\n<\/pre><\/div>\n\n\nNow we can use the config script.<\/p>\n\n\n
\n[postgres@el8-repmgr-1 config]$ sh config.sh -h\nPostgreSQL Configuration\n\nUsage:\n [OPTION]\n\nOptions:\n -c <Count of CPU used> Amount of CPU used by this system (required)\n -m <Amount of Memory> Amount of Memory of this system (required)\n -o <Max Connections> Amount of Connections of this system (default = 100))\n -v <PostgreSQL Version> Major Release of Postgresql (default = 14)\n -h <Help> prints this help\n[postgres@el8-repmgr-1 config]$\n\n[postgres@el8-repmgr-1 config]$ sh config.sh -c 4 -m 8 -o 100 -v 14\nPostgreSQL Configuration\n\nGenerating a RSA private key\n....++++\n...........................................................................................................................................................++++\nwriting new private key to '\/pgdata\/ssl\/pgsql.key'\n-----\nmax_connections : 100\nshared_buffers : 2\neffective_cache_size : 6\nwork_mem : 20\nmaintenance_work_mem : 256\nmax_worker_processes : 4\nmax_parallel_workers : 4\nmax_parallel_workers_per_gather : 2\nmax_parallel_maintenance_workers : 2\nALTER SYSTEM\nALTER SYSTEM\nALTER SYSTEM\nALTER SYSTEM\nALTER SYSTEM\nALTER SYSTEM\nALTER SYSTEM\nALTER SYSTEM\nALTER SYSTEM\nALTER SYSTEM\nALTER SYSTEM\nALTER SYSTEM\nALTER SYSTEM\nALTER SYSTEM\nALTER SYSTEM\nALTER SYSTEM\nRedirecting to \/bin\/systemctl restart postgresql-14.service\n[postgres@el8-repmgr-1 config]$\n<\/pre><\/div>\n\n\nNow we can do the preperation for repmgr, at first the setup of .pgpass using a script.<\/p>\n\n\n
\n[postgres@el8-repmgr-1 config]$ cat pgpass.sh\n#!\/bin\/sh\n\n########################################\n# #\n# pgpass setup script #\n# #\n# Author: Karsten Lenz \/ 2020.05.28 #\n# #\n########################################\n\nprogName=$(basename $0)\n# postgresVersion=12\ndomain=localdomain\n# pgData=\/pgdata\/$postgresVersion\/data\n# postgresConf=\/pgdata\/$postgresVersion\/data\/postgresql.conf\npostgresHome=\/var\/lib\/pgsql\n# postgresBin=\/usr\/pgsql-$postgresVersion\/bin\npgpass=$postgresHome\/.pgpass\npassword=PutYourPasswordHere\n\nfunction printHelp() {\n printf "Usage:\\n"\n printf "${progName} [OPTION]\\n\\n"\n printf "Options:\\n"\n printf "\\t -p <Primary Server>\\t\\t\\tserver where the primary host is running on (required)\\n"\n printf "\\t -s <Secondary Server>\\t\\t\\tserver where the secondary host is running on (required)\\n"\n printf "\\t -h <Help>\\t\\t\\t\\tprints this help\\n"\n}\n\nwhile getopts p:s:h option 2>\/dev\/null\ndo\n case "${option}"\n in\n p) primServer=${OPTARG};;\n s) secdServer=${OPTARG};;\n h) printHelp; exit 2;;\n *) printf "Unsupported option or parameter value missing '$*'\\n";\n printf "Run ${progName} -h to print help\\n"; exit 1;;\n esac\ndone\n\n############ Log function ############\n\nlogFile=\/tmp\/pgpass_install.log\n\nfunction log() {\n echo "$(date +%Y.%m.%d-%H:%M:%S) [$$]$*" | tee -a $logFile\n}\n\nif [ -f $logFile ]; then\n continue\nelse\n touch $logFile\n chmod -R 774 $logFile\n sleep 2\nfi\n\n#clean .pgpass\nrm -f $pgpass\n\n#set values in .pgpass\nlog "INFO: #host:port:database:user:password in $pgpass"\necho "#host:port:database:user:password" | tee -a $pgpass\nlog "INFO: Setting localhost in $pgass"\necho "localhost:5432:*:repmgr:$password" | tee -a $pgpass\nlog "INFO: Setting 127.0.0.1 in $pgpass"\necho "127.0.0.1:5432:*:repmgr:$password" | tee -a $pgpass\nlog "INFO: Setting Primary $primServer in $pgpass"\necho "$primServer.$domain:5432:*:repmgr:$password" | tee -a $pgpass\nlog "INFO: Setting Primary $secdServer in $pgpass"\necho "$secdServer.$domain:5432:*:repmgr:$password" | tee -a $pgpass\n\n#set .pgpass 0600\nchmod 0600 $pgpass\n\n#export PGPASSFILE\nexport PGPASSFILE='\/var\/lib\/pgsql\/.pgpass'\n[postgres@el8-repmgr-1 config]$\n[postgres@el8-repmgr-1 config]$ sh pgpass.sh -h\nUsage:\npgpass.sh [OPTION]\n\nOptions:\n -p <Primary Server> server where the primary host is running on (required)\n -s <Secondary Server> server where the secondary host is running on (required)\n -h <Help> prints this help\n[postgres@el8-repmgr-1 config]$ sh pgpass.sh -p 192.168.198.131 -s 192.168.198.132\n2022.12.22-16:01:18 [6166]INFO: #host:port:database:user:password in \/var\/lib\/pgsql\/.pgpass\n#host:port:database:user:password\n2022.12.22-16:01:18 [6166]INFO: Setting localhost in\nlocalhost:5432:*:repmgr:PutYourPasswordHere\n2022.12.22-16:01:18 [6166]INFO: Setting 127.0.0.1 in \/var\/lib\/pgsql\/.pgpass\n127.0.0.1:5432:*:repmgr:PutYourPasswordHere\n2022.12.22-16:01:18 [6166]INFO: Setting Primary 192.168.198.131 in \/var\/lib\/pgsql\/.pgpass\n192.168.198.131.localdomain:5432:*:repmgr:PutYourPasswordHere\n2022.12.22-16:01:18 [6166]INFO: Setting Primary 192.168.198.132 in \/var\/lib\/pgsql\/.pgpass\n192.168.198.132.localdomain:5432:*:repmgr:PutYourPasswordHere\n[postgres@el8-repmgr-1 config]$\n<\/pre><\/div>\n\n\nTime for repmgr on the master \/ leader node using the setup script for the master \/ leader node:<\/p>\n\n\n
\n#!\/bin\/sh\n\n########################################\n# RepMgr setup script #\n# Rework: Karsten Lenz \/ 2022.08.11 #\n########################################\n\nprogName=$(basename $0)\n# postgresVersion=14\ndomain=localdomain\n# repmgr_conf=\/etc\/repmgr\/$postgresVersion\/repmgr.conf\n# pgData=\/pgdata\/$postgresVersion\/data\n# postgresConf=\/pgdata\/$postgresVersion\/data\/postgresql.conf\n# postgresHome=\/var\/lib\/pgsql\/$postgresVersion\n# postgresBin=\/usr\/pgsql-$postgresVersion\/bin\npassword=PutYourPasswordHere\n\nfunction printHelp() {\n printf "Usage:\\n"\n printf "${progName} [OPTION]\\n\\n"\n printf "Options:\\n"\n printf "\\t -p <Primary Server>\\t\\t\\thost where the primary server is running on (required)\\n"\n printf "\\t -s <Standby Server>\\t\\t\\thost where the standby server is running on (required)\\n"\n printf "\\t -v <PostgreSQL Major Release>\\t\\tMajor Release Number default 14 (required)\\n"\n printf "\\t -h <Help>\\t\\t\\t\\tprints this help\\n"\n}\n\nwhile getopts c:p:s:v:h option 2>\/dev\/null\ndo\n case "${option}"\n in\n p) primServer=${OPTARG};;\n s) secdServer=${OPTARG};;\n v) postgresVersion=${OPTARG:=14};;\n h) printHelp; exit 2;;\n *) printf "Unsupported option or parameter value missing '$*'\\n"; \n printf "Run ${progName} -h to print help\\n"; exit 1;;\n esac\ndone\n\n### Building Variables according to inputs ###\nrepmgr_conf=\/etc\/repmgr\/$postgresVersion\/repmgr.conf\npgData=\/pgdata\/$postgresVersion\/data\npostgresConf=\/pgdata\/$postgresVersion\/data\/postgresql.conf\npostgresHome=\/var\/lib\/pgsql\/$postgresVersion\npostgresBin=\/usr\/pgsql-$postgresVersion\/bin\n\nrootDir=\/opt\/pgsql\n\n############ Log function ############\n\nlogFile=\/tmp\/repMaster_install.log\n\nfunction log() {\n echo "$(date +%Y.%m.%d-%H:%M:%S) [$$]$*" | tee -a $logFile\n}\n\nif [ -f $logFile ]; then\n continue\nelse\n touch $logFile\n chmod -R 774 $logFile\n sleep 2\nfi\n\n############ MAIN ############\npsql -c "alter system set max_replication_slots = 10;"\npsql -c "alter system set archive_mode = 'on';"\npsql -c "alter system set archive_command = '\/bin\/true';"\npsql -c "alter system set wal_level = 'replica';"\npsql -c "alter system set max_wal_senders = 2;"\npsql -c "create user repmgr with superuser"\nlog "INFO: create user repmgr with superuser"\npsql -c "alter user repmgr with password '$password'"\nlog "INFO: alter user repmgr set password"\n\n$postgresBin\/createdb repmgrdb -O repmgr\nlog "INFO: Create database repmgrdb with owner repmgr"\n\n$postgresBin\/pg_ctl reload -D $pgData -W -s\nif [ $? == 0 ]; then\n log "INFO: Reloading postgres returned $?"\nelse\n log "ERROR: Reloading postgres returned $?"\n exit 8\nfi\n\n> $repmgr_conf\n#log "INFO: Setting cluster=$repCluster in $repmgr_conf"\n#echo "cluster=$repCluster" | tee -a $repmgr_conf\nlog "INFO: Setting node_id=1 in $repmgr_conf"\necho "node_id=1" | tee -a $repmgr_conf\nlog "INFO: Setting node_name=$primServer in $repmgr_conf"\necho "node_name=$primServer" | tee -a $repmgr_conf\nlog "INFO: Setting conninfo='host=$primServer.$domain user=repmgr dbname=repmgrdb' in $repmgr_conf"\necho "conninfo='host=$primServer.$domain user=repmgr dbname=repmgrdb'" | tee -a $repmgr_conf\nlog "INFO: Setting use_replication_slots=true"\necho "use_replication_slots=true" | tee -a $repmgr_conf\nlog "INFO: Setting data_directory='$pgData' in $repmgr_conf"\necho "data_directory='$pgData'" | tee -a $repmgr_conf\n\n#\/usr\/psql-14\/bin repmgrdb repmgr <<EOF\n\npsql -c "ALTER USER repmgr SET search_path TO repmgr, public;"\nlog "INFO: ALTER USER repmgr SET search_path TO repmgr, public;"\n\n$postgresBin\/repmgr -f $repmgr_conf -F master register\nif [ $? == 0 ]; then\n log "INFO: Registering master returned $?"\nelse\n log "ERROR: Registering master returned $?"\n exit 8\nfi\n<\/pre><\/div>\n\n\n[postgres@el8-repmgr-1 config]$ sh repMgrMasterNEW_setup.sh -p el8-repmgr-1 -s el8-repmgr-2 -v 14\nALTER SYSTEM\nALTER SYSTEM\nALTER SYSTEM\nALTER SYSTEM\nALTER SYSTEM\nERROR: role "repmgr" already exists\n2022.12.22-16:19:58 [7333]INFO: create user repmgr with superuser\nALTER ROLE\n2022.12.22-16:19:58 [7333]INFO: alter user repmgr set password\n2022.12.22-16:19:58 [7333]INFO: Create database repmgrdb with owner repmgr\n2022.12.22-16:19:58 [7333]INFO: Reloading postgres returned 0\n2022.12.22-16:19:58 [7333]INFO: Setting node_id=1 in \/etc\/repmgr\/14\/repmgr.conf\nnode_id=1\n2022.12.22-16:19:58 [7333]INFO: Setting node_name=el8-repmgr-1 in \/etc\/repmgr\/14\/repmgr.conf\nnode_name=el8-repmgr-1\n2022.12.22-16:19:58 [7333]INFO: Setting conninfo='host=el8-repmgr-1.localdomain user=repmgr dbname=repmgrdb' in \/etc\/repmgr\/14\/repmgr.conf\nconninfo='host=el8-repmgr-1.localdomain user=repmgr dbname=repmgrdb'\n2022.12.22-16:19:58 [7333]INFO: Setting use_replication_slots=true\nuse_replication_slots=true\n2022.12.22-16:19:58 [7333]INFO: Setting data_directory='\/pgdata\/14\/data' in \/etc\/repmgr\/14\/repmgr.conf\ndata_directory='\/pgdata\/14\/data'\nALTER ROLE\n2022.12.22-16:19:58 [7333]INFO: ALTER USER repmgr SET search_path TO repmgr, public;\nINFO: connecting to primary database...\nNOTICE: attempting to install extension "repmgr"\nNOTICE: "repmgr" extension successfully installed\nNOTICE: primary node record (ID: 1) registered\n2022.12.22-16:19:58 [7333]INFO: Registering master returned 0\n[postgres@el8-repmgr-1 config]$\n[postgres@el8-repmgr-1 config]$ \/usr\/pgsql-14\/bin\/repmgr cluster show\n ID | Name | Role | Status | Upstream | Location | Priority | Timeline | Connection string\n----+--------------+---------+-----------+----------+----------+----------+----------+-----------------------------------------------------------\n 1 | el8-repmgr-1 | primary | * running | | default | 100 | 1 | host=el8-repmgr-1.localdomain user=repmgr dbname=repmgrdb\n[postgres@el8-repmgr-1 config]$\n<\/pre><\/div>\n\n\nLeader \/ Master is running now, lets install the Replica.<\/p>\n\n\n
\n[root@el8-repmgr-2 install]# sh pg_setup.sh -h\nPostgreSQL Installation on AlmaLinux 8 \/ CentOS 8 \/ Oracle Linxu 8 \/ RHEL 8 \/ Rocky Linux 8\n\nUsage:\n [OPTION]\n\nOptions:\n -v <PostgreSQL Version> Major Release of Postgresql (required)\n -t <PostgreSQL Node Type> If the System is Primary \/ Single (p) or Secondary (s) in a Cluster (required)\n -h <Help> prints this help\n[root@el8-repmgr-2 install]#\n[root@el8-repmgr-2 install]# sh pg_setup.sh -v14 -t s\nPostgreSQL Installation on AlmaLinux 8 \/ CentOS 8 \/ Oracle Linxu 8 \/ RHEL 8 \/ Rocky Linux 8\n\nDisabling PostgreSQL Packages provided by CentOS 8 or RedHat 8\nLast metadata expiration check: 7:03:32 ago on Thu 22 Dec 2022 02:59:34 PM CET.\nDependencies resolved.\n==========================================================================================================================================================================================================================================================================================\n Package Architecture Version Repository Size\n==========================================================================================================================================================================================================================================================================================\nDisabling modules:\n postgresql\n\nTransaction Summary\n==========================================================================================================================================================================================================================================================================================\n\nComplete!\nAdding PostgreSQL Repository\nLast metadata expiration check: 7:03:33 ago on Thu 22 Dec 2022 02:59:34 PM CET.\npgdg-redhat-repo-latest.noarch.rpm 14 kB\/s | 13 kB 00:00\nDependencies resolved.\n==========================================================================================================================================================================================================================================================================================\n Package Architecture Version Repository Size\n==========================================================================================================================================================================================================================================================================================\nInstalling:\n pgdg-redhat-repo noarch 42.0-28 @commandline 13 k\n\nTransaction Summary\n==========================================================================================================================================================================================================================================================================================\nInstall 1 Package\n\nTotal size: 13 k\nInstalled size: 14 k\nDownloading Packages:\nRunning transaction check\nTransaction check succeeded.\nRunning transaction test\nTransaction test succeeded.\nRunning transaction\n Preparing : 1\/1\n Installing : pgdg-redhat-repo-42.0-28.noarch 1\/1\n Verifying : pgdg-redhat-repo-42.0-28.noarch 1\/1\n\nInstalled:\n pgdg-redhat-repo-42.0-28.noarch\n\nComplete!\nInstalling PostgreSQL Packages including barman, repmgr and pg_stat_kcache\nPostgreSQL common RPMs for RHEL \/ Rocky 8 - x86_64 90 B\/s | 195 B 00:02\nPostgreSQL common RPMs for RHEL \/ Rocky 8 - x86_64 1.6 MB\/s | 1.7 kB 00:00\nImporting GPG key 0x442DF0F8:\n Userid : "PostgreSQL RPM Building Project <pgsql-pkg-yum@postgresql.org>"\n Fingerprint: 68C9 E2B9 1A37 D136 FE74 D176 1F16 D2E1 442D F0F8\n From : \/etc\/pki\/rpm-gpg\/RPM-GPG-KEY-PGDG\nPostgreSQL common RPMs for RHEL \/ Rocky 8 - x86_64 159 kB\/s | 702 kB 00:04\nPostgreSQL 15 for RHEL \/ Rocky 8 - x86_64 82 B\/s | 195 B 00:02\nPostgreSQL 15 for RHEL \/ Rocky 8 - x86_64 1.6 MB\/s | 1.7 kB 00:00\nImporting GPG key 0x442DF0F8:\n Userid : "PostgreSQL RPM Building Project <pgsql-pkg-yum@postgresql.org>"\n Fingerprint: 68C9 E2B9 1A37 D136 FE74 D176 1F16 D2E1 442D F0F8\n From : \/etc\/pki\/rpm-gpg\/RPM-GPG-KEY-PGDG\nPostgreSQL 15 for RHEL \/ Rocky 8 - x86_64 48 kB\/s | 164 kB 00:03\nPostgreSQL 14 for RHEL \/ Rocky 8 - x86_64 83 B\/s | 195 B 00:02\nPostgreSQL 14 for RHEL \/ Rocky 8 - x86_64 1.6 MB\/s | 1.7 kB 00:00\nImporting GPG key 0x442DF0F8:\n Userid : "PostgreSQL RPM Building Project <pgsql-pkg-yum@postgresql.org>"\n Fingerprint: 68C9 E2B9 1A37 D136 FE74 D176 1F16 D2E1 442D F0F8\n From : \/etc\/pki\/rpm-gpg\/RPM-GPG-KEY-PGDG\nPostgreSQL 14 for RHEL \/ Rocky 8 - x86_64 112 kB\/s | 463 kB 00:04\nPostgreSQL 13 for RHEL \/ Rocky 8 - x86_64 115 B\/s | 195 B 00:01\nPostgreSQL 13 for RHEL \/ Rocky 8 - x86_64 1.6 MB\/s | 1.7 kB 00:00\nImporting GPG key 0x442DF0F8:\n Userid : "PostgreSQL RPM Building Project <pgsql-pkg-yum@postgresql.org>"\n Fingerprint: 68C9 E2B9 1A37 D136 FE74 D176 1F16 D2E1 442D F0F8\n From : \/etc\/pki\/rpm-gpg\/RPM-GPG-KEY-PGDG\nPostgreSQL 13 for RHEL \/ Rocky 8 - x86_64 212 kB\/s | 755 kB 00:03\nPostgreSQL 12 for RHEL \/ Rocky 8 - x86_64 104 B\/s | 195 B 00:01\nPostgreSQL 12 for RHEL \/ Rocky 8 - x86_64 1.6 MB\/s | 1.7 kB 00:00\nImporting GPG key 0x442DF0F8:\n Userid : "PostgreSQL RPM Building Project <pgsql-pkg-yum@postgresql.org>"\n Fingerprint: 68C9 E2B9 1A37 D136 FE74 D176 1F16 D2E1 442D F0F8\n From : \/etc\/pki\/rpm-gpg\/RPM-GPG-KEY-PGDG\nPostgreSQL 12 for RHEL \/ Rocky 8 - x86_64 217 kB\/s | 901 kB 00:04\nPostgreSQL 11 for RHEL \/ Rocky 8 - x86_64 105 B\/s | 195 B 00:01\nPostgreSQL 11 for RHEL \/ Rocky 8 - x86_64 1.6 MB\/s | 1.7 kB 00:00\nImporting GPG key 0x442DF0F8:\n Userid : "PostgreSQL RPM Building Project <pgsql-pkg-yum@postgresql.org>"\n Fingerprint: 68C9 E2B9 1A37 D136 FE74 D176 1F16 D2E1 442D F0F8\n From : \/etc\/pki\/rpm-gpg\/RPM-GPG-KEY-PGDG\nPostgreSQL 11 for RHEL \/ Rocky 8 - x86_64 288 kB\/s | 1.1 MB 00:03\nPostgreSQL 10 for RHEL \/ Rocky 8 - x86_64 100 B\/s | 195 B 00:01\nPostgreSQL 10 for RHEL \/ Rocky 8 - x86_64 1.6 MB\/s | 1.7 kB 00:00\nImporting GPG key 0x442DF0F8:\n Userid : "PostgreSQL RPM Building Project <pgsql-pkg-yum@postgresql.org>"\n Fingerprint: 68C9 E2B9 1A37 D136 FE74 D176 1F16 D2E1 442D F0F8\n From : \/etc\/pki\/rpm-gpg\/RPM-GPG-KEY-PGDG\nPostgreSQL 10 for RHEL \/ Rocky 8 - x86_64 194 kB\/s | 700 kB 00:03\nDependencies resolved.\n==========================================================================================================================================================================================================================================================================================\n Package Architecture Version Repository Size\n==========================================================================================================================================================================================================================================================================================\nInstalling:\n barman noarch 3.3.0-1.rhel8 pgdg-common 48 k\n pg_stat_kcache_14 x86_64 2.2.1-2.rhel8 pgdg14 47 k\n postgresql14 x86_64 14.6-1PGDG.rhel8 pgdg14 1.5 M\n postgresql14-contrib x86_64 14.6-1PGDG.rhel8 pgdg14 726 k\n postgresql14-libs x86_64 14.6-1PGDG.rhel8 pgdg14 278 k\n postgresql14-server x86_64 14.6-1PGDG.rhel8 pgdg14 5.7 M\n repmgr_14 x86_64 5.3.3-1.rhel8 pgdg14 284 k\nInstalling dependencies:\n libicu x86_64 60.3-2.el8_1 baseos 8.8 M\n lz4 x86_64 1.8.3-3.el8_4 baseos 102 k\n perl-Carp noarch 1.42-396.el8 baseos 30 k\n perl-Data-Dumper x86_64 2.167-399.el8 baseos 58 k\n perl-Digest noarch 1.17-395.el8 appstream 27 k\n perl-Digest-MD5 x86_64 2.55-396.el8 appstream 37 k\n perl-Encode x86_64 4:2.97-3.el8 baseos 1.5 M\n perl-Errno x86_64 1.28-421.el8 baseos 75 k\n perl-Exporter noarch 5.72-396.el8 baseos 34 k\n perl-File-Path noarch 2.15-2.el8 baseos 38 k\n perl-File-Temp noarch 0.230.600-1.el8 baseos 62 k\n perl-Getopt-Long noarch 1:2.50-4.el8 baseos 63 k\n perl-HTTP-Tiny noarch 0.074-1.el8 baseos 58 k\n perl-IO x86_64 1.38-421.el8 baseos 141 k\n perl-MIME-Base64 x86_64 3.15-396.el8 baseos 30 k\n perl-Net-SSLeay x86_64 1.88-2.module_el8.6.0+2811+fe6c84b0 appstream 378 k\n perl-PathTools x86_64 3.74-1.el8 baseos 90 k\n perl-Pod-Escapes noarch 1:1.07-395.el8 baseos 20 k\n perl-Pod-Perldoc noarch 3.28-396.el8 baseos 86 k\n perl-Pod-Simple noarch 1:3.35-395.el8 baseos 213 k\n perl-Pod-Usage noarch 4:1.69-395.el8 baseos 34 k\n perl-Scalar-List-Utils x86_64 3:1.49-2.el8 baseos 68 k\n perl-Socket x86_64 4:2.027-3.el8 baseos 59 k\n perl-Storable x86_64 1:3.11-3.el8 baseos 98 k\n perl-Term-ANSIColor noarch 4.06-396.el8 baseos 46 k\n perl-Term-Cap noarch 1.17-395.el8 baseos 23 k\n perl-Text-ParseWords noarch 3.30-395.el8 baseos 18 k\n perl-Text-Tabs+Wrap noarch 2013.0523-395.el8 baseos 24 k\n perl-Time-Local noarch 1:1.280-1.el8 baseos 33 k\n perl-URI noarch 1.73-3.el8 appstream 116 k\n perl-Unicode-Normalize x86_64 1.25-396.el8 baseos 82 k\n perl-constant noarch 1.33-396.el8 baseos 25 k\n perl-interpreter x86_64 4:5.26.3-421.el8 baseos 6.3 M\n perl-libnet noarch 3.11-3.el8 appstream 121 k\n perl-libs x86_64 4:5.26.3-421.el8 baseos 1.6 M\n perl-macros x86_64 4:5.26.3-421.el8 baseos 71 k\n perl-parent noarch 1:0.237-1.el8 baseos 20 k\n perl-podlators noarch 4.11-1.el8 baseos 118 k\n perl-threads x86_64 1:2.21-2.el8 baseos 61 k\n perl-threads-shared x86_64 1.58-2.el8 baseos 47 k\n python3-argcomplete noarch 1.9.3-6.el8 appstream 60 k\n python3-barman noarch 3.3.0-1.rhel8 pgdg-common 455 k\n python3-pip noarch 9.0.3-22.el8 appstream 19 k\n python3-psycopg2 x86_64 2.8.6-1.rhel8 pgdg-common 178 k\n python3-setuptools noarch 39.2.0-6.el8 baseos 162 k\n python36 x86_64 3.6.8-38.module_el8.5.0+2569+5c5719bc appstream 18 k\n rsync x86_64 3.1.3-19.el8 baseos 409 k\nInstalling weak dependencies:\n perl-IO-Socket-IP noarch 0.39-5.el8 appstream 47 k\n perl-IO-Socket-SSL noarch 2.066-4.module_el8.6.0+2811+fe6c84b0 appstream 297 k\n perl-Mozilla-CA noarch 20160104-7.module_el8.5.0+2812+ed912d05 appstream 14 k\nEnabling module streams:\n perl 5.26\n perl-IO-Socket-SSL 2.066\n perl-libwww-perl 6.34\n python36 3.6\n\nTransaction Summary\n==========================================================================================================================================================================================================================================================================================\nInstall 57 Packages\n\nTotal download size: 31 M\nInstalled size: 107 M\nDownloading Packages:\n(1\/57): perl-Carp-1.42-396.el8.noarch.rpm 292 kB\/s | 30 kB 00:00\n(2\/57): lz4-1.8.3-3.el8_4.x86_64.rpm 696 kB\/s | 102 kB 00:00\n(3\/57): perl-Data-Dumper-2.167-399.el8.x86_64.rpm 1.1 MB\/s | 58 kB 00:00\n(4\/57): perl-Errno-1.28-421.el8.x86_64.rpm 1.4 MB\/s | 75 kB 00:00\n(5\/57): perl-Exporter-5.72-396.el8.noarch.rpm 991 kB\/s | 34 kB 00:00\n(6\/57): perl-File-Path-2.15-2.el8.noarch.rpm 1.2 MB\/s | 38 kB 00:00\n(7\/57): perl-File-Temp-0.230.600-1.el8.noarch.rpm 2.4 MB\/s | 62 kB 00:00\n(8\/57): perl-Getopt-Long-2.50-4.el8.noarch.rpm 2.0 MB\/s | 63 kB 00:00\n(9\/57): perl-HTTP-Tiny-0.074-1.el8.noarch.rpm 1.6 MB\/s | 58 kB 00:00\n(10\/57): perl-IO-1.38-421.el8.x86_64.rpm 2.2 MB\/s | 141 kB 00:00\n(11\/57): perl-MIME-Base64-3.15-396.el8.x86_64.rpm 1.0 MB\/s | 30 kB 00:00\n(12\/57): perl-PathTools-3.74-1.el8.x86_64.rpm 3.2 MB\/s | 90 kB 00:00\n(13\/57): perl-Pod-Escapes-1.07-395.el8.noarch.rpm 828 kB\/s | 20 kB 00:00\n(14\/57): perl-Pod-Perldoc-3.28-396.el8.noarch.rpm 2.9 MB\/s | 86 kB 00:00\n(15\/57): perl-Pod-Simple-3.35-395.el8.noarch.rpm 3.8 MB\/s | 213 kB 00:00\n(16\/57): perl-Encode-2.97-3.el8.x86_64.rpm 3.1 MB\/s | 1.5 MB 00:00\n(17\/57): perl-Pod-Usage-1.69-395.el8.noarch.rpm 1.3 MB\/s | 34 kB 00:00\n(18\/57): perl-Scalar-List-Utils-1.49-2.el8.x86_64.rpm 2.1 MB\/s | 68 kB 00:00\n(19\/57): perl-Socket-2.027-3.el8.x86_64.rpm 1.5 MB\/s | 59 kB 00:00\n(20\/57): perl-Storable-3.11-3.el8.x86_64.rpm 2.9 MB\/s | 98 kB 00:00\n(21\/57): perl-Term-ANSIColor-4.06-396.el8.noarch.rpm 1.3 MB\/s | 46 kB 00:00\n(22\/57): perl-Term-Cap-1.17-395.el8.noarch.rpm 712 kB\/s | 23 kB 00:00\n(23\/57): perl-Text-ParseWords-3.30-395.el8.noarch.rpm 681 kB\/s | 18 kB 00:00\n(24\/57): perl-Text-Tabs+Wrap-2013.0523-395.el8.noarch.rpm 965 kB\/s | 24 kB 00:00\n(25\/57): perl-Time-Local-1.280-1.el8.noarch.rpm 1.2 MB\/s | 33 kB 00:00\n(26\/57): perl-Unicode-Normalize-1.25-396.el8.x86_64.rpm 3.0 MB\/s | 82 kB 00:00\n(27\/57): perl-constant-1.33-396.el8.noarch.rpm 846 kB\/s | 25 kB 00:00\n(28\/57): perl-libs-5.26.3-421.el8.x86_64.rpm 6.5 MB\/s | 1.6 MB 00:00\n(29\/57): perl-macros-5.26.3-421.el8.x86_64.rpm 2.4 MB\/s | 71 kB 00:00\n(30\/57): perl-parent-0.237-1.el8.noarch.rpm 698 kB\/s | 20 kB 00:00\n(31\/57): libicu-60.3-2.el8_1.x86_64.rpm 8.0 MB\/s | 8.8 MB 00:01\n(32\/57): perl-podlators-4.11-1.el8.noarch.rpm 3.9 MB\/s | 118 kB 00:00\n(33\/57): perl-threads-shared-1.58-2.el8.x86_64.rpm 1.9 MB\/s | 47 kB 00:00\n(34\/57): perl-threads-2.21-2.el8.x86_64.rpm 2.2 MB\/s | 61 kB 00:00\n(35\/57): python3-setuptools-39.2.0-6.el8.noarch.rpm 5.2 MB\/s | 162 kB 00:00\n(36\/57): rsync-3.1.3-19.el8.x86_64.rpm 11 MB\/s | 409 kB 00:00\n(37\/57): perl-Digest-1.17-395.el8.noarch.rpm 803 kB\/s | 27 kB 00:00\n(38\/57): perl-Digest-MD5-2.55-396.el8.x86_64.rpm 1.4 MB\/s | 37 kB 00:00\n(39\/57): perl-IO-Socket-IP-0.39-5.el8.noarch.rpm 1.5 MB\/s | 47 kB 00:00\n(40\/57): perl-IO-Socket-SSL-2.066-4.module_el8.6.0+2811+fe6c84b0.noarch.rpm 7.9 MB\/s | 297 kB 00:00\n(41\/57): perl-Mozilla-CA-20160104-7.module_el8.5.0+2812+ed912d05.noarch.rpm 486 kB\/s | 14 kB 00:00\n(42\/57): perl-Net-SSLeay-1.88-2.module_el8.6.0+2811+fe6c84b0.x86_64.rpm 9.7 MB\/s | 378 kB 00:00\n(43\/57): perl-URI-1.73-3.el8.noarch.rpm 5.1 MB\/s | 116 kB 00:00\n(44\/57): perl-libnet-3.11-3.el8.noarch.rpm 4.3 MB\/s | 121 kB 00:00\n(45\/57): python3-argcomplete-1.9.3-6.el8.noarch.rpm 2.1 MB\/s | 60 kB 00:00\n(46\/57): python3-pip-9.0.3-22.el8.noarch.rpm 851 kB\/s | 19 kB 00:00\n(47\/57): python36-3.6.8-38.module_el8.5.0+2569+5c5719bc.x86_64.rpm 692 kB\/s | 18 kB 00:00\n(48\/57): perl-interpreter-5.26.3-421.el8.x86_64.rpm 9.6 MB\/s | 6.3 MB 00:00\n(49\/57): barman-3.3.0-1.rhel8.noarch.rpm 30 kB\/s | 48 kB 00:01\n(50\/57): python3-barman-3.3.0-1.rhel8.noarch.rpm 281 kB\/s | 455 kB 00:01\n(51\/57): python3-psycopg2-2.8.6-1.rhel8.x86_64.rpm 116 kB\/s | 178 kB 00:01\n(52\/57): pg_stat_kcache_14-2.2.1-2.rhel8.x86_64.rpm 103 kB\/s | 47 kB 00:00\n(53\/57): postgresql14-14.6-1PGDG.rhel8.x86_64.rpm 2.9 MB\/s | 1.5 MB 00:00\n(54\/57): postgresql14-contrib-14.6-1PGDG.rhel8.x86_64.rpm 1.3 MB\/s | 726 kB 00:00\n(55\/57): repmgr_14-5.3.3-1.rhel8.x86_64.rpm 1.4 MB\/s | 284 kB 00:00\n(56\/57): postgresql14-server-14.6-1PGDG.rhel8.x86_64.rpm 9.8 MB\/s | 5.7 MB 00:00\n(57\/57): postgresql14-libs-14.6-1PGDG.rhel8.x86_64.rpm 408 kB\/s | 278 kB 00:00\n------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------\nTotal 5.5 MB\/s | 31 MB 00:05\nPostgreSQL common RPMs for RHEL \/ Rocky 8 - x86_64 1.6 MB\/s | 1.7 kB 00:00\nImporting GPG key 0x442DF0F8:\n Userid : "PostgreSQL RPM Building Project <pgsql-pkg-yum@postgresql.org>"\n Fingerprint: 68C9 E2B9 1A37 D136 FE74 D176 1F16 D2E1 442D F0F8\n From : \/etc\/pki\/rpm-gpg\/RPM-GPG-KEY-PGDG\nKey imported successfully\nRunning transaction check\nTransaction check succeeded.\nRunning transaction test\nTransaction test succeeded.\nRunning transaction\n Preparing : 1\/1\n Installing : perl-Digest-1.17-395.el8.noarch 1\/57\n Installing : perl-Digest-MD5-2.55-396.el8.x86_64 2\/57\n Installing : perl-Data-Dumper-2.167-399.el8.x86_64 3\/57\n Installing : perl-libnet-3.11-3.el8.noarch 4\/57\n Installing : perl-Net-SSLeay-1.88-2.module_el8.6.0+2811+fe6c84b0.x86_64 5\/57\n Installing : perl-URI-1.73-3.el8.noarch 6\/57\n Installing : perl-Pod-Escapes-1:1.07-395.el8.noarch 7\/57\n Installing : perl-Time-Local-1:1.280-1.el8.noarch 8\/57\n Installing : perl-IO-Socket-IP-0.39-5.el8.noarch 9\/57\n Installing : perl-Mozilla-CA-20160104-7.module_el8.5.0+2812+ed912d05.noarch 10\/57\n Installing : perl-IO-Socket-SSL-2.066-4.module_el8.6.0+2811+fe6c84b0.noarch 11\/57\n Installing : perl-Term-ANSIColor-4.06-396.el8.noarch 12\/57\n Installing : perl-Term-Cap-1.17-395.el8.noarch 13\/57\n Installing : perl-File-Temp-0.230.600-1.el8.noarch 14\/57\n Installing : perl-Pod-Simple-1:3.35-395.el8.noarch 15\/57\n Installing : perl-HTTP-Tiny-0.074-1.el8.noarch 16\/57\n Installing : perl-podlators-4.11-1.el8.noarch 17\/57\n Installing : perl-Pod-Perldoc-3.28-396.el8.noarch 18\/57\n Installing : perl-Text-ParseWords-3.30-395.el8.noarch 19\/57\n Installing : perl-Pod-Usage-4:1.69-395.el8.noarch 20\/57\n Installing : perl-MIME-Base64-3.15-396.el8.x86_64 21\/57\n Installing : perl-Storable-1:3.11-3.el8.x86_64 22\/57\n Installing : perl-Getopt-Long-1:2.50-4.el8.noarch 23\/57\n Installing : perl-Errno-1.28-421.el8.x86_64 24\/57\n Installing : perl-Socket-4:2.027-3.el8.x86_64 25\/57\n Installing : perl-Encode-4:2.97-3.el8.x86_64 26\/57\n Installing : perl-Exporter-5.72-396.el8.noarch 27\/57\n Installing : perl-Scalar-List-Utils-3:1.49-2.el8.x86_64 28\/57\n Installing : perl-macros-4:5.26.3-421.el8.x86_64 29\/57\n Installing : perl-parent-1:0.237-1.el8.noarch 30\/57\n Installing : perl-Text-Tabs+Wrap-2013.0523-395.el8.noarch 31\/57\n Installing : perl-Unicode-Normalize-1.25-396.el8.x86_64 32\/57\n Installing : perl-File-Path-2.15-2.el8.noarch 33\/57\n Installing : perl-IO-1.38-421.el8.x86_64 34\/57\n Installing : perl-PathTools-3.74-1.el8.x86_64 35\/57\n Installing : perl-constant-1.33-396.el8.noarch 36\/57\n Installing : perl-threads-1:2.21-2.el8.x86_64 37\/57\n Installing : perl-threads-shared-1.58-2.el8.x86_64 38\/57\n Installing : perl-libs-4:5.26.3-421.el8.x86_64 39\/57\n Installing : perl-Carp-1.42-396.el8.noarch 40\/57\n Installing : perl-interpreter-4:5.26.3-421.el8.x86_64 41\/57\n Installing : postgresql14-libs-14.6-1PGDG.rhel8.x86_64 42\/57\n Running scriptlet: postgresql14-libs-14.6-1PGDG.rhel8.x86_64 42\/57\n Installing : python3-setuptools-39.2.0-6.el8.noarch 43\/57\n Installing : python3-pip-9.0.3-22.el8.noarch 44\/57\n Installing : python36-3.6.8-38.module_el8.5.0+2569+5c5719bc.x86_64 45\/57\n Running scriptlet: python36-3.6.8-38.module_el8.5.0+2569+5c5719bc.x86_64 45\/57\n Installing : libicu-60.3-2.el8_1.x86_64 46\/57\n Running scriptlet: libicu-60.3-2.el8_1.x86_64 46\/57\n Installing : python3-psycopg2-2.8.6-1.rhel8.x86_64 47\/57\n Installing : python3-argcomplete-1.9.3-6.el8.noarch 48\/57\n Installing : python3-barman-3.3.0-1.rhel8.noarch 49\/57\n Installing : rsync-3.1.3-19.el8.x86_64 50\/57\n Installing : lz4-1.8.3-3.el8_4.x86_64 51\/57\n Installing : postgresql14-14.6-1PGDG.rhel8.x86_64 52\/57\n Running scriptlet: postgresql14-14.6-1PGDG.rhel8.x86_64 52\/57\n Running scriptlet: postgresql14-server-14.6-1PGDG.rhel8.x86_64 53\/57\n Installing : postgresql14-server-14.6-1PGDG.rhel8.x86_64 53\/57\n Running scriptlet: postgresql14-server-14.6-1PGDG.rhel8.x86_64 53\/57\n Installing : pg_stat_kcache_14-2.2.1-2.rhel8.x86_64 54\/57\n Running scriptlet: pg_stat_kcache_14-2.2.1-2.rhel8.x86_64 54\/57\n Installing : postgresql14-contrib-14.6-1PGDG.rhel8.x86_64 55\/57\n Running scriptlet: repmgr_14-5.3.3-1.rhel8.x86_64 56\/57\n Installing : repmgr_14-5.3.3-1.rhel8.x86_64 56\/57\n Running scriptlet: repmgr_14-5.3.3-1.rhel8.x86_64 56\/57\n Running scriptlet: barman-3.3.0-1.rhel8.noarch 57\/57\n Installing : barman-3.3.0-1.rhel8.noarch 57\/57\n Running scriptlet: barman-3.3.0-1.rhel8.noarch 57\/57\n Verifying : libicu-60.3-2.el8_1.x86_64 1\/57\n Verifying : lz4-1.8.3-3.el8_4.x86_64 2\/57\n Verifying : perl-Carp-1.42-396.el8.noarch 3\/57\n Verifying : perl-Data-Dumper-2.167-399.el8.x86_64 4\/57\n Verifying : perl-Encode-4:2.97-3.el8.x86_64 5\/57\n Verifying : perl-Errno-1.28-421.el8.x86_64 6\/57\n Verifying : perl-Exporter-5.72-396.el8.noarch 7\/57\n Verifying : perl-File-Path-2.15-2.el8.noarch 8\/57\n Verifying : perl-File-Temp-0.230.600-1.el8.noarch 9\/57\n Verifying : perl-Getopt-Long-1:2.50-4.el8.noarch 10\/57\n Verifying : perl-HTTP-Tiny-0.074-1.el8.noarch 11\/57\n Verifying : perl-IO-1.38-421.el8.x86_64 12\/57\n Verifying : perl-MIME-Base64-3.15-396.el8.x86_64 13\/57\n Verifying : perl-PathTools-3.74-1.el8.x86_64 14\/57\n Verifying : perl-Pod-Escapes-1:1.07-395.el8.noarch 15\/57\n Verifying : perl-Pod-Perldoc-3.28-396.el8.noarch 16\/57\n Verifying : perl-Pod-Simple-1:3.35-395.el8.noarch 17\/57\n Verifying : perl-Pod-Usage-4:1.69-395.el8.noarch 18\/57\n Verifying : perl-Scalar-List-Utils-3:1.49-2.el8.x86_64 19\/57\n Verifying : perl-Socket-4:2.027-3.el8.x86_64 20\/57\n Verifying : perl-Storable-1:3.11-3.el8.x86_64 21\/57\n Verifying : perl-Term-ANSIColor-4.06-396.el8.noarch 22\/57\n Verifying : perl-Term-Cap-1.17-395.el8.noarch 23\/57\n Verifying : perl-Text-ParseWords-3.30-395.el8.noarch 24\/57\n Verifying : perl-Text-Tabs+Wrap-2013.0523-395.el8.noarch 25\/57\n Verifying : perl-Time-Local-1:1.280-1.el8.noarch 26\/57\n Verifying : perl-Unicode-Normalize-1.25-396.el8.x86_64 27\/57\n Verifying : perl-constant-1.33-396.el8.noarch 28\/57\n Verifying : perl-interpreter-4:5.26.3-421.el8.x86_64 29\/57\n Verifying : perl-libs-4:5.26.3-421.el8.x86_64 30\/57\n Verifying : perl-macros-4:5.26.3-421.el8.x86_64 31\/57\n Verifying : perl-parent-1:0.237-1.el8.noarch 32\/57\n Verifying : perl-podlators-4.11-1.el8.noarch 33\/57\n Verifying : perl-threads-1:2.21-2.el8.x86_64 34\/57\n Verifying : perl-threads-shared-1.58-2.el8.x86_64 35\/57\n Verifying : python3-setuptools-39.2.0-6.el8.noarch 36\/57\n Verifying : rsync-3.1.3-19.el8.x86_64 37\/57\n Verifying : perl-Digest-1.17-395.el8.noarch 38\/57\n Verifying : perl-Digest-MD5-2.55-396.el8.x86_64 39\/57\n Verifying : perl-IO-Socket-IP-0.39-5.el8.noarch 40\/57\n Verifying : perl-IO-Socket-SSL-2.066-4.module_el8.6.0+2811+fe6c84b0.noarch 41\/57\n Verifying : perl-Mozilla-CA-20160104-7.module_el8.5.0+2812+ed912d05.noarch 42\/57\n Verifying : perl-Net-SSLeay-1.88-2.module_el8.6.0+2811+fe6c84b0.x86_64 43\/57\n Verifying : perl-URI-1.73-3.el8.noarch 44\/57\n Verifying : perl-libnet-3.11-3.el8.noarch 45\/57\n Verifying : python3-argcomplete-1.9.3-6.el8.noarch 46\/57\n Verifying : python3-pip-9.0.3-22.el8.noarch 47\/57\n Verifying : python36-3.6.8-38.module_el8.5.0+2569+5c5719bc.x86_64 48\/57\n Verifying : barman-3.3.0-1.rhel8.noarch 49\/57\n Verifying : python3-barman-3.3.0-1.rhel8.noarch 50\/57\n Verifying : python3-psycopg2-2.8.6-1.rhel8.x86_64 51\/57\n Verifying : pg_stat_kcache_14-2.2.1-2.rhel8.x86_64 52\/57\n Verifying : postgresql14-14.6-1PGDG.rhel8.x86_64 53\/57\n Verifying : postgresql14-contrib-14.6-1PGDG.rhel8.x86_64 54\/57\n Verifying : postgresql14-libs-14.6-1PGDG.rhel8.x86_64 55\/57\n Verifying : postgresql14-server-14.6-1PGDG.rhel8.x86_64 56\/57\n Verifying : repmgr_14-5.3.3-1.rhel8.x86_64 57\/57\n\nInstalled:\n barman-3.3.0-1.rhel8.noarch libicu-60.3-2.el8_1.x86_64 lz4-1.8.3-3.el8_4.x86_64 perl-Carp-1.42-396.el8.noarch perl-Data-Dumper-2.167-399.el8.x86_64\n perl-Digest-1.17-395.el8.noarch perl-Digest-MD5-2.55-396.el8.x86_64 perl-Encode-4:2.97-3.el8.x86_64 perl-Errno-1.28-421.el8.x86_64 perl-Exporter-5.72-396.el8.noarch\n perl-File-Path-2.15-2.el8.noarch perl-File-Temp-0.230.600-1.el8.noarch perl-Getopt-Long-1:2.50-4.el8.noarch perl-HTTP-Tiny-0.074-1.el8.noarch perl-IO-1.38-421.el8.x86_64\n perl-IO-Socket-IP-0.39-5.el8.noarch perl-IO-Socket-SSL-2.066-4.module_el8.6.0+2811+fe6c84b0.noarch perl-MIME-Base64-3.15-396.el8.x86_64 perl-Mozilla-CA-20160104-7.module_el8.5.0+2812+ed912d05.noarch perl-Net-SSLeay-1.88-2.module_el8.6.0+2811+fe6c84b0.x86_64\n perl-PathTools-3.74-1.el8.x86_64 perl-Pod-Escapes-1:1.07-395.el8.noarch perl-Pod-Perldoc-3.28-396.el8.noarch perl-Pod-Simple-1:3.35-395.el8.noarch perl-Pod-Usage-4:1.69-395.el8.noarch\n perl-Scalar-List-Utils-3:1.49-2.el8.x86_64 perl-Socket-4:2.027-3.el8.x86_64 perl-Storable-1:3.11-3.el8.x86_64 perl-Term-ANSIColor-4.06-396.el8.noarch perl-Term-Cap-1.17-395.el8.noarch\n perl-Text-ParseWords-3.30-395.el8.noarch perl-Text-Tabs+Wrap-2013.0523-395.el8.noarch perl-Time-Local-1:1.280-1.el8.noarch perl-URI-1.73-3.el8.noarch perl-Unicode-Normalize-1.25-396.el8.x86_64\n perl-constant-1.33-396.el8.noarch perl-interpreter-4:5.26.3-421.el8.x86_64 perl-libnet-3.11-3.el8.noarch perl-libs-4:5.26.3-421.el8.x86_64 perl-macros-4:5.26.3-421.el8.x86_64\n perl-parent-1:0.237-1.el8.noarch perl-podlators-4.11-1.el8.noarch perl-threads-1:2.21-2.el8.x86_64 perl-threads-shared-1.58-2.el8.x86_64 pg_stat_kcache_14-2.2.1-2.rhel8.x86_64\n postgresql14-14.6-1PGDG.rhel8.x86_64 postgresql14-contrib-14.6-1PGDG.rhel8.x86_64 postgresql14-libs-14.6-1PGDG.rhel8.x86_64 postgresql14-server-14.6-1PGDG.rhel8.x86_64 python3-argcomplete-1.9.3-6.el8.noarch\n python3-barman-3.3.0-1.rhel8.noarch python3-pip-9.0.3-22.el8.noarch python3-psycopg2-2.8.6-1.rhel8.x86_64 python3-setuptools-39.2.0-6.el8.noarch python36-3.6.8-38.module_el8.5.0+2569+5c5719bc.x86_64\n repmgr_14-5.3.3-1.rhel8.x86_64 rsync-3.1.3-19.el8.x86_64\n\nComplete!\nCreating override.conf\n[Service]\nEnvironment=PGDATA=\/pgdata\/14\/data\nInitialyze PostgreSQL 14\nInitializing database ... OK\n\nEnable PostgreSQL Service\nCreated symlink \/etc\/systemd\/system\/multi-user.target.wants\/postgresql-14.service \u2192 \/usr\/lib\/systemd\/system\/postgresql-14.service.\nsuccess\nsuccess\n[root@el8-repmgr-2 install]#\n<\/pre><\/div>\n\n\nThe difference to the Master \/ Leader installation is that the service is not started, we need an empty pgdata for creating the replica. Again after installation of PostgreSQL we need to change the ownership of the config scripts to postgresql.<\/p>\n\n\n
\n[root@el8-repmgr-2 pgsql]# chown -R postgres:postgres config\/\n<\/pre><\/div>\n\n\nAgain the setup of .pgpass.<\/p>\n\n\n
\n[postgres@el8-repmgr-2 config]$ sh pgpass.sh -h\nUsage:\npgpass.sh [OPTION]\n\nOptions:\n -p <Primary Server> server where the primary host is running on (required)\n -s <Secondary Server> server where the secondary host is running on (required)\n -h <Help> prints this help\n[postgres@el8-repmgr-2 config]$\n[postgres@el8-repmgr-2 config]$ sh pgpass.sh -p el8-repmgr-1 -s el8-repmgr2\n2022.12.22-22:19:53 [4695]INFO: #host:port:database:user:password in \/var\/lib\/pgsql\/.pgpass\n#host:port:database:user:password\n2022.12.22-22:19:53 [4695]INFO: Setting localhost in\nlocalhost:5432:*:repmgr:PutYourPasswordHere\n2022.12.22-22:19:53 [4695]INFO: Setting 127.0.0.1 in \/var\/lib\/pgsql\/.pgpass\n127.0.0.1:5432:*:repmgr:PutYourPasswordHere\n2022.12.22-22:19:53 [4695]INFO: Setting Primary el8-repmgr-1 in \/var\/lib\/pgsql\/.pgpass\nel8-repmgr-1.localdomain:5432:*:repmgr:PutYourPasswordHere\n2022.12.22-22:19:53 [4695]INFO: Setting Primary el8-repmgr2 in \/var\/lib\/pgsql\/.pgpass\nel8-repmgr2.localdomain:5432:*:repmgr:PutYourPasswordHere\n[postgres@el8-repmgr-2 config]$\n\n<\/pre><\/div>\n\n\nNow we can start the setup of the replica node, again, the script contains a help wiht -h.<\/p>\n\n\n
\n[postgres@el8-repmgr-2 config]$ sh repMgrStandbyNEW_setup.sh -h\nUsage:\nrepMgrStandbyNEW_setup.sh [OPTION]\n\nOptions:\n -p <Primary Server> host where the primary server is running on (required)\n -s <Standby Server> host where the standby server is running on (required)\n -v <PostgreSQL Major Release> Major Release Number like 11 or 12 (required)\n -h <Help> prints this help\n[postgres@el8-repmgr-2 config]$\n[root@el8-repmgr-2 config]# [postgres@el8-repmgr-2 config]$ sh repMgrStandbyNEW_setup.sh -p el8-repmgr-1 -s el8-repmgr-2 -v 14\n2022.12.22-22:58:50 [6741]INFO: Setting node_id=2 in \/etc\/repmgr\/14\/repmgr.conf\nnode_id=2\n2022.12.22-22:58:50 [6741]INFO: Setting node_name=el8-repmgr-2 in \/etc\/repmgr\/14\/repmgr.conf\nnode_name=el8-repmgr-2\n2022.12.22-22:58:50 [6741]INFO: Setting conninfo='host=el8-repmgr-2.localdomain user=repmgr dbname=repmgrdb' in \/etc\/repmgr\/14\/repmgr.conf\nconninfo='host=el8-repmgr-2.localdomain user=repmgr dbname=repmgrdb'\n2022.12.22-22:58:50 [6741]Info: Setting 'use_replication_slots=true' in \/etc\/repmgr\/14\/repmgr.conf\nuse_replication_slots=true\n2022.12.22-22:58:50 [6741]INFO: Setting data_directory='\/pgdata\/14\/data' in \/etc\/repmgr\/14\/repmgr.conf\ndata_directory='\/pgdata\/14\/data'\nNOTICE: destination directory "\/pgdata\/14\/data" provided\nINFO: connecting to source node\nDETAIL: connection string is: host=el8-repmgr-1.localdomain user=repmgr dbname=repmgrdb\nDETAIL: current installation size is 34 MB\nNOTICE: checking for available walsenders on the source node (2 required)\nNOTICE: checking replication connections can be made to the source server (2 required)\nWARNING: data checksums are not enabled and "wal_log_hints" is "off"\nDETAIL: pg_rewind requires "wal_log_hints" to be enabled\nWARNING: directory "\/pgdata\/14\/data" exists but is not empty\nNOTICE: -F\/--force provided - deleting existing data directory "\/pgdata\/14\/data"\nNOTICE: starting backup (using pg_basebackup)...\nHINT: this may take some time; consider using the -c\/--fast-checkpoint option\nINFO: executing:\n pg_basebackup -l "repmgr base backup" -D \/pgdata\/14\/data -h el8-repmgr-1.localdomain -p 5432 -U repmgr -X stream -S repmgr_slot_2\nNOTICE: standby clone (using pg_basebackup) complete\nNOTICE: you can now start your PostgreSQL server\nHINT: for example: pg_ctl -D \/pgdata\/14\/data start\nHINT: after starting the server, you need to register this standby with "repmgr standby register"\n2022.12.22-22:58:51 [6741]INFO: Registering standby returned 0\nINFO: connecting to local node "el8-repmgr-2" (ID: 2)\nINFO: connecting to primary database\nWARNING: --upstream-node-id not supplied, assuming upstream node is primary (node ID: 1)\nINFO: standby registration complete\nNOTICE: standby node "el8-repmgr-2" (ID: 2) successfully registered\nsetup of standby successfully completed\n[postgres@el8-repmgr-2 config]$\n<\/pre><\/div>\n\n\nNow the cluster is up and running.<\/p>\n\n\n
\n[postgres@el8-repmgr-1 ~]$ \/usr\/pgsql-14\/bin\/repmgr cluster show\n ID | Name | Role | Status | Upstream | Location | Priority | Timeline | Connection string\n----+--------------+---------+-----------+--------------+----------+----------+----------+-----------------------------------------------------------\n 1 | el8-repmgr-1 | primary | * running | | default | 100 | 1 | host=el8-repmgr-1.localdomain user=repmgr dbname=repmgrdb\n 2 | el8-repmgr-2 | standby | running | el8-repmgr-1 | default | 100 | 1 | host=el8-repmgr-2.localdomain user=repmgr dbname=repmgrdb\n[postgres@el8-repmgr-1 ~]$\n<\/pre><\/div>\n\n\nThe auto failover trick in repmgr.conf:<\/p>\n\n\n
\nnode_id=1\nnode_name=el8-repmgr-1\nconninfo='host=el8-repmgr-1.localdomain user=repmgr dbname=repmgrdb'\nuse_replication_slots=true\ndata_directory='\/pgdata\/14\/data'\nfailover='automatic'\npromote_command='\/usr\/pgsql-14\/bin\/repmgr standby promote -f \/etc\/repmgr\/14\/repmgr.conf --log-to-file'\nfollow_command='\/usr\/pgsql-14\/bin\/repmgr standby follow -f \/etc\/repmgr\/14\/repmgr.conf --log-to-file --upstream-node-id=%n'\nmonitor_interval_secs=2\nconnection_check_type='ping'\nreconnect_attempts=6\nreconnect_interval=10\nstandby_disconnect_on_failover=true\nservice_start_command='sudo \/usr\/bin\/systemctl start postgresql-14.service'\nservice_stop_command='sudo \/usr\/bin\/systemctl stop postgresql-14.service'\nservice_restart_command='sudo \/usr\/bin\/systemctl restart postgresql-14.service'\nservice_reload_command='sudo \/usr\/bin\/systemctl reload postgresql-14.service'\n<\/pre><\/div>\n\n\nfailover<\/h5>\n\n\n\n
The failover parameter is one of the mandatory parameters for the repmgr daemon. This parameter tells the daemon if it should initiate an automatic failover when a failover situation is detected. It can have either of two values: \u201cmanual\u201d or \u201cautomatic\u201d. We will set this to automatic in each node.<\/p>\n\n\n\n
promote_command<\/h5>\n\n\n\n
This is another mandatory parameter for the repmgr daemon. This parameter tells the repmgr daemon what command it should run to promote a standby. The value of this parameter will be typically the \u201crepmgr standby promote\u201d command, or the path to a shell script that calls the command<\/p>\n\n\n\n
follow_command<\/h5>\n\n\n\n
This is the third mandatory parameter for the repmgr daemon. This parameter tells a standby node to follow the new primary. The repmgr daemon replaces the %n placeholder with the node ID of the new primary at run time.<\/p>\n\n\n\n
monitor_interval_secs<\/h5>\n\n\n\n
This parameter tells the repmgr daemon how often (in number of seconds) it should check the availability of the upstream node. In our case, there is only one upstream node: the primary node. The default value is 2 seconds, but we will explicitly set this anyhow in each node.<\/p>\n\n\n\n
connection_check_type<\/h5>\n\n\n\n
The connection_check_type parameter dictates the protocol repmgr daemon will use to reach out to the upstream node. This parameter can take three values:<\/p>\n\n\n\n
\n- ping<\/strong>: repmgr uses the PQPing() method<\/li>\n\n\n\n
- connection<\/strong>: repmgr tries to create a new connection to the upstream node<\/li>\n\n\n\n
- query<\/strong>: repmgr tries to run a SQL query on the upstream node using the existing connection<\/li>\n<\/ul>\n\n\n\n
Again, we will set this parameter to the default value of ping in each node.<\/p>\n\n\n\n
reconnect_attempts and reconnect_interval<\/h5>\n\n\n\n
When the primary becomes unavailable, the repmgr daemon in the standby nodes will try to reconnect to the primary for reconnect_attempts times. The default value for this parameter is 6. Between each reconnect attempt, it will wait for reconnect_interval seconds, which has a default value of 10. For demonstration purposes, we will use a short interval and fewer reconnect attempts. We set this parameter in every node.<\/p>\n\n\n\n
standby_disconnect_on_failover<\/h5>\n\n\n\n
When the standby_disconnect_on_failover parameter is set to \u201ctrue\u201d in a standby node, the repmgr daemon will ensure its WAL receiver is disconnected from the primary and not receiving any WAL segments. It will also wait for the WAL receivers of other standby nodes to stop before making a failover decision. This parameter should be set to the same value in each node. We are setting this to \u201ctrue\u201d.<\/p>\n\n\n\n
This is a small two node cluster, the next blog wil be extending to multi node cluster and upgrading to PostgreSQL 15.<\/p>\n","protected":false},"excerpt":{"rendered":"
This blog is about a fast, script based, setup of a repmgr two node cluster with auto failover. This setup is very easy and the requirements comparing to a patroni setup very low, for exapmle as open port on the firewall we need only port 5432 which ist the default port of PostgreSQL. At first […]<\/p>\n","protected":false},"author":28,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,198,83],"tags":[2602],"type_dbi":[2749],"class_list":["post-21228","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","category-database-management","category-postgresql","tag-postgresql-2","type-postgresql"],"acf":[],"yoast_head":"\n
Fast setup of a two node repmgr cluster with auto failover - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/fast-setup-of-a-two-node-repmgr-cluster-with-auto-failover\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fast setup of a two node repmgr cluster with auto failover\" \/>\n<meta property=\"og:description\" content=\"This blog is about a fast, script based, setup of a repmgr two node cluster with auto failover. This setup is very easy and the requirements comparing to a patroni setup very low, for exapmle as open port on the firewall we need only port 5432 which ist the default port of PostgreSQL. At first […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/fast-setup-of-a-two-node-repmgr-cluster-with-auto-failover\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2022-12-22T23:09:24+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-11-08T14:31:52+00:00\" \/>\n<meta name=\"author\" content=\"Open source Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Open source Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"32 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/fast-setup-of-a-two-node-repmgr-cluster-with-auto-failover\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/fast-setup-of-a-two-node-repmgr-cluster-with-auto-failover\/\"},\"author\":{\"name\":\"Open source Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/59554f0d99383431eb6ed427e338952b\"},\"headline\":\"Fast setup of a two node repmgr cluster with auto failover\",\"datePublished\":\"2022-12-22T23:09:24+00:00\",\"dateModified\":\"2024-11-08T14:31:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/fast-setup-of-a-two-node-repmgr-cluster-with-auto-failover\/\"},\"wordCount\":778,\"commentCount\":9,\"keywords\":[\"postgresql\"],\"articleSection\":[\"Database Administration & Monitoring\",\"Database management\",\"PostgreSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/fast-setup-of-a-two-node-repmgr-cluster-with-auto-failover\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/fast-setup-of-a-two-node-repmgr-cluster-with-auto-failover\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/fast-setup-of-a-two-node-repmgr-cluster-with-auto-failover\/\",\"name\":\"Fast setup of a two node repmgr cluster with auto failover - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2022-12-22T23:09:24+00:00\",\"dateModified\":\"2024-11-08T14:31:52+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/59554f0d99383431eb6ed427e338952b\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/fast-setup-of-a-two-node-repmgr-cluster-with-auto-failover\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/fast-setup-of-a-two-node-repmgr-cluster-with-auto-failover\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/fast-setup-of-a-two-node-repmgr-cluster-with-auto-failover\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Fast setup of a two node repmgr cluster with auto failover\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/59554f0d99383431eb6ed427e338952b\",\"name\":\"Open source Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/eb4fb12e386e8c41fdef0733e8114594cf2653e4f55e9fa2161442b8eaf3f657?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/eb4fb12e386e8c41fdef0733e8114594cf2653e4f55e9fa2161442b8eaf3f657?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/eb4fb12e386e8c41fdef0733e8114594cf2653e4f55e9fa2161442b8eaf3f657?s=96&d=mm&r=g\",\"caption\":\"Open source Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/open-source-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Fast setup of a two node repmgr cluster with auto failover - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/fast-setup-of-a-two-node-repmgr-cluster-with-auto-failover\/","og_locale":"en_US","og_type":"article","og_title":"Fast setup of a two node repmgr cluster with auto failover","og_description":"This blog is about a fast, script based, setup of a repmgr two node cluster with auto failover. This setup is very easy and the requirements comparing to a patroni setup very low, for exapmle as open port on the firewall we need only port 5432 which ist the default port of PostgreSQL. At first […]","og_url":"https:\/\/www.dbi-services.com\/blog\/fast-setup-of-a-two-node-repmgr-cluster-with-auto-failover\/","og_site_name":"dbi Blog","article_published_time":"2022-12-22T23:09:24+00:00","article_modified_time":"2024-11-08T14:31:52+00:00","author":"Open source Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Open source Team","Est. reading time":"32 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/fast-setup-of-a-two-node-repmgr-cluster-with-auto-failover\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/fast-setup-of-a-two-node-repmgr-cluster-with-auto-failover\/"},"author":{"name":"Open source Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/59554f0d99383431eb6ed427e338952b"},"headline":"Fast setup of a two node repmgr cluster with auto failover","datePublished":"2022-12-22T23:09:24+00:00","dateModified":"2024-11-08T14:31:52+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/fast-setup-of-a-two-node-repmgr-cluster-with-auto-failover\/"},"wordCount":778,"commentCount":9,"keywords":["postgresql"],"articleSection":["Database Administration & Monitoring","Database management","PostgreSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/fast-setup-of-a-two-node-repmgr-cluster-with-auto-failover\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/fast-setup-of-a-two-node-repmgr-cluster-with-auto-failover\/","url":"https:\/\/www.dbi-services.com\/blog\/fast-setup-of-a-two-node-repmgr-cluster-with-auto-failover\/","name":"Fast setup of a two node repmgr cluster with auto failover - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2022-12-22T23:09:24+00:00","dateModified":"2024-11-08T14:31:52+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/59554f0d99383431eb6ed427e338952b"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/fast-setup-of-a-two-node-repmgr-cluster-with-auto-failover\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/fast-setup-of-a-two-node-repmgr-cluster-with-auto-failover\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/fast-setup-of-a-two-node-repmgr-cluster-with-auto-failover\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Fast setup of a two node repmgr cluster with auto failover"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/59554f0d99383431eb6ed427e338952b","name":"Open source Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/eb4fb12e386e8c41fdef0733e8114594cf2653e4f55e9fa2161442b8eaf3f657?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/eb4fb12e386e8c41fdef0733e8114594cf2653e4f55e9fa2161442b8eaf3f657?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/eb4fb12e386e8c41fdef0733e8114594cf2653e4f55e9fa2161442b8eaf3f657?s=96&d=mm&r=g","caption":"Open source Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/open-source-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/21228","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/28"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=21228"}],"version-history":[{"count":11,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/21228\/revisions"}],"predecessor-version":[{"id":21690,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/21228\/revisions\/21690"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=21228"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=21228"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=21228"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=21228"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}