{"id":14123,"date":"2024-06-17T10:59:29","date_gmt":"2024-06-17T07:59:29","guid":{"rendered":"http:\/\/local.brightwhiz\/?p=14123"},"modified":"2024-06-17T10:59:30","modified_gmt":"2024-06-17T07:59:30","slug":"how-to-install-postgresql-psql-on-almalinux-8-10-systems","status":"publish","type":"post","link":"http:\/\/local.brightwhiz\/how-to-install-postgresql-psql-on-almalinux-8-10-systems\/","title":{"rendered":"How to Install PostgreSQL (psql) on AlmaLinux 8.10 Systems"},"content":{"rendered":"\n<p>PostgreSQL, commonly referred to as <code>psql<\/code>, is a powerful open-source relational database system known for its reliability and robust feature set. If you&#8217;re using AlmaLinux 8.10 and need to set up PostgreSQL for your projects or applications, this guide will walk you through the installation process step-by-step.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Step 1: Update System Packages<\/h4>\n\n\n\n<p>Before installing any new software, it&#8217;s always a good practice to update your system&#8217;s package repository and installed packages to their latest versions. Open a terminal and execute the following commands:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">$ sudo dnf clean all\n$ sudo dnf update<\/code><\/pre>\n\n\n\n<p>This ensures that you have the latest versions of packages and fixes any potential dependency issues.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Step 2: Install PostgreSQL Server<\/h4>\n\n\n\n<p>AlmaLinux uses the DNF package manager for package installations. PostgreSQL packages are available in the default repositories, so you can install them using the following command:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">$ sudo dnf install postgresql-server<\/code><\/pre>\n\n\n\n<p>During the installation process, you might be prompted to confirm the installation by typing <code>y<\/code> and then pressing <code>Enter<\/code>.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Step 3: Initialize the Database<\/h4>\n\n\n\n<p>Once PostgreSQL is installed, you need to initialize the database before starting the service. Run the following command:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">$ sudo postgresql-setup --initdb<\/code><\/pre>\n\n\n\n<p>This command initializes a new PostgreSQL database cluster and sets up the necessary configuration files.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Step 4: Start and Enable PostgreSQL Service<\/h4>\n\n\n\n<p>After initializing the database, you can start the PostgreSQL service and enable it to start automatically at boot time with the following commands:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">$ sudo systemctl start postgresql\n$ sudo systemctl enable postgresql<\/code><\/pre>\n\n\n\n<p>To verify that PostgreSQL is running, you can use the <code>systemctl<\/code> command to check its status:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">$ sudo systemctl status postgresql<\/code><\/pre>\n\n\n\n<p>If PostgreSQL has started successfully, you should see an output indicating that the service is active and running.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Step 5: Access PostgreSQL Prompt (psql)<\/h4>\n\n\n\n<p>To interact with PostgreSQL, you can use the <code>psql<\/code> command-line interface. By default, PostgreSQL creates a user named <code>postgres<\/code> with administrative privileges. Switch to this user and access the <code>psql<\/code> prompt:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">$ sudo su - postgres\n$ psql<\/code><\/pre>\n\n\n\n<p>You should now be logged into the PostgreSQL interactive terminal (<code>psql<\/code>), where you can start executing SQL commands and managing your databases.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Step 6: Set a Password for the PostgreSQL User<\/h4>\n\n\n\n<p>By default, the <code>postgres<\/code> user does not have a password set. To secure your PostgreSQL installation, set a password for this user using the following command inside the <code>psql<\/code> prompt:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">$ \\password postgres<\/code><\/pre>\n\n\n\n<p>Enter a strong password and confirm it when prompted. This password will be required whenever you log in as the <code>postgres<\/code> user.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Conclusion<\/h4>\n\n\n\n<p>Congratulations! You&#8217;ve successfully installed PostgreSQL on your AlmaLinux 8.10 system. You can now start creating databases, defining schemas, and utilizing the full power of PostgreSQL for your applications. Remember to secure your database by configuring firewall rules and following best practices for database administration.<\/p>\n\n\n\n<p>If you encounter any issues or have specific requirements, refer to the <a href=\"https:\/\/www.postgresql.org\/docs\/current\/\" target=\"_blank\" rel=\"noreferrer noopener\">PostgreSQL documentation<\/a> for detailed guidance. PostgreSQL&#8217;s extensive documentation covers everything from basic installation to advanced configurations and optimizations.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>PostgreSQL, commonly referred to as psql, is a powerful open-source relational database system known for its reliability and robust feature set. If you&#8217;re using AlmaLinux 8.10 and need to set&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,23,24,9,25,27,16],"tags":[1282,193,354,424,433,449,472,531,572,573,591],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Install PostgreSQL (psql) on AlmaLinux 8.10<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/local.brightwhiz\/how-to-install-postgresql-psql-on-almalinux-8-10-systems\/\" \/>\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 (psql) on AlmaLinux 8.10\" \/>\n<meta property=\"og:description\" content=\"PostgreSQL, commonly referred to as psql, is a powerful open-source relational database system known for its reliability and robust feature set. If you&#8217;re using AlmaLinux 8.10 and need to set...\" \/>\n<meta property=\"og:url\" content=\"http:\/\/local.brightwhiz\/how-to-install-postgresql-psql-on-almalinux-8-10-systems\/\" \/>\n<meta property=\"og:site_name\" content=\"Brightwhiz.com\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/brightwhiz\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-06-17T07:59:29+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-06-17T07:59:30+00:00\" \/>\n<meta name=\"author\" content=\"Michael Bright\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@brightwhizmag\" \/>\n<meta name=\"twitter:site\" content=\"@brightwhizmag\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Michael Bright\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\/\/local.brightwhiz\/how-to-install-postgresql-psql-on-almalinux-8-10-systems\/#article\",\"isPartOf\":{\"@id\":\"http:\/\/local.brightwhiz\/how-to-install-postgresql-psql-on-almalinux-8-10-systems\/\"},\"author\":{\"name\":\"Michael Bright\",\"@id\":\"http:\/\/local.brightwhiz\/#\/schema\/person\/81f0f3126f13834ae2e7f381b3028e32\"},\"headline\":\"How to Install PostgreSQL (psql) on AlmaLinux 8.10 Systems\",\"datePublished\":\"2024-06-17T07:59:29+00:00\",\"dateModified\":\"2024-06-17T07:59:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\/\/local.brightwhiz\/how-to-install-postgresql-psql-on-almalinux-8-10-systems\/\"},\"wordCount\":440,\"publisher\":{\"@id\":\"http:\/\/local.brightwhiz\/#organization\"},\"keywords\":[\"Almalinux\",\"DevOps\",\"Linux\",\"Open Source\",\"Optimization\",\"Performance\",\"Programming Languages\",\"Server\",\"Systems\",\"Systems Administration\",\"Tools\"],\"articleSection\":[\"Articles\",\"Guides\",\"Hardware\",\"How To\",\"Libraries\",\"Programming\",\"Technology\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"http:\/\/local.brightwhiz\/how-to-install-postgresql-psql-on-almalinux-8-10-systems\/\",\"url\":\"http:\/\/local.brightwhiz\/how-to-install-postgresql-psql-on-almalinux-8-10-systems\/\",\"name\":\"How to Install PostgreSQL (psql) on AlmaLinux 8.10\",\"isPartOf\":{\"@id\":\"http:\/\/local.brightwhiz\/#website\"},\"datePublished\":\"2024-06-17T07:59:29+00:00\",\"dateModified\":\"2024-06-17T07:59:30+00:00\",\"breadcrumb\":{\"@id\":\"http:\/\/local.brightwhiz\/how-to-install-postgresql-psql-on-almalinux-8-10-systems\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/local.brightwhiz\/how-to-install-postgresql-psql-on-almalinux-8-10-systems\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/local.brightwhiz\/how-to-install-postgresql-psql-on-almalinux-8-10-systems\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\/\/local.brightwhiz\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Install PostgreSQL (psql) on AlmaLinux 8.10 Systems\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\/\/local.brightwhiz\/#website\",\"url\":\"http:\/\/local.brightwhiz\/\",\"name\":\"Brightwhiz.com\",\"description\":\"Best Tech guides, Tutorials, and News\",\"publisher\":{\"@id\":\"http:\/\/local.brightwhiz\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/local.brightwhiz\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"http:\/\/local.brightwhiz\/#organization\",\"name\":\"Brightwhiz\",\"url\":\"http:\/\/local.brightwhiz\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/local.brightwhiz\/#\/schema\/logo\/image\/\",\"url\":\"http:\/\/local.brightwhiz\/wp-content\/uploads\/2021\/11\/brightwhiz-com-logo-orange.png\",\"contentUrl\":\"http:\/\/local.brightwhiz\/wp-content\/uploads\/2021\/11\/brightwhiz-com-logo-orange.png\",\"width\":706,\"height\":135,\"caption\":\"Brightwhiz\"},\"image\":{\"@id\":\"http:\/\/local.brightwhiz\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/brightwhiz\/\",\"https:\/\/x.com\/brightwhizmag\",\"https:\/\/instagram.com\/bright_whiz\/\",\"https:\/\/www.pinterest.com\/sobbayi\/\",\"https:\/\/www.youtube.com\/channel\/UC6sCdP_d_RiTIM7ErFT-PSQ\"]},{\"@type\":\"Person\",\"@id\":\"http:\/\/local.brightwhiz\/#\/schema\/person\/81f0f3126f13834ae2e7f381b3028e32\",\"name\":\"Michael Bright\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/local.brightwhiz\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/1.gravatar.com\/avatar\/da90485875ff0aafa38fdd494abe87d1?s=96&d=mm&r=g\",\"contentUrl\":\"http:\/\/1.gravatar.com\/avatar\/da90485875ff0aafa38fdd494abe87d1?s=96&d=mm&r=g\",\"caption\":\"Michael Bright\"},\"sameAs\":[\"https:\/\/sobbayi.com\"],\"url\":\"http:\/\/local.brightwhiz\/author\/sobbayiadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Install PostgreSQL (psql) on AlmaLinux 8.10","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":"http:\/\/local.brightwhiz\/how-to-install-postgresql-psql-on-almalinux-8-10-systems\/","og_locale":"en_US","og_type":"article","og_title":"How to Install PostgreSQL (psql) on AlmaLinux 8.10","og_description":"PostgreSQL, commonly referred to as psql, is a powerful open-source relational database system known for its reliability and robust feature set. If you&#8217;re using AlmaLinux 8.10 and need to set...","og_url":"http:\/\/local.brightwhiz\/how-to-install-postgresql-psql-on-almalinux-8-10-systems\/","og_site_name":"Brightwhiz.com","article_publisher":"https:\/\/www.facebook.com\/brightwhiz\/","article_published_time":"2024-06-17T07:59:29+00:00","article_modified_time":"2024-06-17T07:59:30+00:00","author":"Michael Bright","twitter_card":"summary_large_image","twitter_creator":"@brightwhizmag","twitter_site":"@brightwhizmag","twitter_misc":{"Written by":"Michael Bright","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/local.brightwhiz\/how-to-install-postgresql-psql-on-almalinux-8-10-systems\/#article","isPartOf":{"@id":"http:\/\/local.brightwhiz\/how-to-install-postgresql-psql-on-almalinux-8-10-systems\/"},"author":{"name":"Michael Bright","@id":"http:\/\/local.brightwhiz\/#\/schema\/person\/81f0f3126f13834ae2e7f381b3028e32"},"headline":"How to Install PostgreSQL (psql) on AlmaLinux 8.10 Systems","datePublished":"2024-06-17T07:59:29+00:00","dateModified":"2024-06-17T07:59:30+00:00","mainEntityOfPage":{"@id":"http:\/\/local.brightwhiz\/how-to-install-postgresql-psql-on-almalinux-8-10-systems\/"},"wordCount":440,"publisher":{"@id":"http:\/\/local.brightwhiz\/#organization"},"keywords":["Almalinux","DevOps","Linux","Open Source","Optimization","Performance","Programming Languages","Server","Systems","Systems Administration","Tools"],"articleSection":["Articles","Guides","Hardware","How To","Libraries","Programming","Technology"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"http:\/\/local.brightwhiz\/how-to-install-postgresql-psql-on-almalinux-8-10-systems\/","url":"http:\/\/local.brightwhiz\/how-to-install-postgresql-psql-on-almalinux-8-10-systems\/","name":"How to Install PostgreSQL (psql) on AlmaLinux 8.10","isPartOf":{"@id":"http:\/\/local.brightwhiz\/#website"},"datePublished":"2024-06-17T07:59:29+00:00","dateModified":"2024-06-17T07:59:30+00:00","breadcrumb":{"@id":"http:\/\/local.brightwhiz\/how-to-install-postgresql-psql-on-almalinux-8-10-systems\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/local.brightwhiz\/how-to-install-postgresql-psql-on-almalinux-8-10-systems\/"]}]},{"@type":"BreadcrumbList","@id":"http:\/\/local.brightwhiz\/how-to-install-postgresql-psql-on-almalinux-8-10-systems\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/local.brightwhiz\/"},{"@type":"ListItem","position":2,"name":"How to Install PostgreSQL (psql) on AlmaLinux 8.10 Systems"}]},{"@type":"WebSite","@id":"http:\/\/local.brightwhiz\/#website","url":"http:\/\/local.brightwhiz\/","name":"Brightwhiz.com","description":"Best Tech guides, Tutorials, and News","publisher":{"@id":"http:\/\/local.brightwhiz\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/local.brightwhiz\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"http:\/\/local.brightwhiz\/#organization","name":"Brightwhiz","url":"http:\/\/local.brightwhiz\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/local.brightwhiz\/#\/schema\/logo\/image\/","url":"http:\/\/local.brightwhiz\/wp-content\/uploads\/2021\/11\/brightwhiz-com-logo-orange.png","contentUrl":"http:\/\/local.brightwhiz\/wp-content\/uploads\/2021\/11\/brightwhiz-com-logo-orange.png","width":706,"height":135,"caption":"Brightwhiz"},"image":{"@id":"http:\/\/local.brightwhiz\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/brightwhiz\/","https:\/\/x.com\/brightwhizmag","https:\/\/instagram.com\/bright_whiz\/","https:\/\/www.pinterest.com\/sobbayi\/","https:\/\/www.youtube.com\/channel\/UC6sCdP_d_RiTIM7ErFT-PSQ"]},{"@type":"Person","@id":"http:\/\/local.brightwhiz\/#\/schema\/person\/81f0f3126f13834ae2e7f381b3028e32","name":"Michael Bright","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/local.brightwhiz\/#\/schema\/person\/image\/","url":"http:\/\/1.gravatar.com\/avatar\/da90485875ff0aafa38fdd494abe87d1?s=96&d=mm&r=g","contentUrl":"http:\/\/1.gravatar.com\/avatar\/da90485875ff0aafa38fdd494abe87d1?s=96&d=mm&r=g","caption":"Michael Bright"},"sameAs":["https:\/\/sobbayi.com"],"url":"http:\/\/local.brightwhiz\/author\/sobbayiadmin\/"}]}},"_links":{"self":[{"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/posts\/14123"}],"collection":[{"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/comments?post=14123"}],"version-history":[{"count":2,"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/posts\/14123\/revisions"}],"predecessor-version":[{"id":14281,"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/posts\/14123\/revisions\/14281"}],"wp:attachment":[{"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/media?parent=14123"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/categories?post=14123"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/tags?post=14123"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}