Parallelized vacuuming of indexes.<\/li>\n<\/ul>\nIn this tutorial, we focus on the installation of PostgreSQL 13 on Rocky Linux 8.4.<\/p>\n
Step 1: Update Rocky Linux repositories<\/h2>\n
The default version of PostgreSQL in Rocky Linux repositories is version 10. However, the latest version is PostgreSQL 13 and this is what we intend to install. To maneuver around this obstacle, we will download the latest YUM repository from PostgreSQL and add it to our system as follows.<\/p>\n
$ sudo dnf install https:\/\/download.postgresql.org\/pub\/repos\/yum\/reporpms\/EL-8-x86_64\/pgdg-redhat-repo-latest.noarch.rpm<\/strong><\/pre>\n![](\"http:\/\/linuxways.net\/wp-content\/uploads\/2021\/07\/word-image-330.png\")
<\/p>\n
Step 2: Disable default module<\/strong><\/h2>\nAs pointed out earlier, the default PostgreSQL module is version 10. Before proceeding any further, we need to disable it so that we can install the latest version.<\/p>\n
To disable the default module, issue the command:<\/p>\n
$ sudo dnf -qy module disable postgresql<\/strong><\/pre>\n![](\"http:\/\/linuxways.net\/wp-content\/uploads\/2021\/07\/word-image-331.png\")
<\/p>\n
Step 3: Update the system<\/strong><\/p>\nTo synchronize with the newly added PostgreSQL repository, update your Rocky Linux 8 instance as shown.<\/p>\n
$ sudo dnf update -y<\/strong><\/pre>\n![](\"http:\/\/linuxways.net\/wp-content\/uploads\/2021\/07\/word-image-332.png\")
<\/strong><\/p>\nStep 4: Install PostgreSQL 13 server and client on Rocky<\/strong><\/p>\nWith the latest PostgreSQL repository in place, install the PostgreSQL client and server as follows.<\/p>\n
$ sudo dnf install postgresql13 postgresql13-server<\/strong><\/pre>\n![](\"http:\/\/linuxways.net\/wp-content\/uploads\/2021\/07\/word-image-333.png\")
<\/strong><\/p>\nOnce the installation is complete, you should see the following output.<\/p>\n
![](\"http:\/\/linuxways.net\/wp-content\/uploads\/2021\/07\/word-image-334.png\")
<\/p>\n
To verify the version installed, execute:<\/p>\n
$ psql -V<\/strong><\/pre>\n![](\"http:\/\/linuxways.net\/wp-content\/uploads\/2021\/07\/word-image-335.png\")
<\/p>\n
Step 5: Initialize the database<\/strong><\/h2>\nThus far, we have installed the PostgreSQL server and ensured that it is running. Next, we will initialize the initdb <\/strong>database which will create a new PostgreSQL cluster that comprises multiple databases & tables. To initialize the database, run the command:<\/p>\n$ sudo <\/strong><\/pre>\n\/usr\/pgsql-*\/bin\/postgresql-*-setup initdb<\/strong><\/p>\n![](\"http:\/\/linuxways.net\/wp-content\/uploads\/2021\/07\/word-image-336.png\")
<\/strong><\/p>\nStep 6: Enable and start PostgreSQL service<\/strong><\/h2>\nOnce the database has been initialized, proceed and enable PostgreSQL to start on boot.<\/p>\n
$ sudo systemctl enable postgresql-13<\/strong><\/pre>\nOnce enabled, start PostgreSQL.<\/p>\n
$ sudo systemctl start postgresql-13<\/strong><\/pre>\n![](\"http:\/\/linuxways.net\/wp-content\/uploads\/2021\/07\/word-image-337.png\")
<\/strong><\/p>\nTo verify that indeed PostgreSQL is active and running, invoke the command:<\/p>\n
$ sudo systemctl status postgresql-13<\/strong><\/pre>\nThe output below confirms that the PostgreSQL service is running.<\/p>\n
![](\"http:\/\/linuxways.net\/wp-content\/uploads\/2021\/07\/word-image-338.png\")
<\/strong><\/p>\nStep 7. Connecting to PostgreSQL<\/strong><\/h2>\nDuring installation. PostgreSQL creates a new user called postgres. We will leverage this user to gain access to Postgres prompt.<\/p>\n
So, run the command:<\/p>\n
$ sudo su - postgres<\/strong><\/pre>\nTo access PostgresSQL prompt, execute:<\/p>\n
$ psql<\/strong><\/pre>\nFrom here, you can proceed and create your database and tables and perform all the database management operations you deem fit.<\/p>\n
![](\"http:\/\/linuxways.net\/wp-content\/uploads\/2021\/07\/word-image-339.png\")
<\/strong><\/p>\nTo exit from the prompt, simply run:<\/p>\n
$ \\q<\/strong><\/pre>\nTO revert to your user account, type \u2018exit\u2019.<\/p>\n
$ exit<\/strong><\/pre>\n![](\"http:\/\/linuxways.net\/wp-content\/uploads\/2021\/07\/word-image-340.png\")
<\/strong><\/p>\nConclusion<\/strong><\/h2>\nThat was a walkthrough of PostgreSQL 13 installation on Rocky Linux 8.4. We do hope you now have the wherewithal to install the RDMS on your system without any trouble.<\/p>","protected":false},"excerpt":{"rendered":"
Commonly referred to as Postgres, PostgreSQL is a free and open-source, advanced, and stable relational database management system that has been around for over 20 years since its…<\/p>","protected":false},"author":1,"featured_media":8246,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[165],"tags":[415,411],"class_list":["post-8212","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-red-hat","tag-postgresql-13","tag-rocky-linux"],"_links":{"self":[{"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/posts\/8212","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/comments?post=8212"}],"version-history":[{"count":0,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/posts\/8212\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/media\/8246"}],"wp:attachment":[{"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/media?parent=8212"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/categories?post=8212"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/tags?post=8212"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}