This Blog is a follow up uf one of my older Blogs and my Article at heise.de:<\/p>\n
Blog at dbi-services.com<\/a> For RHEL 8 at its clones like AlmaLinux, CentOS, Oracle Linux and Rocky Linux i have written a shell script to automated recurring setups. The script automates the steps i have described at my article at heise.de.<\/p>\n The script has an help opportunity, -h tell how to use it:<\/p>\n So the script supports any version of PostgreSQL supported by the PostgreSQL Community.<\/p>\n Required is an own volume or folder \/pgdata or even per PostgreSQL version \/pgdata\/Major Releae, so for PostgreSQL 13 \/pgdata\/13\/, if the the folder with the release number is not existing, it will be created.<\/p>\n The code of this script:<\/p>\n OK, lets install PostgreSQL 13 as single server, according to the help information the call is:<\/p>\n Installation is done, service is enabled to start at boot. Lets check the status:<\/p>\n With this script it is possible to operate several PostgreSQL versions at the same time on the same machine. With this concept ist is possible to use pg_upgrade in copy mode and having the older version for a certain time in the background available for checks after upgrade.<\/p>\n In my upcoming blogs i will also provide scripst for scale up and down on memory and cpu parameters according to vCPU and Memory setting, pgpass and replication setup using repmgr.<\/p>\n","protected":false},"excerpt":{"rendered":" This Blog is a follow up uf one of my older Blogs and my Article at heise.de: Blog at dbi-services.com Article at heise.de For RHEL 8 at its clones like AlmaLinux, CentOS, Oracle Linux and Rocky Linux i have written a shell script to automated recurring setups. This is used for a cloud project using […]<\/p>\n","protected":false},"author":28,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[280,73,2602],"type_dbi":[],"class_list":["post-16469","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","tag-database","tag-linux","tag-postgresql-2"],"acf":[],"yoast_head":"\n
\nArticle at heise.de<\/a><\/p>\n
\nThis is used for a cloud project using own virtual machines.<\/p>\n\n$ [[root@rocky ~]$ sh pg_setup.sh -h\n$ [[root@rocky ~]$ PostgreSQL Installation on AlmaLinux 8 \/ CentOS 8 \/ Oracle Linxu 8 \/ RHEL 8 \/ Rocky Linux 8\n$ [[root@rocky ~]$ \n$ [[root@rocky ~]$ Usage:\n$ [[root@rocky ~]$ [OPTION]\n$ [[root@rocky ~]$ \n$ [[root@rocky ~]$ Options:\n$ [[root@rocky ~]$ -v Major Release of Postgresql (required)\n$ [[root@rocky ~]$ -t If the System is Primary \/ Single (p) or Secondary (s) in a Cluster (required)\n$ [[root@rocky ~]$ -h prints this help\n$ [[root@rocky ~]$ \n<\/pre>\n
\n$ [[root@rocky ~]$ ############################################################################################\n$ [[root@rocky ~]$ # Installing PostgreSQL on AlmaLinux 8 \/ CentOS 8 \/ Oracle Linux 8 \/ RHEL 8 \/Rocky Linux 8 #\n$ [[root@rocky ~]$ # including opening port 5432 #\n$ [[root@rocky ~]$ # By Karsten Lenz dbi-services sa 2020.06.16 #\n$ [[root@rocky ~]$ ############################################################################################\n$ [[root@rocky ~]$\n$ [[root@rocky ~]$ #!\/bin\/bash\n$ [[root@rocky ~]$\n$ [[root@rocky ~]$ echo \"PostgreSQL Installation on AlmaLinux 8 \/ CentOS 8 \/ Oracle Linxu 8 \/ RHEL 8 \/ Rocky Linux 8\"\n$ [[root@rocky ~]$ echo \"\"\n$ [[root@rocky ~]$\n$ [[root@rocky ~]$ function printHelp() {\n$ [[root@rocky ~]$ printf \"Usage:n\"\n$ [[root@rocky ~]$ printf \"${progName} [OPTION]nn\"\n$ [[root@rocky ~]$ printf \"Options:n\"\n$ [[root@rocky ~]$ printf \"t -v ttMajor Release of Postgresql (required)n\"\n$ [[root@rocky ~]$ printf \"t -t ttIf the System is Primary \/ Single (p) or Secondary (s) in a Cluster (required)n\"\n$ [[root@rocky ~]$ printf \"t -h ttttprints this helpn\"\n$ [[root@rocky ~]$ }\n$ [[root@rocky ~]$\n$ [[root@rocky ~]$ while getopts v:t:h option 2>\/dev\/null\n$ [[root@rocky ~]$ do\n$ [[root@rocky ~]$ case \"${option}\"\n$ [[root@rocky ~]$ in\n$ [[root@rocky ~]$ v) VERSION=${OPTARG};;\n$ [[root@rocky ~]$ t) TYPE=${OPTARG};;\n$ [[root@rocky ~]$ h) printHelp; exit 2;;\n$ [[root@rocky ~]$ *) printf \"Unsupported option or parameter value missing '$*'n\";\n$ [[root@rocky ~]$ printf \"Run ${progName} -h to print helpn\"; exit 1;;\n$ [[root@rocky ~]$ esac\n$ [[root@rocky ~]$ done\n$ [[root@rocky ~]$\n$ [[root@rocky ~]$ echo \"Disabling PostgreSQL Packages provided by the Distros\"\n$ [[root@rocky ~]$ dnf -y module disable postgresql\n$ [[root@rocky ~]$ \n$ [[root@rocky ~]$ echo \"Adding PostgreSQL Repository\"\n$ [[root@rocky ~]$ dnf -y install https:\/\/download.postgresql.org\/pub\/repos\/yum\/reporpms\/EL-8-x86_64\/pgdg-redhat-repo-latest.noarch.rpm\n$ [[root@rocky ~]$ \n$ [[root@rocky ~]$ echo \"Installing PostgreSQL Packages including barman, repmgr and pg_stat_kcache\"\n$ [[root@rocky ~]$ dnf -y install postgresql$VERSION postgresql$VERSION-libs postgresql$VERSION-server postgresql$VERSION-contrib pg_stat_kcache$VERSION repmgr$VERSION barman\n$ [[root@rocky ~]$ \n$ [[root@rocky ~]$ # creating empty override.conf for postgresql service\n$ [[root@rocky ~]$ mkdir \/etc\/systemd\/system\/postgresql-$VERSION.service.d\n$ [[root@rocky ~]$\n$ [[root@rocky ~]$ # define vriable for tee\n$ [[root@rocky ~]$ OVERRIDE_CONF=\/etc\/systemd\/system\/postgresql-$VERSION.service.d\/override.conf\n$ [[root@rocky ~]$ touch $OVERRIDE_CONF\n$ [[root@rocky ~]$\n$ [[root@rocky ~]$ # adding values to override.conf\n$ [[root@rocky ~]$ echo \"[Service]\" | tee -a $OVERRIDE_CONF\n$ [[root@rocky ~]$ echo \"Environment=PGDATA=\/pgdata\/$VERSION\/data\" | tee -a $OVERRIDE_CONF\n$ [[root@rocky ~]$\n$ [[root@rocky ~]$\n$ [[root@rocky ~]$ # different steps for single\/primary or standby\n$ [[root@rocky ~]$ if [ $TYPE == 'p' ]\n$ [[root@rocky ~]$ then\n$ [[root@rocky ~]$ echo \"Initialyze PostgreSQL $VERSION\"\n$ [[root@rocky ~]$ \/usr\/pgsql-$VERSION\/bin\/postgresql-$VERSION-setup initdb\n$ [[root@rocky ~]$ \n$ [[root@rocky ~]$ echo \"Enable PostgreSQL Service\"\n$ [[root@rocky ~]$ systemctl enable postgresql-$VERSION.service\n$ [[root@rocky ~]$\n$ [[root@rocky ~]$ echo \"Start PostgreSQL $VERSION\"\n$ [[root@rocky ~]$ systemctl start postgresql-$VERSION.service\n$ [[root@rocky ~]$\n$ [[root@rocky ~]$ elif [ $TYPE == 's' ]\n$ [[root@rocky ~]$ then\n$ [[root@rocky ~]$ echo \"Initialyze PostgreSQL $VERSION\"\n$ [[root@rocky ~]$ \/usr\/pgsql-$VERSION\/bin\/postgresql-$VERSION-setup initdb\n$ [[root@rocky ~]$ \n$ [[root@rocky ~]$ echo \"Enable PostgreSQL Service\"\n$ [[root@rocky ~]$ systemctl enable postgresql-$VERSION.service\n$ [[root@rocky ~]$ fi\n$ [[root@rocky ~]$ \n$ [[root@rocky ~]$ # open port 5432 for PostgreSQL\n$ [[root@rocky ~]$ firewall-cmd --zone=public --permanent --add-port 5432\/tcp\n$ [[root@rocky ~]$ firewall-cmd --reload\n<\/pre>\n\n$ [[root@rocky ~]$ sh pg_setup.sh -v 13 -t s\nPostgreSQL Installation on AlmaLinux 8 \/ CentOS 8 \/ Oracle Linxu 8 \/ RHEL 8 \/ Rocky Linux 8\n\nDisabling PostgreSQL Packages provided by the Distros\nLast metadata expiration check: 0:12:33 ago on Tue 15 Jun 2021 11:33:01 AM CEST.\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: 0:12:34 ago on Tue 15 Jun 2021 11:33:01 AM CEST.\npgdg-redhat-repo-latest.noarch.rpm 8.6 kB\/s | 12 kB 00:01\nDependencies resolved.\n==========================================================================================================================================================================================================================================================================================\n Package Architecture Version Repository Size\n==========================================================================================================================================================================================================================================================================================\nInstalling:\n pgdg-redhat-repo noarch 42.0-17 @commandline 12 k\n\nTransaction Summary\n==========================================================================================================================================================================================================================================================================================\nInstall 1 Package\n\nTotal size: 12 k\nInstalled size: 11 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-17.noarch 1\/1\n Verifying : pgdg-redhat-repo-42.0-17.noarch 1\/1\n\nInstalled:\n pgdg-redhat-repo-42.0-17.noarch\n\nComplete!\nInstalling PostgreSQL Packages including barman, repmgr and pg_stat_kcache\nPostgreSQL common RPMs for RHEL\/CentOS 8 - x86_64 103 B\/s | 195 B 00:01\nPostgreSQL common RPMs for RHEL\/CentOS 8 - x86_64 1.6 MB\/s | 1.7 kB 00:00\nImporting GPG key 0x442DF0F8:\n Userid : \"PostgreSQL RPM Building Project \"\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\/CentOS 8 - x86_64 152 kB\/s | 480 kB 00:03\nPostgreSQL 13 for RHEL\/CentOS 8 - x86_64 122 B\/s | 195 B 00:01\nPostgreSQL 13 for RHEL\/CentOS 8 - x86_64 1.6 MB\/s | 1.7 kB 00:00\nImporting GPG key 0x442DF0F8:\n Userid : \"PostgreSQL RPM Building Project \"\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\/CentOS 8 - x86_64 130 kB\/s | 359 kB 00:02\nPostgreSQL 12 for RHEL\/CentOS 8 - x86_64 136 B\/s | 195 B 00:01\nPostgreSQL 12 for RHEL\/CentOS 8 - x86_64 1.6 MB\/s | 1.7 kB 00:00\nImporting GPG key 0x442DF0F8:\n Userid : \"PostgreSQL RPM Building Project \"\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\/CentOS 8 - x86_64 166 kB\/s | 550 kB 00:03\nPostgreSQL 11 for RHEL\/CentOS 8 - x86_64 106 B\/s | 195 B 00:01\nPostgreSQL 11 for RHEL\/CentOS 8 - x86_64 1.6 MB\/s | 1.7 kB 00:00\nImporting GPG key 0x442DF0F8:\n Userid : \"PostgreSQL RPM Building Project \"\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\/CentOS 8 - x86_64 212 kB\/s | 747 kB 00:03\nPostgreSQL 10 for RHEL\/CentOS 8 - x86_64 103 B\/s | 195 B 00:01\nPostgreSQL 10 for RHEL\/CentOS 8 - x86_64 1.6 MB\/s | 1.7 kB 00:00\nImporting GPG key 0x442DF0F8:\n Userid : \"PostgreSQL RPM Building Project \"\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\/CentOS 8 - x86_64 143 kB\/s | 482 kB 00:03\nPostgreSQL 9.6 for RHEL\/CentOS 8 - x86_64 121 B\/s | 195 B 00:01\nPostgreSQL 9.6 for RHEL\/CentOS 8 - x86_64 1.6 MB\/s | 1.7 kB 00:00\nImporting GPG key 0x442DF0F8:\n Userid : \"PostgreSQL RPM Building Project \"\n Fingerprint: 68C9 E2B9 1A37 D136 FE74 D176 1F16 D2E1 442D F0F8\n From : \/etc\/pki\/rpm-gpg\/RPM-GPG-KEY-PGDG\nPostgreSQL 9.6 for RHEL\/CentOS 8 - x86_64 174 kB\/s | 490 kB 00:02\nDependencies resolved.\n==========================================================================================================================================================================================================================================================================================\n Package Architecture Version Repository Size\n==========================================================================================================================================================================================================================================================================================\nInstalling:\n barman noarch 2.12-1.rhel8 pgdg-common 41 k\n pg_stat_kcache_13 x86_64 2.2.0-1.rhel8 pgdg13 46 k\n postgresql13 x86_64 13.3-2PGDG.rhel8 pgdg13 1.5 M\n postgresql13-contrib x86_64 13.3-2PGDG.rhel8 pgdg13 638 k\n postgresql13-libs x86_64 13.3-2PGDG.rhel8 pgdg13 413 k\n postgresql13-server x86_64 13.3-2PGDG.rhel8 pgdg13 5.5 M\n repmgr_13 x86_64 5.2.1-1.rhel8 pgdg13 293 k\nInstalling dependencies:\n perl-Carp noarch 1.42-396.el8 baseos 29 k\n perl-Data-Dumper x86_64 2.167-399.el8 baseos 57 k\n perl-Digest noarch 1.17-395.el8 appstream 26 k\n perl-Digest-MD5 x86_64 2.55-396.el8 appstream 36 k\n perl-Encode x86_64 4:2.97-3.el8 baseos 1.5 M\n perl-Errno x86_64 1.28-419.el8 baseos 75 k\n perl-Exporter noarch 5.72-396.el8 baseos 33 k\n perl-File-Path noarch 2.15-2.el8 baseos 37 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 62 k\n perl-HTTP-Tiny noarch 0.074-1.el8 baseos 57 k\n perl-IO x86_64 1.38-419.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-1.module+el8.4.0+512+d4f0fc54 appstream 378 k\n perl-PathTools x86_64 3.74-1.el8 baseos 89 k\n perl-Pod-Escapes noarch 1:1.07-395.el8 baseos 19 k\n perl-Pod-Perldoc noarch 3.28-396.el8 baseos 85 k\n perl-Pod-Simple noarch 1:3.35-395.el8 baseos 212 k\n perl-Pod-Usage noarch 4:1.69-395.el8 baseos 33 k\n perl-Scalar-List-Utils x86_64 3:1.49-2.el8 baseos 67 k\n perl-Socket x86_64 4:2.027-3.el8 baseos 58 k\n perl-Storable x86_64 1:3.11-3.el8 baseos 97 k\n perl-Term-ANSIColor noarch 4.06-396.el8 baseos 45 k\n perl-Term-Cap noarch 1.17-395.el8 baseos 22 k\n perl-Text-ParseWords noarch 3.30-395.el8 baseos 17 k\n perl-Text-Tabs+Wrap noarch 2013.0523-395.el8 baseos 23 k\n perl-Time-Local noarch 1:1.280-1.el8 baseos 32 k\n perl-URI noarch 1.73-3.el8 appstream 115 k\n perl-Unicode-Normalize x86_64 1.25-396.el8 baseos 81 k\n perl-constant noarch 1.33-396.el8 baseos 24 k\n perl-interpreter x86_64 4:5.26.3-419.el8 baseos 6.3 M\n perl-libnet noarch 3.11-3.el8 appstream 120 k\n perl-libs x86_64 4:5.26.3-419.el8 baseos 1.6 M\n perl-macros x86_64 4:5.26.3-419.el8 baseos 71 k\n perl-parent noarch 1:0.237-1.el8 baseos 19 k\n perl-podlators noarch 4.11-1.el8 baseos 117 k\n perl-threads x86_64 1:2.21-2.el8 baseos 60 k\n perl-threads-shared x86_64 1.58-2.el8 baseos 47 k\n python3-argcomplete noarch 1.9.3-6.el8 appstream 59 k\n python3-argh noarch 0.26.1-8.el8 appstream 58 k\n python3-barman noarch 2.12-1.rhel8 pgdg-common 358 k\n python3-pip noarch 9.0.3-19.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-2.module+el8.3.0+120+426d8baf appstream 18 k\nInstalling weak dependencies:\n perl-IO-Socket-IP noarch 0.39-5.el8 appstream 46 k\n perl-IO-Socket-SSL noarch 2.066-4.module+el8.4.0+512+d4f0fc54 appstream 297 k\n perl-Mozilla-CA noarch 20160104-7.module+el8.4.0+529+e3b3e624 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 55 Packages\n\nTotal download size: 21 M\nInstalled size: 73 M\nDownloading Packages:\n(1\/55): perl-Digest-1.17-395.el8.noarch.rpm 17 kB\/s | 26 kB 00:01\n(2\/55): perl-Digest-MD5-2.55-396.el8.x86_64.rpm 24 kB\/s | 36 kB 00:01\n(3\/55): perl-IO-Socket-IP-0.39-5.el8.noarch.rpm 28 kB\/s | 46 kB 00:01\n(4\/55): perl-Mozilla-CA-20160104-7.module+el8.4.0+529+e3b3e624.noarch.rpm 105 kB\/s | 14 kB 00:00\n(5\/55): perl-URI-1.73-3.el8.noarch.rpm 424 kB\/s | 115 kB 00:00\n(6\/55): perl-libnet-3.11-3.el8.noarch.rpm 851 kB\/s | 120 kB 00:00\n(7\/55): perl-Net-SSLeay-1.88-1.module+el8.4.0+512+d4f0fc54.x86_64.rpm 858 kB\/s | 378 kB 00:00\n(8\/55): perl-IO-Socket-SSL-2.066-4.module+el8.4.0+512+d4f0fc54.noarch.rpm 508 kB\/s | 297 kB 00:00\n(9\/55): python3-argcomplete-1.9.3-6.el8.noarch.rpm 425 kB\/s | 59 kB 00:00\n(10\/55): python3-argh-0.26.1-8.el8.noarch.rpm 403 kB\/s | 58 kB 00:00\n(11\/55): python3-pip-9.0.3-19.el8.noarch.rpm 128 kB\/s | 19 kB 00:00\n(12\/55): python36-3.6.8-2.module+el8.3.0+120+426d8baf.x86_64.rpm 124 kB\/s | 18 kB 00:00\n(13\/55): perl-Data-Dumper-2.167-399.el8.x86_64.rpm 299 kB\/s | 57 kB 00:00\n(14\/55): perl-Carp-1.42-396.el8.noarch.rpm 144 kB\/s | 29 kB 00:00\n(15\/55): perl-Errno-1.28-419.el8.x86_64.rpm 1.0 MB\/s | 75 kB 00:00\n(16\/55): perl-Exporter-5.72-396.el8.noarch.rpm 449 kB\/s | 33 kB 00:00\n(17\/55): perl-File-Path-2.15-2.el8.noarch.rpm 973 kB\/s | 37 kB 00:00\n(18\/55): perl-File-Temp-0.230.600-1.el8.noarch.rpm 820 kB\/s | 62 kB 00:00\n(19\/55): perl-Getopt-Long-2.50-4.el8.noarch.rpm 1.5 MB\/s | 62 kB 00:00\n(20\/55): perl-HTTP-Tiny-0.074-1.el8.noarch.rpm 1.4 MB\/s | 57 kB 00:00\n(21\/55): perl-IO-1.38-419.el8.x86_64.rpm 2.0 MB\/s | 141 kB 00:00\n(22\/55): perl-MIME-Base64-3.15-396.el8.x86_64.rpm 671 kB\/s | 30 kB 00:00\n(23\/55): perl-PathTools-3.74-1.el8.x86_64.rpm 2.9 MB\/s | 89 kB 00:00\n(24\/55): perl-Encode-2.97-3.el8.x86_64.rpm 4.3 MB\/s | 1.5 MB 00:00\n(25\/55): perl-Pod-Escapes-1.07-395.el8.noarch.rpm 555 kB\/s | 19 kB 00:00\n(26\/55): perl-Pod-Perldoc-3.28-396.el8.noarch.rpm 2.2 MB\/s | 85 kB 00:00\n(27\/55): perl-Pod-Simple-3.35-395.el8.noarch.rpm 5.4 MB\/s | 212 kB 00:00\n(28\/55): perl-Pod-Usage-1.69-395.el8.noarch.rpm 900 kB\/s | 33 kB 00:00\n(29\/55): perl-Scalar-List-Utils-1.49-2.el8.x86_64.rpm 1.8 MB\/s | 67 kB 00:00\n(30\/55): perl-Socket-2.027-3.el8.x86_64.rpm 1.6 MB\/s | 58 kB 00:00\n(31\/55): perl-Term-ANSIColor-4.06-396.el8.noarch.rpm 1.2 MB\/s | 45 kB 00:00\n(32\/55): perl-Term-Cap-1.17-395.el8.noarch.rpm 615 kB\/s | 22 kB 00:00\n(33\/55): perl-Storable-3.11-3.el8.x86_64.rpm 1.3 MB\/s | 97 kB 00:00\n(34\/55): perl-Text-ParseWords-3.30-395.el8.noarch.rpm 463 kB\/s | 17 kB 00:00\n(35\/55): perl-Time-Local-1.280-1.el8.noarch.rpm 863 kB\/s | 32 kB 00:00\n(36\/55): perl-Text-Tabs+Wrap-2013.0523-395.el8.noarch.rpm 583 kB\/s | 23 kB 00:00\n(37\/55): perl-Unicode-Normalize-1.25-396.el8.x86_64.rpm 2.1 MB\/s | 81 kB 00:00\n(38\/55): perl-constant-1.33-396.el8.noarch.rpm 601 kB\/s | 24 kB 00:00\n(39\/55): perl-macros-5.26.3-419.el8.x86_64.rpm 1.8 MB\/s | 71 kB 00:00\n(40\/55): perl-parent-0.237-1.el8.noarch.rpm 556 kB\/s | 19 kB 00:00\n(41\/55): perl-podlators-4.11-1.el8.noarch.rpm 2.9 MB\/s | 117 kB 00:00\n(42\/55): perl-threads-2.21-2.el8.x86_64.rpm 1.5 MB\/s | 60 kB 00:00\n(43\/55): perl-threads-shared-1.58-2.el8.x86_64.rpm 1.2 MB\/s | 47 kB 00:00\n(44\/55): python3-setuptools-39.2.0-6.el8.noarch.rpm 4.0 MB\/s | 162 kB 00:00\n(45\/55): perl-libs-5.26.3-419.el8.x86_64.rpm 4.1 MB\/s | 1.6 MB 00:00\n(46\/55): barman-2.12-1.rhel8.noarch.rpm 45 kB\/s | 41 kB 00:00\n(47\/55): python3-psycopg2-2.8.6-1.rhel8.x86_64.rpm 426 kB\/s | 178 kB 00:00\n(48\/55): python3-barman-2.12-1.rhel8.noarch.rpm 285 kB\/s | 358 kB 00:01\n(49\/55): pg_stat_kcache_13-2.2.0-1.rhel8.x86_64.rpm 314 kB\/s | 46 kB 00:00\n(50\/55): perl-interpreter-5.26.3-419.el8.x86_64.rpm 3.0 MB\/s | 6.3 MB 00:02\n(51\/55): postgresql13-contrib-13.3-2PGDG.rhel8.x86_64.rpm 1.5 MB\/s | 638 kB 00:00\n(52\/55): postgresql13-13.3-2PGDG.rhel8.x86_64.rpm 2.6 MB\/s | 1.5 MB 00:00\n(53\/55): repmgr_13-5.2.1-1.rhel8.x86_64.rpm 2.0 MB\/s | 293 kB 00:00\n(54\/55): postgresql13-server-13.3-2PGDG.rhel8.x86_64.rpm 9.1 MB\/s | 5.5 MB 00:00\n(55\/55): postgresql13-libs-13.3-2PGDG.rhel8.x86_64.rpm 264 kB\/s | 413 kB 00:01\n------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------\nTotal 3.0 MB\/s | 21 MB 00:06\nwarning: \/var\/cache\/dnf\/pgdg-common-38b6c5045045f841\/packages\/barman-2.12-1.rhel8.noarch.rpm: Header V4 DSA\/SHA1 Signature, key ID 442df0f8: NOKEY\nPostgreSQL common RPMs for RHEL\/CentOS 8 - x86_64 1.6 MB\/s | 1.7 kB 00:00\nImporting GPG key 0x442DF0F8:\n Userid : \"PostgreSQL RPM Building Project \"\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 : postgresql13-libs-13.3-2PGDG.rhel8.x86_64 1\/55\n Running scriptlet: postgresql13-libs-13.3-2PGDG.rhel8.x86_64 1\/55\n Installing : postgresql13-13.3-2PGDG.rhel8.x86_64 2\/55\n Running scriptlet: postgresql13-13.3-2PGDG.rhel8.x86_64 2\/55\n Running scriptlet: postgresql13-server-13.3-2PGDG.rhel8.x86_64 3\/55\n Installing : postgresql13-server-13.3-2PGDG.rhel8.x86_64 3\/55\n Running scriptlet: postgresql13-server-13.3-2PGDG.rhel8.x86_64 3\/55\n Installing : python3-setuptools-39.2.0-6.el8.noarch 4\/55\n Installing : python36-3.6.8-2.module+el8.3.0+120+426d8baf.x86_64 5\/55\n Running scriptlet: python36-3.6.8-2.module+el8.3.0+120+426d8baf.x86_64 5\/55\n Installing : python3-pip-9.0.3-19.el8.noarch 6\/55\n Installing : python3-psycopg2-2.8.6-1.rhel8.x86_64 7\/55\n Installing : perl-Digest-1.17-395.el8.noarch 8\/55\n Installing : perl-Digest-MD5-2.55-396.el8.x86_64 9\/55\n Installing : perl-Data-Dumper-2.167-399.el8.x86_64 10\/55\n Installing : perl-libnet-3.11-3.el8.noarch 11\/55\n Installing : perl-Net-SSLeay-1.88-1.module+el8.4.0+512+d4f0fc54.x86_64 12\/55\n Installing : perl-URI-1.73-3.el8.noarch 13\/55\n Installing : perl-Pod-Escapes-1:1.07-395.el8.noarch 14\/55\n Installing : perl-Mozilla-CA-20160104-7.module+el8.4.0+529+e3b3e624.noarch 15\/55\n Installing : perl-IO-Socket-IP-0.39-5.el8.noarch 16\/55\n Installing : perl-Time-Local-1:1.280-1.el8.noarch 17\/55\n Installing : perl-IO-Socket-SSL-2.066-4.module+el8.4.0+512+d4f0fc54.noarch 18\/55\n Installing : perl-Term-ANSIColor-4.06-396.el8.noarch 19\/55\n Installing : perl-Term-Cap-1.17-395.el8.noarch 20\/55\n Installing : perl-File-Temp-0.230.600-1.el8.noarch 21\/55\n Installing : perl-Pod-Simple-1:3.35-395.el8.noarch 22\/55\n Installing : perl-HTTP-Tiny-0.074-1.el8.noarch 23\/55\n Installing : perl-podlators-4.11-1.el8.noarch 24\/55\n Installing : perl-Pod-Perldoc-3.28-396.el8.noarch 25\/55\n Installing : perl-Text-ParseWords-3.30-395.el8.noarch 26\/55\n Installing : perl-Pod-Usage-4:1.69-395.el8.noarch 27\/55\n Installing : perl-MIME-Base64-3.15-396.el8.x86_64 28\/55\n Installing : perl-Storable-1:3.11-3.el8.x86_64 29\/55\n Installing : perl-Getopt-Long-1:2.50-4.el8.noarch 30\/55\n Installing : perl-Errno-1.28-419.el8.x86_64 31\/55\n Installing : perl-Socket-4:2.027-3.el8.x86_64 32\/55\n Installing : perl-Encode-4:2.97-3.el8.x86_64 33\/55\n Installing : perl-Carp-1.42-396.el8.noarch 34\/55\n Installing : perl-Exporter-5.72-396.el8.noarch 35\/55\n Installing : perl-libs-4:5.26.3-419.el8.x86_64 36\/55\n Installing : perl-Scalar-List-Utils-3:1.49-2.el8.x86_64 37\/55\n Installing : perl-parent-1:0.237-1.el8.noarch 38\/55\n Installing : perl-macros-4:5.26.3-419.el8.x86_64 39\/55\n Installing : perl-Text-Tabs+Wrap-2013.0523-395.el8.noarch 40\/55\n Installing : perl-Unicode-Normalize-1.25-396.el8.x86_64 41\/55\n Installing : perl-File-Path-2.15-2.el8.noarch 42\/55\n Installing : perl-IO-1.38-419.el8.x86_64 43\/55\n Installing : perl-PathTools-3.74-1.el8.x86_64 44\/55\n Installing : perl-constant-1.33-396.el8.noarch 45\/55\n Installing : perl-threads-1:2.21-2.el8.x86_64 46\/55\n Installing : perl-threads-shared-1.58-2.el8.x86_64 47\/55\n Installing : perl-interpreter-4:5.26.3-419.el8.x86_64 48\/55\n Installing : python3-argh-0.26.1-8.el8.noarch 49\/55\n Installing : python3-argcomplete-1.9.3-6.el8.noarch 50\/55\n Installing : python3-barman-2.12-1.rhel8.noarch 51\/55\n Running scriptlet: barman-2.12-1.rhel8.noarch 52\/55\n Installing : barman-2.12-1.rhel8.noarch 52\/55\n Installing : postgresql13-contrib-13.3-2PGDG.rhel8.x86_64 53\/55\n Installing : pg_stat_kcache_13-2.2.0-1.rhel8.x86_64 54\/55\n Running scriptlet: pg_stat_kcache_13-2.2.0-1.rhel8.x86_64 54\/55\n Running scriptlet: repmgr_13-5.2.1-1.rhel8.x86_64 55\/55\n Installing : repmgr_13-5.2.1-1.rhel8.x86_64 55\/55\n Running scriptlet: repmgr_13-5.2.1-1.rhel8.x86_64 55\/55\n Verifying : perl-Digest-1.17-395.el8.noarch 1\/55\n Verifying : perl-Digest-MD5-2.55-396.el8.x86_64 2\/55\n Verifying : perl-IO-Socket-IP-0.39-5.el8.noarch 3\/55\n Verifying : perl-IO-Socket-SSL-2.066-4.module+el8.4.0+512+d4f0fc54.noarch 4\/55\n Verifying : perl-Mozilla-CA-20160104-7.module+el8.4.0+529+e3b3e624.noarch 5\/55\n Verifying : perl-Net-SSLeay-1.88-1.module+el8.4.0+512+d4f0fc54.x86_64 6\/55\n Verifying : perl-URI-1.73-3.el8.noarch 7\/55\n Verifying : perl-libnet-3.11-3.el8.noarch 8\/55\n Verifying : python3-argcomplete-1.9.3-6.el8.noarch 9\/55\n Verifying : python3-argh-0.26.1-8.el8.noarch 10\/55\n Verifying : python3-pip-9.0.3-19.el8.noarch 11\/55\n Verifying : python36-3.6.8-2.module+el8.3.0+120+426d8baf.x86_64 12\/55\n Verifying : perl-Carp-1.42-396.el8.noarch 13\/55\n Verifying : perl-Data-Dumper-2.167-399.el8.x86_64 14\/55\n Verifying : perl-Encode-4:2.97-3.el8.x86_64 15\/55\n Verifying : perl-Errno-1.28-419.el8.x86_64 16\/55\n Verifying : perl-Exporter-5.72-396.el8.noarch 17\/55\n Verifying : perl-File-Path-2.15-2.el8.noarch 18\/55\n Verifying : perl-File-Temp-0.230.600-1.el8.noarch 19\/55\n Verifying : perl-Getopt-Long-1:2.50-4.el8.noarch 20\/55\n Verifying : perl-HTTP-Tiny-0.074-1.el8.noarch 21\/55\n Verifying : perl-IO-1.38-419.el8.x86_64 22\/55\n Verifying : perl-MIME-Base64-3.15-396.el8.x86_64 23\/55\n Verifying : perl-PathTools-3.74-1.el8.x86_64 24\/55\n Verifying : perl-Pod-Escapes-1:1.07-395.el8.noarch 25\/55\n Verifying : perl-Pod-Perldoc-3.28-396.el8.noarch 26\/55\n Verifying : perl-Pod-Simple-1:3.35-395.el8.noarch 27\/55\n Verifying : perl-Pod-Usage-4:1.69-395.el8.noarch 28\/55\n Verifying : perl-Scalar-List-Utils-3:1.49-2.el8.x86_64 29\/55\n Verifying : perl-Socket-4:2.027-3.el8.x86_64 30\/55\n Verifying : perl-Storable-1:3.11-3.el8.x86_64 31\/55\n Verifying : perl-Term-ANSIColor-4.06-396.el8.noarch 32\/55\n Verifying : perl-Term-Cap-1.17-395.el8.noarch 33\/55\n Verifying : perl-Text-ParseWords-3.30-395.el8.noarch 34\/55\n Verifying : perl-Text-Tabs+Wrap-2013.0523-395.el8.noarch 35\/55\n Verifying : perl-Time-Local-1:1.280-1.el8.noarch 36\/55\n Verifying : perl-Unicode-Normalize-1.25-396.el8.x86_64 37\/55\n Verifying : perl-constant-1.33-396.el8.noarch 38\/55\n Verifying : perl-interpreter-4:5.26.3-419.el8.x86_64 39\/55\n Verifying : perl-libs-4:5.26.3-419.el8.x86_64 40\/55\n Verifying : perl-macros-4:5.26.3-419.el8.x86_64 41\/55\n Verifying : perl-parent-1:0.237-1.el8.noarch 42\/55\n Verifying : perl-podlators-4.11-1.el8.noarch 43\/55\n Verifying : perl-threads-1:2.21-2.el8.x86_64 44\/55\n Verifying : perl-threads-shared-1.58-2.el8.x86_64 45\/55\n Verifying : python3-setuptools-39.2.0-6.el8.noarch 46\/55\n Verifying : barman-2.12-1.rhel8.noarch 47\/55\n Verifying : python3-barman-2.12-1.rhel8.noarch 48\/55\n Verifying : python3-psycopg2-2.8.6-1.rhel8.x86_64 49\/55\n Verifying : pg_stat_kcache_13-2.2.0-1.rhel8.x86_64 50\/55\n Verifying : postgresql13-13.3-2PGDG.rhel8.x86_64 51\/55\n Verifying : postgresql13-contrib-13.3-2PGDG.rhel8.x86_64 52\/55\n Verifying : postgresql13-libs-13.3-2PGDG.rhel8.x86_64 53\/55\n Verifying : postgresql13-server-13.3-2PGDG.rhel8.x86_64 54\/55\n Verifying : repmgr_13-5.2.1-1.rhel8.x86_64 55\/55\n\nInstalled:\n barman-2.12-1.rhel8.noarch perl-Carp-1.42-396.el8.noarch perl-Data-Dumper-2.167-399.el8.x86_64 perl-Digest-1.17-395.el8.noarch perl-Digest-MD5-2.55-396.el8.x86_64\n perl-Encode-4:2.97-3.el8.x86_64 perl-Errno-1.28-419.el8.x86_64 perl-Exporter-5.72-396.el8.noarch perl-File-Path-2.15-2.el8.noarch perl-File-Temp-0.230.600-1.el8.noarch\n perl-Getopt-Long-1:2.50-4.el8.noarch perl-HTTP-Tiny-0.074-1.el8.noarch perl-IO-1.38-419.el8.x86_64 perl-IO-Socket-IP-0.39-5.el8.noarch perl-IO-Socket-SSL-2.066-4.module+el8.4.0+512+d4f0fc54.noarch\n perl-MIME-Base64-3.15-396.el8.x86_64 perl-Mozilla-CA-20160104-7.module+el8.4.0+529+e3b3e624.noarch perl-Net-SSLeay-1.88-1.module+el8.4.0+512+d4f0fc54.x86_64 perl-PathTools-3.74-1.el8.x86_64 perl-Pod-Escapes-1:1.07-395.el8.noarch\n 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 perl-Scalar-List-Utils-3:1.49-2.el8.x86_64 perl-Socket-4:2.027-3.el8.x86_64\n 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 perl-Text-ParseWords-3.30-395.el8.noarch perl-Text-Tabs+Wrap-2013.0523-395.el8.noarch\n 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 perl-constant-1.33-396.el8.noarch perl-interpreter-4:5.26.3-419.el8.x86_64\n perl-libnet-3.11-3.el8.noarch perl-libs-4:5.26.3-419.el8.x86_64 perl-macros-4:5.26.3-419.el8.x86_64 perl-parent-1:0.237-1.el8.noarch perl-podlators-4.11-1.el8.noarch\n perl-threads-1:2.21-2.el8.x86_64 perl-threads-shared-1.58-2.el8.x86_64 pg_stat_kcache_13-2.2.0-1.rhel8.x86_64 postgresql13-13.3-2PGDG.rhel8.x86_64 postgresql13-contrib-13.3-2PGDG.rhel8.x86_64\n postgresql13-libs-13.3-2PGDG.rhel8.x86_64 postgresql13-server-13.3-2PGDG.rhel8.x86_64 python3-argcomplete-1.9.3-6.el8.noarch python3-argh-0.26.1-8.el8.noarch python3-barman-2.12-1.rhel8.noarch\n python3-pip-9.0.3-19.el8.noarch python3-psycopg2-2.8.6-1.rhel8.x86_64 python3-setuptools-39.2.0-6.el8.noarch python36-3.6.8-2.module+el8.3.0+120+426d8baf.x86_64 repmgr_13-5.2.1-1.rhel8.x86_64\n\nComplete!\n[Service]\nEnvironment=PGDATA=\/pgdata\/13\/data\nInitialyze PostgreSQL 13\nInitializing database ... OK\n\nEnable PostgreSQL Service\nCreated symlink \/etc\/systemd\/system\/multi-user.target.wants\/postgresql-13.service \u2192 \/usr\/lib\/systemd\/system\/postgresql-13.service.\nsuccess\nsuccess\n$ [[root@rocky ~]$\n<\/pre>\n
\nLets start PostgreSQL 13 now:<\/p>\n\n$ [[root@rocky ~]$ systemctl start postgresql-13.service\n<\/pre>\n
\n$ [[root@rocky ~]$ systemctl status postgresql-13.service\n$ [[root@rocky ~]$ \u25cf postgresql-13.service - PostgreSQL 13 database server\n$ [[root@rocky ~]$ Loaded: loaded (\/usr\/lib\/systemd\/system\/postgresql-13.service; enabled; vendor preset: disabled)\n$ [[root@rocky ~]$ Drop-In: \/etc\/systemd\/system\/postgresql-13.service.d\n$ [[root@rocky ~]$ \u2514\u2500override.conf\n$ [[root@rocky ~]$ Active: active (running) since Tue 2021-06-15 11:53:46 CEST; 7s ago\n$ [[root@rocky ~]$ Docs: https:\/\/www.postgresql.org\/docs\/13\/static\/\n$ [[root@rocky ~]$ Process: 4443 ExecStartPre=\/usr\/pgsql-13\/bin\/postgresql-13-check-db-dir ${PGDATA} (code=exited, status=0\/SUCCESS)\n$ [[root@rocky ~]$ Main PID: 4449 (postmaster)\n$ [[root@rocky ~]$ Tasks: 8 (limit: 50551)\n$ [[root@rocky ~]$ Memory: 16.8M\n$ [[root@rocky ~]$ CGroup: \/system.slice\/postgresql-13.service\n$ [[root@rocky ~]$ \u251c\u25004449 \/usr\/pgsql-13\/bin\/postmaster -D \/pgdata\/13\/data\n$ [[root@rocky ~]$ \u251c\u25004450 postgres: logger\n$ [[root@rocky ~]$ \u251c\u25004452 postgres: checkpointer\n$ [[root@rocky ~]$ \u251c\u25004453 postgres: background writer\n$ [[root@rocky ~]$ \u251c\u25004454 postgres: walwriter\n$ [[root@rocky ~]$ \u251c\u25004455 postgres: autovacuum launcher\n$ [[root@rocky ~]$ \u251c\u25004456 postgres: stats collector\n$ [[root@rocky ~]$ \u2514\u25004457 postgres: logical replication launcher\n$ [[root@rocky ~]$ \n$ [[root@rocky ~]$ Jun 15 11:53:46 rocky.fritz.box systemd[1]: Starting PostgreSQL 13 database server...\n$ [[root@rocky ~]$ Jun 15 11:53:46 rocky.fritz.box postmaster[4449]: 2021-06-15 11:53:46.664 CEST [4449] LOG: redirecting log output to logging collector process\n$ [[root@rocky ~]$ Jun 15 11:53:46 rocky.fritz.box postmaster[4449]: 2021-06-15 11:53:46.664 CEST [4449] HINT: Future log output will appear in directory \"log\".\n$ [[root@rocky ~]$ Jun 15 11:53:46 rocky.fritz.box systemd[1]: Started PostgreSQL 13 database server.\n<\/pre>\n
\nThe binary folder and $pgdata have the Major Releasenumber of PostgreSQL within the naming.
\nFor PostgreSQL 13 $pgdata is \/pgdata\/13\/data and the binaries are in \/usr\/pgsql-13\/.<\/p>\n