{"id":50335,"date":"2025-05-19T12:30:00","date_gmt":"2025-05-19T17:30:00","guid":{"rendered":"https:\/\/www.rosehosting.com\/blog\/?p=50335"},"modified":"2025-04-10T07:10:31","modified_gmt":"2025-04-10T12:10:31","slug":"how-to-install-postgresql-on-almalinux-10","status":"publish","type":"post","link":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-almalinux-10\/","title":{"rendered":"How to Install PostgreSQL on AlmaLinux 10"},"content":{"rendered":"<div id=\"bsf_rt_marker\"><\/div>\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2025\/05\/how-to-install-postgresql-on-almalinux-10.webp\" alt=\"How to install PostgreSQL on AlmaLinux 10\" class=\"wp-image-50338\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2025\/05\/how-to-install-postgresql-on-almalinux-10.webp 1024w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2025\/05\/how-to-install-postgresql-on-almalinux-10-300x169.webp 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2025\/05\/how-to-install-postgresql-on-almalinux-10-150x84.webp 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2025\/05\/how-to-install-postgresql-on-almalinux-10-768x432.webp 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p> <\/p>\n\n\n\n<p>This blog post teaches you how to install PostgreSQL on AlmaLinux 10. PostgreSQL, or Postgres, is a free and open-source object relational database management system for storing data. PostgreSQL is a powerful RDBMS with various features, such as transactions with atomicity, consistency, isolation, durability, automatic updates, etc. It is compatible with multiple operating systems like Windows, macOS, FreeBSD, and Linux. In the following paragraphs, we will show you how to install the PostgreSQL database management system, manage the service, and use some basic commands.<\/p>\n\n\n\n<p>Installing PostgreSQL on AlmaLinux is straightforward and may take up to 10 minutes. Let&#8217;s get started!<\/p>\n\n\n\n<!--more-->\n\n\n\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-69f31bca6e545\" 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-69f31bca6e545\"  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-10\/#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-10\/#Update-the-system\" >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-10\/#Install-PostgreSQL-database-server\" >Install PostgreSQL database server<\/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-10\/#Manage-the-PostgreSQL-service\" >Manage the PostgreSQL service<\/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-10\/#The-PostgreSQL-console\" >The PostgreSQL console<\/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-10\/#PostgreSQL-Configuration-File\" >PostgreSQL Configuration File<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Prerequisites\"><\/span>Prerequisites<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>A server running AlmaLinux 10 or any Linux OS<\/li>\n\n\n\n<li>User privileges: root or non-root user with sudo privileges<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Update-the-system\"><\/span>Update the system<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Before we start the installation process of the PostgreSQL database system, it is recommended that the system packages be updated to their latest available versions. To do that, execute the following command:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">sudo dnf update -y &amp;&amp; sudo dnf upgrade -y<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Install-PostgreSQL-database-server\"><\/span>Install PostgreSQL database server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>The PostgreSQL repository is by default added to the latest AlmaLinux 10 OS. To install the latest PostgreSQL 16, execute the following command:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">sudo dnf install postgresql-server postgresql-contrib postgresql -y<\/pre>\n\n\n\n<p>Once installed, you can check the PostgreSQL version and verify if PostgreSQL was installed successfully. To do that, execute the command below:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">postgres --version<\/pre>\n\n\n\n<p>You should get the following output:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">[root@host ~]# postgres --version\npostgres (PostgreSQL) 16.4\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Manage-the-PostgreSQL-service\"><\/span>Manage the PostgreSQL service<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>After successful installation, to start and enable PostgreSQL for automatic start on system boot, execute the command below:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">sudo systemctl start postgresql &amp;&amp; sudo systemctl enable postgresql<\/pre>\n\n\n\n<p>To check the status of the service, you can use the following command:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">sudo systemctl status postgresql<\/pre>\n\n\n\n<p>If everything is OK, you will receive output similar to this:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">root@host ~]# sudo systemctl status postgresql\n\u25cf postgresql.service - PostgreSQL database server\n     Loaded: loaded (\/usr\/lib\/systemd\/system\/postgresql.service; enabled; preset: disabled)\n     Active: active (running) since Sun 2025-04-05 10:47:09 CDT; 41min ago\n Invocation: deb4221eaa0b447f94a583925e15fe4c\n   Main PID: 1907 (postgres)\n      Tasks: 7 (limit: 23175)\n     Memory: 19.5M (peak: 22.4M)\n        CPU: 647ms\n     CGroup: \/system.slice\/postgresql.service\n             \u251c\u25001907 \/usr\/bin\/postgres -D \/var\/lib\/pgsql\/data\n             \u251c\u25001909 \"postgres: logger \"\n             \u251c\u25001910 \"postgres: checkpointer \"\n             \u251c\u25001911 \"postgres: background writer \"\n             \u251c\u25001913 \"postgres: walwriter \"\n             \u251c\u25001914 \"postgres: autovacuum launcher \"\n             \u2514\u25001915 \"postgres: logical replication launcher \"\n\nApr 05 10:47:09 host.test.vps systemd[1]: Starting postgresql.service - PostgreSQL database server...\nApr 05 10:47:09 host.test.vps postgres[1907]: 2025-04-05 10:47:09.309 CDT [1907] LOG:  redirecting log output to logging collector process\nApr 05 10:47:09 host.test.vps postgres[1907]: 2025-04-05 10:47:09.309 CDT [1907] HINT:  Future log output will appear in directory \"log\".\nApr 05 10:47:09 host.test.vps systemd[1]: Started postgresql.service - PostgreSQL database server.\n<\/pre>\n\n\n\n<p>Stopping the PostgreSQL service can be done with:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">sudo systemctl stop postgresql<\/pre>\n\n\n\n<p>Restarting the service with:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">sudo systemctl restart postgresql<\/pre>\n\n\n\n<p>There is another way to check if PostgreSQL is running on your server, and that is by checking port <strong>5432<\/strong>, which is the default PostgreSQL port:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">netstat -tunlp | grep 5432<\/pre>\n\n\n\n<p>Since, with the previous status command we already know that PostgreSQL is running successfully, you should receive output similar to this:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">[root@host ~]# netstat -tunlp | grep 5432\ntcp6       0      0 ::1:<strong>5432<\/strong>                :::*                    LISTEN      1907\/postgres\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"The-PostgreSQL-console\"><\/span>The PostgreSQL console<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>The PostgreSQL command line is essential for managing the databases, creating users, setting passwords, granting permissions, etc. First, we will show you how to log in to the PostgreSQL command line. Execute the following command:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">sudo -u postgres psql<\/pre>\n\n\n\n<p>After this command, you will be logged into the PostgreSQL console:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">[root@host ~]# sudo -u postgres psql\npsql (16.4)\nType \"help\" for help.\n\npostgres=#<\/pre>\n\n\n\n<p>To create a new user database and grant permissions to that user, execute the following commands one by one:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">CREATE DATABASE rhtestdb;\n\nCREATE USER rhtestuser WITH ENCRYPTED PASSWORD 'YourStrongPasswordHere';\n\nGRANT ALL PRIVILEGES ON DATABASE rhtestdb TO rhtestuser;\n<\/pre>\n\n\n\n<p>While executing the command above, you will receive confirming messages if the database and user are created, as shown in the output below:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">postgres=# CREATE DATABASE rhtestdb;\n<strong>CREATE DATABASE<\/strong>\npostgres=# CREATE USER rhtestuser WITH ENCRYPTED PASSWORD 'YourStrongPasswordHere';\n<strong>CREATE ROLE<\/strong>\npostgres=# GRANT ALL PRIVILEGES ON DATABASE rhtestdb TO rhtestuser;\n<strong>GRANT<\/strong>\npostgres=# \n<\/pre>\n\n\n\n<p>Now, when the database and user are created, we can list the database with the command below:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">\\l<\/pre>\n\n\n\n<p>You will get output similar to this:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">postgres=# \\l\n                                                    List of databases\n   Name    |  Owner   | Encoding | Locale Provider | Collate |  Ctype  | ICU Locale | ICU Rules |    Access privileges    \n-----------+----------+----------+-----------------+---------+---------+------------+-----------+-------------------------\n postgres  | postgres | UTF8     | libc            | C.UTF-8 | C.UTF-8 |            |           | \n <strong>rhtestdb  | postgres | UTF8     | libc            | C.UTF-8 | C.UTF-8 |            |           | =Tc\/postgres           +<\/strong>\n           |          |          |                 |         |         |            |           | postgres=CTc\/postgres  +\n           |          |          |                 |         |         |            |           | rhtestuser=CTc\/postgres\n template0 | postgres | UTF8     | libc            | C.UTF-8 | C.UTF-8 |            |           | =c\/postgres            +\n           |          |          |                 |         |         |            |           | postgres=CTc\/postgres\n template1 | postgres | UTF8     | libc            | C.UTF-8 | C.UTF-8 |            |           | =c\/postgres            +\n           |          |          |                 |         |         |            |           | postgres=CTc\/postgres\n(4 rows)\n\npostgres=# \n<\/pre>\n\n\n\n<p>Through the PostgreSQL console, you can execute different SQL queries. To quit from the console, you need to use the following command:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">\\q<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"PostgreSQL-Configuration-File\"><\/span>PostgreSQL Configuration File<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>The PostgreSQL configuration file is a vital file where you can configure some values, such as max connections, remote access, restricted access, how much RAM to use for the PostgreSQL service, on which port to listen to the service, etc. The location of the PostgreSQL configuration file is at:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">\/var\/lib\/pgsql\/data\/postgresql.conf<\/pre>\n\n\n\n<p>The following lines of code are examples from <strong>postgresql.conf<\/strong> file:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"># - Connection Settings -\n\n#listen_addresses = 'localhost'         # what IP address(es) to listen on;\n#port = 5432                            # (change requires restart)\nmax_connections = 100                   # (change requires restart)\n\n# - Memory -\nshared_buffers = 128MB                  # min 128kB\n\n# - Where to Log \nlogging_collector = on\nlog_filename = 'postgresql-%a.log'\nlog_rotation_age = 1d\n<\/pre>\n\n\n\n<p>That&#8217;s it. You successfully installed the PostgreSQL database system on AlmaLinux 10 and learned some basic commands.<\/p>\n\n\n\n<p>Of course, you don\u2019t have to do this if you have difficulties and are unfamiliar with Linux and database servers. You can always contact our technical support. You only need to sign up for one of our NVMe <a href=\"https:\/\/www.rosehosting.com\/almalinux-hosting\/\" target=\"_blank\" rel=\"noreferrer noopener\">AlmaLinux VPS server plans<\/a> and submit a support ticket. We are available 24\/7 and will take care of your request immediately.<\/p>\n\n\n\n<p>If you liked this post on how to install PostgreSQL on AlmaLinux 10, please share it with your friends or leave a comment below.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This blog post teaches you how to install PostgreSQL on AlmaLinux 10. PostgreSQL, or Postgres, is a free and open-source &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to Install PostgreSQL on AlmaLinux 10\" class=\"read-more button\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-almalinux-10\/#more-50335\" aria-label=\"Read more about How to Install PostgreSQL on AlmaLinux 10\">Read More<\/a><\/p>\n","protected":false},"author":4,"featured_media":50338,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2176,1702],"tags":[2263,1603,27,434],"class_list":["post-50335","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-almalinux","category-databases","tag-almalinux-10","tag-how-to-install","tag-linux","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.5 (Yoast SEO v27.5) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>How to Install PostgreSQL on AlmaLinux 10 | RoseHosting<\/title>\n<meta name=\"description\" content=\"Learn how to install PostgreSQL on AlmaLinux 10 using our easy-to-follow guide or just ask our Linux admins to install it for you.\" \/>\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-10\/\" \/>\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 10\" \/>\n<meta property=\"og:description\" content=\"How to Install PostgreSQL on AlmaLinux 10 | RoseHosting\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-almalinux-10\/\" \/>\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=\"2025-05-19T17:30:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2025\/05\/how-to-install-postgresql-on-almalinux-10.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"576\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Jeff Wilson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\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=\"5 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-10\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-on-almalinux-10\\\/\"},\"author\":{\"name\":\"Jeff Wilson\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#\\\/schema\\\/person\\\/7ce77a842fa6a9a7f8efa186f2353713\"},\"headline\":\"How to Install PostgreSQL on AlmaLinux 10\",\"datePublished\":\"2025-05-19T17:30:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-on-almalinux-10\\\/\"},\"wordCount\":614,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-on-almalinux-10\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/05\\\/how-to-install-postgresql-on-almalinux-10.webp\",\"keywords\":[\"almalinux 10\",\"how to install\",\"Linux\",\"PostgreSQL\"],\"articleSection\":[\"AlmaLinux\",\"Databases\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-on-almalinux-10\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-on-almalinux-10\\\/\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-on-almalinux-10\\\/\",\"name\":\"How to Install PostgreSQL on AlmaLinux 10 | RoseHosting\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-on-almalinux-10\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-on-almalinux-10\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/05\\\/how-to-install-postgresql-on-almalinux-10.webp\",\"datePublished\":\"2025-05-19T17:30:00+00:00\",\"description\":\"Learn how to install PostgreSQL on AlmaLinux 10 using our easy-to-follow guide or just ask our Linux admins to install it for you.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-on-almalinux-10\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-on-almalinux-10\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-on-almalinux-10\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/05\\\/how-to-install-postgresql-on-almalinux-10.webp\",\"contentUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/05\\\/how-to-install-postgresql-on-almalinux-10.webp\",\"width\":1024,\"height\":576,\"caption\":\"How to install PostgreSQL on AlmaLinux 10\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-on-almalinux-10\\\/#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 10\"}]},{\"@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 10 | RoseHosting","description":"Learn how to install PostgreSQL on AlmaLinux 10 using our easy-to-follow guide or just ask our Linux admins to install it for you.","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-10\/","og_locale":"en_US","og_type":"article","og_title":"How to Install PostgreSQL on AlmaLinux 10","og_description":"How to Install PostgreSQL on AlmaLinux 10 | RoseHosting","og_url":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-almalinux-10\/","og_site_name":"RoseHosting","article_publisher":"https:\/\/www.facebook.com\/RoseHosting","article_author":"https:\/\/www.facebook.com\/rosehosting.helpdesk","article_published_time":"2025-05-19T17:30:00+00:00","og_image":[{"width":1024,"height":576,"url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2025\/05\/how-to-install-postgresql-on-almalinux-10.webp","type":"image\/webp"}],"author":"Jeff Wilson","twitter_card":"summary_large_image","twitter_creator":"@rosehosting","twitter_site":"@rosehosting","twitter_misc":{"Written by":"Jeff Wilson","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-almalinux-10\/#article","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-almalinux-10\/"},"author":{"name":"Jeff Wilson","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713"},"headline":"How to Install PostgreSQL on AlmaLinux 10","datePublished":"2025-05-19T17:30:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-almalinux-10\/"},"wordCount":614,"commentCount":0,"publisher":{"@id":"https:\/\/www.rosehosting.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-almalinux-10\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2025\/05\/how-to-install-postgresql-on-almalinux-10.webp","keywords":["almalinux 10","how to install","Linux","PostgreSQL"],"articleSection":["AlmaLinux","Databases"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-almalinux-10\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-almalinux-10\/","url":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-almalinux-10\/","name":"How to Install PostgreSQL on AlmaLinux 10 | RoseHosting","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-almalinux-10\/#primaryimage"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-almalinux-10\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2025\/05\/how-to-install-postgresql-on-almalinux-10.webp","datePublished":"2025-05-19T17:30:00+00:00","description":"Learn how to install PostgreSQL on AlmaLinux 10 using our easy-to-follow guide or just ask our Linux admins to install it for you.","breadcrumb":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-almalinux-10\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-almalinux-10\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-almalinux-10\/#primaryimage","url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2025\/05\/how-to-install-postgresql-on-almalinux-10.webp","contentUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2025\/05\/how-to-install-postgresql-on-almalinux-10.webp","width":1024,"height":576,"caption":"How to install PostgreSQL on AlmaLinux 10"},{"@type":"BreadcrumbList","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-almalinux-10\/#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 10"}]},{"@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\/50335","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=50335"}],"version-history":[{"count":3,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/50335\/revisions"}],"predecessor-version":[{"id":50339,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/50335\/revisions\/50339"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media\/50338"}],"wp:attachment":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media?parent=50335"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/categories?post=50335"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/tags?post=50335"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}