{"id":161459,"date":"2026-03-16T18:51:22","date_gmt":"2026-03-16T15:51:22","guid":{"rendered":"https:\/\/cloudspinx.com\/?p=82334"},"modified":"2026-03-16T18:51:22","modified_gmt":"2026-03-16T15:51:22","slug":"install-postgresql-18-on-oracle-linux-10","status":"publish","type":"post","link":"https:\/\/computingforgeeks.com\/install-postgresql-18-on-oracle-linux-10\/","title":{"rendered":"Install PostgreSQL 18 on Oracle Linux 10"},"content":{"rendered":"\n<p>PostgreSQL is one of the most used database management systems. It is robust, highly available and easy to install. PostgreSQL is an open-source, advanced and enterprise class relational databases which supports both SQL (relational) and JSON (non-relational). It is a highly stable database system backed by a community of developers. It is used as a primary database for many web applications and also mobile and analytics applications. PostgresSQL supports a wide range of languages which include: Java, Python, C#, Ruby, JavaScript (Node.js), Perl, C\/C+, go and Tcl.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Features of PostgreSQL<\/h4>\n\n\n\n<p>PostgreSQL has many advanced features as compared to other database management systems. These include:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Table inheritance.<\/li>\n\n\n\n<li>Nested transactions.<\/li>\n\n\n\n<li>Multi-version concurrency control.<\/li>\n\n\n\n<li>Sophisticated locking mechanism.<\/li>\n\n\n\n<li>Foreign key referential integrity<\/li>\n\n\n\n<li>Asynchronous replication.<\/li>\n\n\n\n<li>Views, rules and subquery.<\/li>\n<\/ul>\n\n\n\n<p>The current versions of PostgreSQL support the following additional features.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Installing PostgreSQL 18 on Oracle Linux 10<\/h3>\n\n\n\n<p>The following steps guide on how to install PostgreSQL on Oracle Linux 10.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Step 1: Update system packages<\/h4>\n\n\n\n<p>It is always good to ensure that your system is up to date when carrying out installations.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo dnf update<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">Step 2: Add PostgreSQL repository<\/h4>\n\n\n\n<p>Use the below command to add the official PostgreSQL on Oracle Linux 10.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo dnf install -y https:\/\/download.postgresql.org\/pub\/repos\/yum\/reporpms\/EL-10-x86_64\/pgdg-redhat-repo-latest.noarch.rpm<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">Step 3: Install PostgreSQL on Oracle 12 on Oracle Linux 10<\/h4>\n\n\n\n<p>We need to disable any other existing PostgreSQL if there is then install PostgreSQL 18. Run the below commands:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo dnf module disable postgresql\nsudo dnf install -y postgresql18-server<\/code><\/pre>\n\n\n\n<p>When installation is complete, you should see an output as below:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"557\" src=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2025\/12\/Install-PostgreSQL-18-on-Oracle-Linux-10-01-scaled-1-1024x557.png\" alt=\"\" class=\"wp-image-91936\" title=\"\" srcset=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2025\/12\/Install-PostgreSQL-18-on-Oracle-Linux-10-01-scaled-1-1024x557.png 1024w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2025\/12\/Install-PostgreSQL-18-on-Oracle-Linux-10-01-scaled-1-300x163.png 300w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2025\/12\/Install-PostgreSQL-18-on-Oracle-Linux-10-01-scaled-1-768x418.png 768w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2025\/12\/Install-PostgreSQL-18-on-Oracle-Linux-10-01-scaled-1-1536x835.png 1536w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2025\/12\/Install-PostgreSQL-18-on-Oracle-Linux-10-01-scaled-1-2048x1114.png 2048w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2025\/12\/Install-PostgreSQL-18-on-Oracle-Linux-10-01-scaled-1-772x420.png 772w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2025\/12\/Install-PostgreSQL-18-on-Oracle-Linux-10-01-scaled-1-696x378.png 696w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2025\/12\/Install-PostgreSQL-18-on-Oracle-Linux-10-01-scaled-1-1068x580.png 1068w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Step 4: Initialize and start Database Service<\/h4>\n\n\n\n<p>We first need to initialize database before starting. Use the following command:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>$<mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-amber-color\"> sudo \/usr\/pgsql-18\/bin\/postgresql-18-setup initdb<\/mark>\nInitializing database --- OK<\/code><\/pre>\n\n\n\n<p>Now we can start and enable database service.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo systemctl enable --now postgresql-18<\/code><\/pre>\n\n\n\n<p>Confirm status if postgresql is running using the below command.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo systemctl status postgresql-18<\/code><\/pre>\n\n\n\n<p>The output should be as below if running:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"411\" src=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2025\/12\/Install-PostgreSQL-18-on-Oracle-Linux-10-02-1024x411.png\" alt=\"\" class=\"wp-image-91937\" title=\"\" srcset=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2025\/12\/Install-PostgreSQL-18-on-Oracle-Linux-10-02-1024x411.png 1024w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2025\/12\/Install-PostgreSQL-18-on-Oracle-Linux-10-02-300x120.png 300w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2025\/12\/Install-PostgreSQL-18-on-Oracle-Linux-10-02-768x308.png 768w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2025\/12\/Install-PostgreSQL-18-on-Oracle-Linux-10-02-1536x616.png 1536w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2025\/12\/Install-PostgreSQL-18-on-Oracle-Linux-10-02-2048x822.png 2048w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2025\/12\/Install-PostgreSQL-18-on-Oracle-Linux-10-02-1047x420.png 1047w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2025\/12\/Install-PostgreSQL-18-on-Oracle-Linux-10-02-696x279.png 696w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2025\/12\/Install-PostgreSQL-18-on-Oracle-Linux-10-02-1068x429.png 1068w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>If running Firewall service and remote clients should connect to your database server, allow&nbsp;PostgreSQL&nbsp;service.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo firewall-cmd --permanent --add-service=postgresql\nsudo firewall-cmd --reload<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">Step 5: Set PostgreSQL admin user<\/h4>\n\n\n\n<p>To set PostgreSQL admin user, run:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>$ <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-amber-color\">sudo su postgres<\/mark>\n$ <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-pale-pink-color\">psql -c \"alter user postgres with password '<\/mark><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-cyan-blue-color\">MyStrongPassword<\/mark><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-pale-pink-color\">'\"<\/mark>\nALTER ROLE<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">Step 6: Enable Remote Access<\/h4>\n\n\n\n<p>Edit Postgresql configuration file to set listen address. You can set to your system IP address or use \u2018*\u2019 for any.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo vim \/var\/lib\/pgsql\/18\/data\/postgresql.conf <\/code><\/pre>\n\n\n\n<p>Add listen address as shown:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>listen_addresses = <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-purple-color\">'192.168.100.178<\/mark>'\n#OR \nlisten_addresses = '<mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-ast-global-color-1-color\">0.0.0.0<\/mark>'<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"212\" src=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2025\/12\/Install-PostgreSQL-18-on-Oracle-Linux-10-03-1024x212.png\" alt=\"\" class=\"wp-image-91941\" title=\"\" srcset=\"https:\/\/computingforgeeks.com\/wp-content\/uploads\/2025\/12\/Install-PostgreSQL-18-on-Oracle-Linux-10-03-1024x212.png 1024w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2025\/12\/Install-PostgreSQL-18-on-Oracle-Linux-10-03-300x62.png 300w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2025\/12\/Install-PostgreSQL-18-on-Oracle-Linux-10-03-768x159.png 768w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2025\/12\/Install-PostgreSQL-18-on-Oracle-Linux-10-03-1536x318.png 1536w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2025\/12\/Install-PostgreSQL-18-on-Oracle-Linux-10-03-2048x424.png 2048w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2025\/12\/Install-PostgreSQL-18-on-Oracle-Linux-10-03-2030x420.png 2030w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2025\/12\/Install-PostgreSQL-18-on-Oracle-Linux-10-03-696x144.png 696w, https:\/\/computingforgeeks.com\/wp-content\/uploads\/2025\/12\/Install-PostgreSQL-18-on-Oracle-Linux-10-03-1068x221.png 1068w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Also allow remote connection by editing the shown the below file<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo vim \/var\/lib\/pgsql\/18\/data\/pg_hba.conf<\/code><\/pre>\n\n\n\n<p>Add the following content<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># Accept from anywhere\nhost all all 0.0.0.0\/0 md5\n# Accept from specific subnets\nhost all all 192.168.1.0\/24 md5<\/code><\/pre>\n\n\n\n<p>Restart database service after the changes<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo systemctl restart postgresql-18<\/code><\/pre>\n\n\n\n<p>Test remote connection by using the shown command:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>psql -U <em><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-pale-cyan-blue-color\">&lt;dbuser&gt;<\/mark><\/em> -h <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-light-green-cyan-color\"><em>&lt;serverip&gt;<\/em><\/mark> -p 5432 <em><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-pale-pink-color\">&lt;dbname&gt;<\/mark><\/em><\/code><\/pre>\n\n\n\n<p>This has been a step by step guide on how to install PostgreSQL on Oracle Linux 10.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/computingforgeeks.com\/how-to-install-postgresql-17-on-amazon-linux\/\">How To Install PostgreSQL 17 on Amazon Linux 2023<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/computingforgeeks.com\/how-to-install-postgresql-17-on-opensuse\/\">How To Install PostgreSQL 17 on openSUSE<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/computingforgeeks.com\/how-to-install-postgresql-17-on-oracle-linux\/\">How To Install PostgreSQL 17 on Oracle Linux 9<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>PostgreSQL is one of the most used database management systems. It is robust, highly available and easy to install. PostgreSQL is an open-source, advanced and enterprise class relational databases which supports both SQL (relational) and JSON (non-relational). It is a highly stable database system backed by a community of developers. It is used as a &#8230; <a title=\"Install PostgreSQL 18 on Oracle Linux 10\" class=\"read-more\" href=\"https:\/\/computingforgeeks.com\/install-postgresql-18-on-oracle-linux-10\/\" aria-label=\"Read more about Install PostgreSQL 18 on Oracle Linux 10\">Read more<\/a><\/p>\n","protected":false},"author":32,"featured_media":91946,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[461,299,47,50],"tags":[],"class_list":["post-161459","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-databases","category-how-to","category-linux","category-linux-tutorials"],"_links":{"self":[{"href":"https:\/\/computingforgeeks.com\/wp-json\/wp\/v2\/posts\/161459","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/computingforgeeks.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/computingforgeeks.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/computingforgeeks.com\/wp-json\/wp\/v2\/users\/32"}],"replies":[{"embeddable":true,"href":"https:\/\/computingforgeeks.com\/wp-json\/wp\/v2\/comments?post=161459"}],"version-history":[{"count":0,"href":"https:\/\/computingforgeeks.com\/wp-json\/wp\/v2\/posts\/161459\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/computingforgeeks.com\/wp-json\/wp\/v2\/media\/91946"}],"wp:attachment":[{"href":"https:\/\/computingforgeeks.com\/wp-json\/wp\/v2\/media?parent=161459"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/computingforgeeks.com\/wp-json\/wp\/v2\/categories?post=161459"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/computingforgeeks.com\/wp-json\/wp\/v2\/tags?post=161459"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}