{"id":2156,"date":"2025-12-25T18:37:45","date_gmt":"2025-09-19T07:08:45","guid":{"rendered":""},"modified":"2025-02-02T00:46:18","modified_gmt":"2025-02-01T23:46:18","slug":"how-to-install-postgresql-15-on-rocky-linux-9","status":"publish","type":"post","link":"https:\/\/netcloud24.com\/knowledgebase\/how-to-install-postgresql-15-on-rocky-linux-9\/","title":{"rendered":"Linux VPS &#038; VPS Windows Setup Guide | NetCloud24 PostgreSQL 15 on Rocky Linux 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 relational database management system that is widely used for various applications. This guide will walk you through the steps to install PostgreSQL 15 on Rocky Linux 9, which can be effectively hosted on a  for optimal performance and scalability.<\/p>\n<\/section>\n<section>\n<h2>Prerequisites<\/h2>\n<ul>\n<li>A Rocky Linux 9 server with root access<\/li>\n<li>Basic knowledge of Linux commands<\/li>\n<li>An active internet connection<\/li>\n<\/ul>\n<\/section>\n<section>\n<h2>Step 1: Update Your System<\/h2>\n<p>Start by updating your package index and upgrading any existing packages:<\/p>\n<pre><code>sudo dnf update -y<\/code><\/pre>\n<\/section>\n<section>\n<h2>Step 2: Install the PostgreSQL Repository<\/h2>\n<p>To install PostgreSQL 15, you first need to enable the PostgreSQL repository. Run the following command:<\/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: Install PostgreSQL 15<\/h2>\n<p>Now, install PostgreSQL 15 along with the PostgreSQL server:<\/p>\n<pre><code>sudo dnf install -y postgresql15 postgresql15-server<\/code><\/pre>\n<\/section>\n<section>\n<h2>Step 4: Initialize the Database<\/h2>\n<p>After installing, you need to initialize the database. Run the following command:<\/p>\n<pre><code>sudo \/usr\/pgsql-15\/bin\/postgresql15-setup initdb<\/code><\/pre>\n<\/section>\n<section>\n<h2>Step 5: Start and Enable PostgreSQL Service<\/h2>\n<p>Start the PostgreSQL service and enable it to start 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 6: Configure PostgreSQL<\/h2>\n<p>By default, PostgreSQL only allows local connections. To configure it for remote access, edit the configuration file:<\/p>\n<pre><code>sudo nano \/var\/lib\/pgsql\/15\/data\/postgresql.conf<\/code><\/pre>\n<p>Uncomment and change the following line to allow connections from any IP address:<\/p>\n<pre><code>listen_addresses = '*'<\/code><\/pre>\n<p>Next, edit the <code>pg_hba.conf<\/code> file to allow remote connections:<\/p>\n<pre><code>sudo nano \/var\/lib\/pgsql\/15\/data\/pg_hba.conf<\/code><\/pre>\n<p>Add the following line at the end of the file:<\/p>\n<pre><code>host    all             all             0.0.0.0\/0               md5<\/code><\/pre>\n<\/section>\n<section>\n<h2>Step 7: Restart PostgreSQL Service<\/h2>\n<p>After making changes, restart the PostgreSQL service:<\/p>\n<pre><code>sudo systemctl restart postgresql-15<\/code><\/pre>\n<\/section>\n<section>\n<h2>Step 8: Verify PostgreSQL Installation<\/h2>\n<p>To verify that PostgreSQL is running, you can check its status:<\/p>\n<pre><code>sudo systemctl status postgresql-15<\/code><\/pre>\n<p>You can also connect to the PostgreSQL database using the following command:<\/p>\n<pre><code>sudo -u postgres psql<\/code><\/pre>\n<\/section>\n<section>\n<h2>Step 9: Conclusion<\/h2>\n<p>You have successfully installed PostgreSQL 15 on Rocky Linux 9, providing you with a powerful database management system. This setup can greatly benefit from being hosted on a . For additional options, explore various  solutions, 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 optimal database performance.<\/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 relational database management system that is widely used for various applications. This guide will walk you through the steps to\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-2156","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\/2156","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=2156"}],"version-history":[{"count":0,"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/posts\/2156\/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=2156"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/categories?post=2156"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/tags?post=2156"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}