{"id":43203,"date":"2022-11-04T12:30:01","date_gmt":"2022-11-04T17:30:01","guid":{"rendered":"https:\/\/www.rosehosting.com\/blog\/?p=43203"},"modified":"2022-12-28T04:58:07","modified_gmt":"2022-12-28T10:58:07","slug":"how-to-install-postgresql-on-almalinux-9","status":"publish","type":"post","link":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-almalinux-9\/","title":{"rendered":"How to Install PostgreSQL on AlmaLinux 9"},"content":{"rendered":"<div id=\"bsf_rt_marker\"><\/div><p><img decoding=\"async\" class=\"alignnone size-full wp-image-43438\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/10\/how-to-install-postgresql-on-almalinux-9.jpg\" alt=\"How to Install PostreSQL on AlmaLinux 9\" width=\"742\" height=\"372\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/10\/how-to-install-postgresql-on-almalinux-9.jpg 742w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/10\/how-to-install-postgresql-on-almalinux-9-300x150.jpg 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/10\/how-to-install-postgresql-on-almalinux-9-150x75.jpg 150w\" sizes=\"(max-width: 742px) 100vw, 742px\" \/><\/p>\n<p>PostgreSQL is an object-relational database management system written in C and C++, also known as Postgres. It can store structured and unstructured data in a single product.<\/p>\n<p>This tutorial will guide you through the simple steps of installing PostgreSQL on AlmaLinux 9 OS.<\/p>\n<p><!--more--><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-69c9649a89790\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"ez-toc-cssicon\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-69c9649a89790\"  aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-almalinux-9\/#Prerequisites\" >Prerequisites<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-almalinux-9\/#Step-1-Update-the-System\" >Step 1. Update the System<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-almalinux-9\/#Step-2-Install-PostgreSQL\" >Step 2. Install PostgreSQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-almalinux-9\/#Step-3-Set-the-PostgreSQL-user-password\" >Step 3: Set the PostgreSQL user password<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-almalinux-9\/#Step-4-Allow-Remote-Access\" >Step 4: Allow Remote Access<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-almalinux-9\/#Step-5-Accessing-the-PostgreSQL-console\" >Step 5: Accessing the PostgreSQL console<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Prerequisites\"><\/span>Prerequisites<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li>A server with AlmaLinux 9 as OS<\/li>\n<li>User privileges: root or non-root user with sudo privileges<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Step-1-Update-the-System\"><\/span>Step 1. Update the System<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>After a fresh installation of AlmaLinux, we need to update the packages to the latest versions available:<\/p>\n<pre>dnf update -y &amp;&amp; sudo dnf upgrade -y<\/pre>\n<h2><span class=\"ez-toc-section\" id=\"Step-2-Install-PostgreSQL\"><\/span>Step 2. Install PostgreSQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The latest PostgreSQL version 14 is not available in the default repository of AlmaLinux 9, so we need to add\u00a0 the official <code>PostgreSQL Repository<\/code> for the AlmaLinux system.<\/p>\n<p>Let us Install the repository RPM with the following command:<\/p>\n<pre>dnf install -y https:\/\/download.postgresql.org\/pub\/repos\/yum\/reporpms\/EL-9-x86_64\/pgdg-redhat-repo-latest.noarch.rpm<\/pre>\n<p>Then, you need to update your local package index with the following command:<\/p>\n<pre>dnf update -y<\/pre>\n<p>At this point, you can install the PostgreSQL\u00a0 server with the following command:<\/p>\n<pre>dnf install postgresql14 postgresql14-server<\/pre>\n<p>Once the installation is complete, initialize the PostgreSQL database with the following command:<\/p>\n<pre>\/usr\/pgsql-14\/bin\/postgresql-14-setup initdb\r\nInitializing database ... OK<\/pre>\n<p>Start and enable the PostgreSQL service.<\/p>\n<pre>systemctl enable postgresql-14 &amp;&amp; sudo systemctl start postgresql-14<\/pre>\n<p>Verify your PostgreSQL installation by checking its version:<\/p>\n<pre>psql -V<\/pre>\n<pre><strong>Output<\/strong>\r\npsql (PostgreSQL) 14.5<\/pre>\n<p>Check if the service is up and running:<\/p>\n<pre>systemctl status postgresql-14<\/pre>\n<p>You should receive the following output:<\/p>\n<pre>\u25cf postgresql-14.service - PostgreSQL 14 database server\r\n     Loaded: loaded (\/usr\/lib\/systemd\/system\/postgresql-14.service; enabled; vendor preset: disabled)\r\n     Active: active (running) since Fri 2022-09-23 22:21:44 CEST; 1min 25s ago\r\n       Docs: https:\/\/www.postgresql.org\/docs\/14\/static\/\r\n   Main PID: 26248 (postmaster)\r\n      Tasks: 8 (limit: 5738)\r\n     Memory: 17.1M\r\n        CPU: 154ms\r\n     CGroup: \/system.slice\/postgresql-14.service\r\n             \u251c\u250026248 \/usr\/pgsql-14\/bin\/postmaster -D \/var\/lib\/pgsql\/14\/data\/\r\n             \u251c\u250026249 \"postgres: logger \"\r\n             \u251c\u250026251 \"postgres: checkpointer \"\r\n             \u251c\u250026252 \"postgres: background writer \"\r\n             \u251c\u250026253 \"postgres: walwriter \"\r\n             \u251c\u250026254 \"postgres: autovacuum launcher \"\r\n             \u251c\u250026255 \"postgres: stats collector \"\r\n             \u2514\u250026256 \"postgres: logical replication launcher \"\r\n<\/pre>\n<p>Another way to check about the PostgreSQL service and port is to run the command below:<\/p>\n<pre>netstat -tunlp | grep 5432<\/pre>\n<p>You should receive the following output:<\/p>\n<pre>tcp        0      0 127.0.0.1:5432          0.0.0.0:*               LISTEN      26248\/postmaster<\/pre>\n<h2><span class=\"ez-toc-section\" id=\"Step-3-Set-the-PostgreSQL-user-password\"><\/span>Step 3: Set the PostgreSQL user password<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>You can change or create the user password for PostgreSQL. Using the following command, you can change the default\u00a0user password for PostgreSQL:<\/p>\n<pre>passwd postgres<\/pre>\n<p>The prompt will ask you to enter the new password and then again retype the new password.<\/p>\n<pre># passwd postgres\r\nChanging password for user postgres.\r\nNew password:\r\nRetype new password:\r\npasswd: all authentication tokens updated successfully.<\/pre>\n<p>A confirmation notification will be displayed &#8216;<strong>all authentication tokens updated successfully<\/strong>.&#8217;<\/p>\n<p>After successfully changing the new password, now, on each PostgreSQL access, you need to enter a new reset password for confirmation.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Step-4-Allow-Remote-Access\"><\/span>Step 4: Allow Remote Access<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>By default, PostgreSQL is configured to &#8220;localhost&#8221;.<\/p>\n<p>To allow remote access so PostgreSQL can be accessed from everywhere,\u00a0 you need to open the <strong>\/var\/lib\/pgsql\/14\/data\/postgresql.conf<\/strong> file and replace the line:<\/p>\n<pre>listen_addresses = 'localhost'<\/pre>\n<p>with<\/p>\n<pre>listen_addresses = '*'<\/pre>\n<p>Then you need to edit the\u00a0<strong>\/var\/lib\/pgsql\/14\/data\/pg_hba.conf<\/strong> file and add the following entry at the end of the file.<\/p>\n<pre>host    all             all             0.0.0.0\/0                md5<\/pre>\n<p>Save the file, close it, and restart the PostgreSQL service for the changes to take effect.<\/p>\n<pre>systemctl restart postgresql-14<\/pre>\n<h2><span class=\"ez-toc-section\" id=\"Step-5-Accessing-the-PostgreSQL-console\"><\/span>Step 5: Accessing the PostgreSQL console<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To access the PostgreSQL console execute the following command on your server:<\/p>\n<pre>sudo -u postgres psql<\/pre>\n<p>You should receive the following output:<\/p>\n<pre>psql (14.5)\r\nType \"help\" for help.\r\n\r\npostgres=#<\/pre>\n<p>If you want to see details of the connection, use the command:<\/p>\n<pre>\\conninfo<\/pre>\n<p>The output displays the database name, the account you are logged in to, the socket path, and the port number.<\/p>\n<pre><strong>Output:<\/strong>\r\nYou are connected to database \"postgres\" as user \"postgres\" via socket in \"\/var\/run\/postgresql\" at port \"5432\".<\/pre>\n<p>You can create a new user and database using the following command:<\/p>\n<pre>postgres=# CREATE DATABASE testdb;\r\nCREATE DATABASE\r\npostgres=# CREATE USER testuser WITH ENCRYPTED PASSWORD 'Strong_Password';\r\nCREATE ROLE\r\npostgres=# GRANT ALL PRIVILEGES ON DATABASE testdb TO testuser;\r\nGRANT<\/pre>\n<p>You can list the databases with the \u201c<b>\\l<\/b>\u201d command, and the output will be similar to the output below:<\/p>\n<pre>                                  List of databases\r\n   Name    |  Owner   | Encoding |   Collate   |    Ctype    |   Access privileges\r\n-----------+----------+----------+-------------+-------------+-----------------------\r\n postgres  | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |\r\n template0 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c\/postgres          +\r\n           |          |          |             |             | postgres=CTc\/postgres\r\n template1 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c\/postgres          +\r\n           |          |          |             |             | postgres=CTc\/postgres\r\n testdb    | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =Tc\/postgres         +\r\n           |          |          |             |             | postgres=CTc\/postgres+\r\n           |          |          |             |             | testuser=CTc\/postgres\r\n\r\n(4 rows)\r\n<\/pre>\n<p>To quit from the PostgreSQL shell, just type \u201c<b>\\q<\/b>\u201c.<\/p>\n<p>That\u2019s it. You successfully installed and configured the latest PostgreSQL 14 version on AlmaLinux 9. You can check the <a href=\"https:\/\/www.postgresql.org\/docs\/\">official PostgreSQL documentation<\/a> to learn more about PostgreSQL installation.<\/p>\n<p>Of course, you don\u2019t have to install PostgreSQL on AlmaLinux 9 if you use one of our <a href=\"https:\/\/www.rosehosting.com\/postgresql-hosting\/\">PostgreSQL VPS Hosting plans<\/a>, in which case you can simply ask our expert Linux admins to install PostgreSQL 14 on AlmaLinux 9 for you. They are available 24\u00d77 and will take care of your request immediately.<\/p>\n<p>If you liked this post on how to install PostgreSQL on AlmaLinux 9, please share it with your friends on social networks or simply leave a reply below. Thanks.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>PostgreSQL is an object-relational database management system written in C and C++, also known as Postgres. It can store structured &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to Install PostgreSQL on AlmaLinux 9\" class=\"read-more button\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-almalinux-9\/#more-43203\" aria-label=\"Read more about How to Install PostgreSQL on AlmaLinux 9\">Read More<\/a><\/p>\n","protected":false},"author":4,"featured_media":43438,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1702,13],"tags":[1910,1603,434],"class_list":["post-43203","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-databases","category-tutorials","tag-almalinux","tag-how-to-install","tag-postgresql","generate-columns","tablet-grid-50","mobile-grid-100","grid-parent","grid-33"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>How to Install PostgreSQL on AlmaLinux 9 | RoseHosting<\/title>\n<meta name=\"description\" content=\"PostgreSQL is a database management system written in C and C++. This tutorial will show you how to install it on AlmaLinux 9 OS.\" \/>\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.rosehosting.com\/blog\/how-to-install-postgresql-on-almalinux-9\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Install PostgreSQL on AlmaLinux 9\" \/>\n<meta property=\"og:description\" content=\"PostgreSQL is a database management system written in C and C++. This tutorial will show you how to install it on AlmaLinux 9 OS.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-almalinux-9\/\" \/>\n<meta property=\"og:site_name\" content=\"RoseHosting\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/RoseHosting\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/rosehosting.helpdesk\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-04T17:30:01+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-28T10:58:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/10\/how-to-install-postgresql-on-almalinux-9.jpg?v=1666782498\" \/>\n\t<meta property=\"og:image:width\" content=\"742\" \/>\n\t<meta property=\"og:image:height\" content=\"372\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Jeff Wilson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"How to Install PostgreSQL on AlmaLinux 9\" \/>\n<meta name=\"twitter:description\" content=\"PostgreSQL is a database management system written in C and C++. This tutorial will show you how to install it on AlmaLinux 9 OS.\" \/>\n<meta name=\"twitter:creator\" content=\"@rosehosting\" \/>\n<meta name=\"twitter:site\" content=\"@rosehosting\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jeff Wilson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-almalinux-9\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-almalinux-9\/\"},\"author\":{\"name\":\"Jeff Wilson\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713\"},\"headline\":\"How to Install PostgreSQL on AlmaLinux 9\",\"datePublished\":\"2022-11-04T17:30:01+00:00\",\"dateModified\":\"2022-12-28T10:58:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-almalinux-9\/\"},\"wordCount\":569,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-almalinux-9\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/10\/how-to-install-postgresql-on-almalinux-9.jpg\",\"keywords\":[\"almalinux\",\"how to install\",\"PostgreSQL\"],\"articleSection\":[\"Databases\",\"Tutorials\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-almalinux-9\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-almalinux-9\/\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-almalinux-9\/\",\"name\":\"How to Install PostgreSQL on AlmaLinux 9 | RoseHosting\",\"isPartOf\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-almalinux-9\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-almalinux-9\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/10\/how-to-install-postgresql-on-almalinux-9.jpg\",\"datePublished\":\"2022-11-04T17:30:01+00:00\",\"dateModified\":\"2022-12-28T10:58:07+00:00\",\"description\":\"PostgreSQL is a database management system written in C and C++. This tutorial will show you how to install it on AlmaLinux 9 OS.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-almalinux-9\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-almalinux-9\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-almalinux-9\/#primaryimage\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/10\/how-to-install-postgresql-on-almalinux-9.jpg\",\"contentUrl\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/10\/how-to-install-postgresql-on-almalinux-9.jpg\",\"width\":742,\"height\":372,\"caption\":\"How to Install PostreSQL on AlmaLinux 9\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-almalinux-9\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.rosehosting.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Install PostgreSQL on AlmaLinux 9\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#website\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/\",\"name\":\"RoseHosting.com\",\"description\":\"Premium Linux Tutorials Since 2001\",\"publisher\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.rosehosting.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#organization\",\"name\":\"RoseHosting\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png\",\"contentUrl\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png\",\"width\":192,\"height\":192,\"caption\":\"RoseHosting\"},\"image\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/RoseHosting\",\"https:\/\/x.com\/rosehosting\",\"https:\/\/www.linkedin.com\/in\/rosehosting\/\"],\"description\":\"RoseHosting is a leading Linux hosting provider, serving thousands of clients world-wide since 2001.\",\"email\":\"info@rosehosting.com\",\"telephone\":\"(314) 275-0414\",\"legalName\":\"Rose Web Services LLC\",\"foundingDate\":\"2001-04-02\",\"numberOfEmployees\":{\"@type\":\"QuantitativeValue\",\"minValue\":\"11\",\"maxValue\":\"50\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713\",\"name\":\"Jeff Wilson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g\",\"caption\":\"Jeff Wilson\"},\"description\":\"An experienced Linux veteran with many years of experience. Helping other Linux admins with frequent Linux and business-related blog posts on the RoseHosting blog. Techie by choice. Loving nature and travel. Happily married and father of two lovely children.\",\"sameAs\":[\"https:\/\/www.rosehosting.com\",\"https:\/\/www.facebook.com\/rosehosting.helpdesk\"],\"url\":\"https:\/\/www.rosehosting.com\/blog\/author\/jwilson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to Install PostgreSQL on AlmaLinux 9 | RoseHosting","description":"PostgreSQL is a database management system written in C and C++. This tutorial will show you how to install it on AlmaLinux 9 OS.","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.rosehosting.com\/blog\/how-to-install-postgresql-on-almalinux-9\/","og_locale":"en_US","og_type":"article","og_title":"How to Install PostgreSQL on AlmaLinux 9","og_description":"PostgreSQL is a database management system written in C and C++. This tutorial will show you how to install it on AlmaLinux 9 OS.","og_url":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-almalinux-9\/","og_site_name":"RoseHosting","article_publisher":"https:\/\/www.facebook.com\/RoseHosting","article_author":"https:\/\/www.facebook.com\/rosehosting.helpdesk","article_published_time":"2022-11-04T17:30:01+00:00","article_modified_time":"2022-12-28T10:58:07+00:00","og_image":[{"width":742,"height":372,"url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/10\/how-to-install-postgresql-on-almalinux-9.jpg?v=1666782498","type":"image\/jpeg"}],"author":"Jeff Wilson","twitter_card":"summary_large_image","twitter_title":"How to Install PostgreSQL on AlmaLinux 9","twitter_description":"PostgreSQL is a database management system written in C and C++. This tutorial will show you how to install it on AlmaLinux 9 OS.","twitter_creator":"@rosehosting","twitter_site":"@rosehosting","twitter_misc":{"Written by":"Jeff Wilson","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-almalinux-9\/#article","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-almalinux-9\/"},"author":{"name":"Jeff Wilson","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713"},"headline":"How to Install PostgreSQL on AlmaLinux 9","datePublished":"2022-11-04T17:30:01+00:00","dateModified":"2022-12-28T10:58:07+00:00","mainEntityOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-almalinux-9\/"},"wordCount":569,"commentCount":0,"publisher":{"@id":"https:\/\/www.rosehosting.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-almalinux-9\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/10\/how-to-install-postgresql-on-almalinux-9.jpg","keywords":["almalinux","how to install","PostgreSQL"],"articleSection":["Databases","Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-almalinux-9\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-almalinux-9\/","url":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-almalinux-9\/","name":"How to Install PostgreSQL on AlmaLinux 9 | RoseHosting","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-almalinux-9\/#primaryimage"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-almalinux-9\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/10\/how-to-install-postgresql-on-almalinux-9.jpg","datePublished":"2022-11-04T17:30:01+00:00","dateModified":"2022-12-28T10:58:07+00:00","description":"PostgreSQL is a database management system written in C and C++. This tutorial will show you how to install it on AlmaLinux 9 OS.","breadcrumb":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-almalinux-9\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-almalinux-9\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-almalinux-9\/#primaryimage","url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/10\/how-to-install-postgresql-on-almalinux-9.jpg","contentUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/10\/how-to-install-postgresql-on-almalinux-9.jpg","width":742,"height":372,"caption":"How to Install PostreSQL on AlmaLinux 9"},{"@type":"BreadcrumbList","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-almalinux-9\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.rosehosting.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Install PostgreSQL on AlmaLinux 9"}]},{"@type":"WebSite","@id":"https:\/\/www.rosehosting.com\/blog\/#website","url":"https:\/\/www.rosehosting.com\/blog\/","name":"RoseHosting.com","description":"Premium Linux Tutorials Since 2001","publisher":{"@id":"https:\/\/www.rosehosting.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.rosehosting.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.rosehosting.com\/blog\/#organization","name":"RoseHosting","url":"https:\/\/www.rosehosting.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png","contentUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png","width":192,"height":192,"caption":"RoseHosting"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/RoseHosting","https:\/\/x.com\/rosehosting","https:\/\/www.linkedin.com\/in\/rosehosting\/"],"description":"RoseHosting is a leading Linux hosting provider, serving thousands of clients world-wide since 2001.","email":"info@rosehosting.com","telephone":"(314) 275-0414","legalName":"Rose Web Services LLC","foundingDate":"2001-04-02","numberOfEmployees":{"@type":"QuantitativeValue","minValue":"11","maxValue":"50"}},{"@type":"Person","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713","name":"Jeff Wilson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g","caption":"Jeff Wilson"},"description":"An experienced Linux veteran with many years of experience. Helping other Linux admins with frequent Linux and business-related blog posts on the RoseHosting blog. Techie by choice. Loving nature and travel. Happily married and father of two lovely children.","sameAs":["https:\/\/www.rosehosting.com","https:\/\/www.facebook.com\/rosehosting.helpdesk"],"url":"https:\/\/www.rosehosting.com\/blog\/author\/jwilson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/43203","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/comments?post=43203"}],"version-history":[{"count":6,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/43203\/revisions"}],"predecessor-version":[{"id":43440,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/43203\/revisions\/43440"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media\/43438"}],"wp:attachment":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media?parent=43203"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/categories?post=43203"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/tags?post=43203"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}