{"id":2778,"date":"2025-06-11T04:37:52","date_gmt":"2022-05-21T00:20:14","guid":{"rendered":""},"modified":"2025-02-02T00:46:19","modified_gmt":"2025-02-01T23:46:19","slug":"step-by-step-guide-installing-postgresql-on-almalinux-9","status":"publish","type":"post","link":"https:\/\/netcloud24.com\/knowledgebase\/step-by-step-guide-installing-postgresql-on-almalinux-9\/","title":{"rendered":"Step-by-Step Guide: Installing PostgreSQL on AlmaLinux 9"},"content":{"rendered":"<p>\u00a0<\/p>\n<\/p>\n<header>\n<h1>\u00a0<\/h1>\n<\/header>\n<article>\n<section>\n<h2>Introduction<\/h2>\n<p>PostgreSQL is a powerful, open-source object-relational database system that uses and extends the SQL language. This guide provides a detailed walkthrough for installing PostgreSQL on AlmaLinux 9, ensuring you can manage your data effectively. This setup can also be beneficial when combined with a  for enhanced performance and reliability.<\/p>\n<\/section>\n<section>\n<h2>Prerequisites<\/h2>\n<ul>\n<li>An AlmaLinux 9 server with root access<\/li>\n<li>Internet connection for downloading packages<\/li>\n<li>Basic knowledge of command-line operations<\/li>\n<\/ul>\n<\/section>\n<section>\n<h2>Step 1: Update the System<\/h2>\n<p>Begin by updating your system to ensure all packages are current. Run the following command:<\/p>\n<pre><code>sudo dnf update -y<\/code><\/pre>\n<\/section>\n<section>\n<h2>Step 2: Install PostgreSQL Repository<\/h2>\n<p>To install PostgreSQL, you need to enable the PostgreSQL repository. Run the following command to install the necessary repository package:<\/p>\n<pre><code>sudo dnf install -y https:\/\/download.postgresql.org\/pub\/repos\/yum\/reporpms\/EL-9-x86_64\/pgdg-redhat-repo-latest.noarch.rpm<\/code><\/pre>\n<\/section>\n<section>\n<h2>Step 3: Disable the Built-in PostgreSQL Module<\/h2>\n<p>AlmaLinux may come with a built-in PostgreSQL module. Disable it using the command:<\/p>\n<pre><code>sudo dnf -qy module disable postgresql<\/code><\/pre>\n<\/section>\n<section>\n<h2>Step 4: Install PostgreSQL<\/h2>\n<p>Now that the repository is set up, you can install PostgreSQL. Use the following command:<\/p>\n<pre><code>sudo dnf install -y postgresql15 postgresql15-server<\/code><\/pre>\n<\/section>\n<section>\n<h2>Step 5: Initialize PostgreSQL Database<\/h2>\n<p>After the installation, initialize the PostgreSQL database using the following command:<\/p>\n<pre><code>sudo \/usr\/pgsql-15\/bin\/postgresql15-setup initdb<\/code><\/pre>\n<\/section>\n<section>\n<h2>Step 6: Start and Enable PostgreSQL Service<\/h2>\n<p>Now, start the PostgreSQL service and enable it to run on boot:<\/p>\n<pre><code>sudo systemctl start postgresql-15\r\nsudo systemctl enable postgresql-15<\/code><\/pre>\n<\/section>\n<section>\n<h2>Step 7: Configure PostgreSQL to Accept Remote Connections<\/h2>\n<p>By default, PostgreSQL only allows local connections. To enable remote access, edit the <code>pg_hba.conf<\/code> file:<\/p>\n<pre><code>sudo nano \/var\/lib\/pgsql\/15\/data\/pg_hba.conf<\/code><\/pre>\n<p>Add the following line to allow connections from all IP addresses:<\/p>\n<pre><code>host all all 0.0.0.0\/0 md5<\/code><\/pre>\n<p>Next, edit the <code>postgresql.conf<\/code> file:<\/p>\n<pre><code>sudo nano \/var\/lib\/pgsql\/15\/data\/postgresql.conf<\/code><\/pre>\n<p>Find the line that starts with <code>listen_addresses<\/code> and modify it to:<\/p>\n<pre><code>listen_addresses = '*'<\/code><\/pre>\n<\/section>\n<section>\n<h2>Step 8: Restart PostgreSQL Service<\/h2>\n<p>After making these changes, restart the PostgreSQL service:<\/p>\n<pre><code>sudo systemctl restart postgresql-15<\/code><\/pre>\n<\/section>\n<section>\n<h2>Step 9: Create a PostgreSQL User<\/h2>\n<p>Log into PostgreSQL and create a new user:<\/p>\n<pre><code>sudo -u postgres psql\r\nCREATE USER your_username WITH PASSWORD 'your_password';<\/code><\/pre>\n<p>Replace <code>your_username<\/code> and <code>your_password<\/code> with your desired credentials.<\/p>\n<\/section>\n<section>\n<h2>Step 10: Conclusion<\/h2>\n<p>Congratulations! You have successfully installed PostgreSQL on AlmaLinux 9. This powerful database system is now ready to be used for your applications. For enhanced performance and reliable hosting, consider using a . Explore options such as , including <a href=\"https:\/\/ie.netcloud24.com\">Windows VPSVirtual Private Server Hosting<\/a> and <a href=\"https:\/\/ie.netcloud24.com\">Windows VPS Hosting UK<\/a> for your database solutions.<\/p>\n<\/section>\n<\/article>\n<footer>\n<p>\u00a9 2024 PostgreSQL Installation Tutorial. All rights reserved.<\/p>\n<\/footer>\n<div class=\"post-author-box\" style=\"border-top:1px solid #ddd;margin-top:20px;padding-top:15px;\">\n<p><strong>Author:<\/strong> \u0141ukasz Bodziony<\/p>\n<p><strong>Website:<\/strong> <a href=\"https:\/\/ca.netcloud24.com\" target=\"_blank\" rel=\"dofollow\">Windows VPS<\/a><\/p>\n<p><em>\u0141ukasz Bodziony is the CEO and founder of <a href=\"https:\/\/netcloud24.com\" target=\"_blank\" rel=\"dofollow\">NETCLOUD24<\/a>, a global VPS hosting brand proudly originating from Poland. With extensive experience in cloud computing, virtualization, and server management, he delivers high-performance <strong>Windows VPS<\/strong> and <strong>Remote Desktop Services (RDS)<\/strong> solutions to clients across Europe, North America, and beyond.<\/em><\/p>\n<p><em>His expertise covers a wide range of technologies, including <strong>Microsoft Azure<\/strong>, <strong>Proxmox VE<\/strong>, <strong>Amazon Web Services (AWS)<\/strong>, and numerous other virtualization and cloud platforms.<\/em><\/p>\n<p><em>Beyond running his hosting business, \u0141ukasz also provides <strong>professional paid server configuration and optimization services<\/strong> for companies and individuals. Outside of work, he is dedicated to caring for his children and building a secure future for them.<\/em><\/p>\n<p><em>If you are interested in working with him or need expert assistance with your hosting, cloud environment, or server setup, feel free to reach out via <a href=\"https:\/\/ca.netcloud24.com\" target=\"_blank\" rel=\"dofollow\">Windows VPS<\/a>.<\/em><\/p>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u00a0 \u00a0 Introduction PostgreSQL is a powerful, open-source object-relational database system that uses and extends the SQL language. This guide provides a detailed walkthrough for installing PostgreSQL on\u2026<\/p>\n","protected":false},"author":1,"featured_media":3421,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_seopress_robots_primary_cat":"","_seopress_titles_title":"","_seopress_titles_desc":"","_seopress_robots_index":"","footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[],"tags":[14,12,11,23,20,21,22,17,7,8,6,10,18,19,15,24,16,5,13,9],"class_list":["post-2778","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","tag-cheapvps","tag-cloudvps","tag-hostingvps","tag-rds","tag-rdscal","tag-remotedesktop","tag-remotedesktopvps","tag-servervps","tag-ukvps","tag-virtualserver","tag-vpshosting","tag-vpsserver","tag-vpssolutions","tag-vpswindows","tag-vpswithwindows","tag-windowsrds","tag-windowsserver","tag-windowsvps","tag-windowsvpshosting","tag-windowsvpsuk"],"jetpack_publicize_connections":[],"_links":{"self":[{"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/posts\/2778","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/comments?post=2778"}],"version-history":[{"count":0,"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/posts\/2778\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/media\/3421"}],"wp:attachment":[{"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/media?parent=2778"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/categories?post=2778"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/tags?post=2778"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}