{"id":106707,"date":"2024-03-01T11:30:00","date_gmt":"2024-03-01T16:30:00","guid":{"rendered":"https:\/\/jumpcloud.com\/?p=106707"},"modified":"2025-02-18T12:59:36","modified_gmt":"2025-02-18T17:59:36","slug":"how-to-install-postgresql-16-rhel-9","status":"publish","type":"post","link":"https:\/\/jumpcloud.com\/blog\/how-to-install-postgresql-16-rhel-9","title":{"rendered":"How to Install PostgreSQL 16 on RHEL 9"},"content":{"rendered":"\n<p><a class=\"wp-block-cgb-button button\" href=\"#step1\">Jump to Tutorial<\/a><\/p>\n\n\n\n<p><a href=\"https:\/\/www.postgresql.org\/\" target=\"_blank\" rel=\"noreferrer noopener\">PostgreSQL<\/a> is one of the leading and widely used open source relational database management systems (RDBMS) that stores structured data in tables, just like MySQL. It is used by developers in their tech stacks and even by large enterprises and corporations to store website and application data. PostgreSQL uses SQL query language to store and manipulate data and also provides JSON support.<\/p>\n\n\n\n<p>At the time of publishing this guide, PostgreSQL 16 is the latest PostgreSQL release. It was officially released on September 14, 2023, by the PostgreSQL Global Development Group and ships with major improvements and enhancements.<\/p>\n\n\n\n<p>Let&#8217;s have a glance at some of the new enhancements and features in PostgreSQL 16:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Logical Replication<\/h3>\n\n\n\n<p>PostgreSQL 16 includes significant logical replication enhancements to its existing replication feature. The latest update allows developers to initiate logical replication from a standby instance. This implies that standbys can publish changes to other servers, offering added flexibility in replication setups and support for complex data architectures.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Enhanced Monitoring<\/h3>\n\n\n\n<p>To enhance the monitoring of various database metrics, PostgreSQL 16 provides pg_stat_io, a statistics view feature that offers deeper insights into the I\/O activity of your database server. It performs a granular analysis of I\/O access patterns, thus allowing better visibility and troubleshooting.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Access Control and Security<\/h3>\n\n\n\n<p>The latest release fine-tunes access control by refining user roles and privileges and improving the management of pg_hba.conf and pg_ident.conf files.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">CPU Acceleration Using SIMD<\/h3>\n\n\n\n<p>PostgreSQL 16 introduces CPU acceleration using SIMD (Single Instruction, Multiple Data) on both x86\/x86_64 and AArch64 architectures.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Bulk Data Loading<\/h3>\n\n\n\n<p>Bulk processing has been optimized in PostgreSQL 16. As the name implies, bulk loading is a process of loading enormous amounts of data into the database in the shortest time possible. This allows the insertion of many rows in a table in a relatively short period.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Additional Enhancements<\/h3>\n\n\n\n<p>Other improvements that ship with PostgreSQL include improved JSON support, security improvements, enhancement in parallel execution, and much more. <\/p>\n\n\n\n<p>Check out the <a href=\"https:\/\/www.postgresql.org\/about\/news\/postgresql-16-released-2715\/\" target=\"_blank\" rel=\"noreferrer noopener\">PostgreSQL 16 release notes<\/a> for more information. Let\u2019s now look at how to install PostgreSQL 16 on RHEL 9.<\/p>\n\n\n\n<figure class=\"image is-16by9\">\n<iframe class=\"has-ratio\" width=\"300\" height=\"315\" src=\"https:\/\/www.youtube.com\/embed\/GRFrciSNx_I?rel=0\" frameborder=\"0\" allow=\"accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen=\"\"><\/iframe>\n<\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"step1\">Step 1: Add the PostgreSQL Repository<\/h2>\n\n\n\n<p>To get started, log into your server and update the packages to their current versions. In our case, our server has already been updated.<\/p>\n\n\n\n<div class=\"wp-block-cgb-code-block code-block\"><div class=\"code-block-snippet is-type-body-default\">\n<p>$ sudo dnf update -y<\/p>\n<\/div><\/div>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"512\" height=\"103\" src=\"https:\/\/jumpcloud.com\/wp-content\/uploads\/2024\/02\/1-6.png\" alt=\"tutorial code\" class=\"wp-image-106724\" srcset=\"https:\/\/jumpcloud.com\/wp-content\/uploads\/2024\/02\/1-6.png 512w, https:\/\/jumpcloud.com\/wp-content\/uploads\/2024\/02\/1-6-300x60.png 300w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><\/figure>\n\n\n\n<p>To install PostgreSQL 16, which is the latest PostgreSQL version at the time of writing this guide, you need to add the PostgreSQL repository for RHEL 9 as shown.<\/p>\n\n\n\n<div class=\"wp-block-cgb-code-block code-block\"><div class=\"code-block-snippet is-type-body-default\">\n<p>$ sudo dnf install https:\/\/download.postgresql.org\/pub\/repos\/yum\/reporpms\/EL-9-x86_64\/pgdg-redhat-repo-latest.noarch.rpm -y<\/p>\n<\/div><\/div>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"512\" height=\"208\" src=\"https:\/\/jumpcloud.com\/wp-content\/uploads\/2024\/02\/2-6.png\" alt=\"tutorial code\" class=\"wp-image-106719\" srcset=\"https:\/\/jumpcloud.com\/wp-content\/uploads\/2024\/02\/2-6.png 512w, https:\/\/jumpcloud.com\/wp-content\/uploads\/2024\/02\/2-6-300x122.png 300w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><\/figure>\n\n\n\n<p>Next, disable the built-in PostgreSQL module.<\/p>\n\n\n\n<div class=\"wp-block-cgb-code-block code-block\"><div class=\"code-block-snippet is-type-body-default\">\n<p>$ sudo dnf -qy module disable postgresql<\/p>\n<\/div><\/div>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"512\" height=\"118\" src=\"https:\/\/jumpcloud.com\/wp-content\/uploads\/2024\/02\/3-6.png\" alt=\"tutorial code\" class=\"wp-image-106717\" srcset=\"https:\/\/jumpcloud.com\/wp-content\/uploads\/2024\/02\/3-6.png 512w, https:\/\/jumpcloud.com\/wp-content\/uploads\/2024\/02\/3-6-300x69.png 300w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"step2\">Step 2: Install PostgreSQL 16 on RHEL 9<\/h2>\n\n\n\n<p>Once the PostgreSQL repository has been added, proceed and install PostgreSQL by running the following DNF command:<\/p>\n\n\n\n<div class=\"wp-block-cgb-code-block code-block\"><div class=\"code-block-snippet is-type-body-default\">\n<p>$ sudo dnf install postgresql16-server -y<\/p>\n<\/div><\/div>\n\n\n\n<p>The command installs the PostgreSQL server alongside other packages and dependencies.&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"512\" height=\"206\" src=\"https:\/\/jumpcloud.com\/wp-content\/uploads\/2024\/02\/4-6.png\" alt=\"tutorial code\" class=\"wp-image-106714\" srcset=\"https:\/\/jumpcloud.com\/wp-content\/uploads\/2024\/02\/4-6.png 512w, https:\/\/jumpcloud.com\/wp-content\/uploads\/2024\/02\/4-6-300x121.png 300w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><\/figure>\n\n\n\n<p>Once installed, be sure to initialize the database as shown.<\/p>\n\n\n\n<div class=\"wp-block-cgb-code-block code-block\"><div class=\"code-block-snippet is-type-body-default\">\n<p>$ sudo \/usr\/pgsql-16\/bin\/postgresql-16-setup initdb<\/p>\n<\/div><\/div>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"512\" height=\"75\" src=\"https:\/\/jumpcloud.com\/wp-content\/uploads\/2024\/02\/5-6.png\" alt=\"tutorial code\" class=\"wp-image-106713\" srcset=\"https:\/\/jumpcloud.com\/wp-content\/uploads\/2024\/02\/5-6.png 512w, https:\/\/jumpcloud.com\/wp-content\/uploads\/2024\/02\/5-6-300x44.png 300w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"step3\">Step 3: How to Manage the PostgreSQL Service<\/h2>\n\n\n\n<p>So far, we have managed to install PostgreSQL 16 on RHEL 9. In this section, we explore how to manage the service.<\/p>\n\n\n\n<p>To set the PostgreSQL service to auto-start every time upon booting, run the command:<\/p>\n\n\n\n<div class=\"wp-block-cgb-code-block code-block\"><div class=\"code-block-snippet is-type-body-default\">\n<p>$ sudo systemctl enable postgresql-16 <\/p>\n<\/div><\/div>\n\n\n\n<p>By default, PostgreSQL does not start automatically. To start it, run the command:<\/p>\n\n\n\n<div class=\"wp-block-cgb-code-block code-block\"><div class=\"code-block-snippet is-type-body-default\">\n<p>$ sudo systemctl start postgresql-16<\/p>\n<\/div><\/div>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"512\" height=\"99\" src=\"https:\/\/jumpcloud.com\/wp-content\/uploads\/2024\/02\/6-6.png\" alt=\"tutorial code\" class=\"wp-image-106725\" srcset=\"https:\/\/jumpcloud.com\/wp-content\/uploads\/2024\/02\/6-6.png 512w, https:\/\/jumpcloud.com\/wp-content\/uploads\/2024\/02\/6-6-300x58.png 300w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><\/figure>\n\n\n\n<p>To verify that the service is running, execute the command:<\/p>\n\n\n\n<div class=\"wp-block-cgb-code-block code-block\"><div class=\"code-block-snippet is-type-body-default\">\n<p>$ sudo systemctl status postgresql-16<\/p>\n<\/div><\/div>\n\n\n\n<p>The following output confirms that PostgreSQL is up and running.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"512\" height=\"123\" src=\"https:\/\/jumpcloud.com\/wp-content\/uploads\/2024\/02\/7-6.png\" alt=\"tutorial code\" class=\"wp-image-106720\" srcset=\"https:\/\/jumpcloud.com\/wp-content\/uploads\/2024\/02\/7-6.png 512w, https:\/\/jumpcloud.com\/wp-content\/uploads\/2024\/02\/7-6-300x72.png 300w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><\/figure>\n\n\n\n<p>To restart the database server, run the command:<\/p>\n\n\n\n<div class=\"wp-block-cgb-code-block code-block\"><div class=\"code-block-snippet is-type-body-default\">\n<p>$ sudo systemctl restart postgresql-16<\/p>\n<\/div><\/div>\n\n\n\n<p>You can also reload the database server without stopping the service.<\/p>\n\n\n\n<div class=\"wp-block-cgb-code-block code-block\"><div class=\"code-block-snippet is-type-body-default\">\n<p>$ sudo systemctl reload postgresql-16<\/p>\n<\/div><\/div>\n\n\n\n<p>To check the version of PostgreSQL on your server, run the following command:&nbsp;<\/p>\n\n\n\n<div class=\"wp-block-cgb-code-block code-block\"><div class=\"code-block-snippet is-type-body-default\">\n<p>$ psql -V<\/p>\n<\/div><\/div>\n\n\n\n<p>The output confirms that we are running PostgreSQL 16.0.&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"512\" height=\"108\" src=\"https:\/\/jumpcloud.com\/wp-content\/uploads\/2024\/02\/8-5.png\" alt=\"tutorial code\" class=\"wp-image-106718\" srcset=\"https:\/\/jumpcloud.com\/wp-content\/uploads\/2024\/02\/8-5.png 512w, https:\/\/jumpcloud.com\/wp-content\/uploads\/2024\/02\/8-5-300x63.png 300w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"step4\">Step 4: How to Enable Authentication in PostgreSQL<\/h2>\n\n\n\n<div class=\"wp-block-cgb-notification-card notification-card note\"><div class=\"notification-card-content\"><div class=\"notification-card-icon\"><p><img decoding=\"async\" src=\"\/wp-content\/themes\/jumpcloud\/assets\/images\/gutenberg-blocks\/note-icon.png\"\/><\/p><\/div><div class=\"notification-card-copy is-type-body-default\"><p><strong>Note:<\/strong> Follow the principle of least privilege when configuring your system. It\u2019s always best to assign privileges to an unprivileged role.<\/p><\/div><\/div><\/div>\n\n\n\n<p>During installation, a UNIX user called Postgres is created. This user is also the super-user for the PostgreSQL database and has full administrative privileges.&nbsp;<\/p>\n\n\n\n<p>However, the Postgres user does not have a password and you can access the database server without authentication. To demonstrate this, simply access the PostgreSQL shell as shown.<\/p>\n\n\n\n<div class=\"wp-block-cgb-code-block code-block\"><div class=\"code-block-snippet is-type-body-default\">\n<p>$ sudo -u postgres psql<\/p>\n<\/div><\/div>\n\n\n\n<p>To quit the shell, run the <strong>\\q<\/strong> command:<\/p>\n\n\n\n<div class=\"wp-block-cgb-code-block code-block\"><div class=\"code-block-snippet is-type-body-default\">\n<p># \\q<\/p>\n<\/div><\/div>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"512\" height=\"190\" src=\"https:\/\/jumpcloud.com\/wp-content\/uploads\/2024\/02\/9-5.png\" alt=\"tutorial code\" class=\"wp-image-106715\" srcset=\"https:\/\/jumpcloud.com\/wp-content\/uploads\/2024\/02\/9-5.png 512w, https:\/\/jumpcloud.com\/wp-content\/uploads\/2024\/02\/9-5-300x111.png 300w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><\/figure>\n\n\n\n<p>As you can see, we were not prompted for a password. Accessing the database server without authentication could pose a huge security risk, and for this reason, we need to set a password for the Postgres user.&nbsp;<\/p>\n\n\n\n<p>Therefore, access the psql prompt again.<\/p>\n\n\n\n<div class=\"wp-block-cgb-code-block code-block\"><div class=\"code-block-snippet is-type-body-default\">\n<p>$ sudo -u postgres psql<\/p>\n<\/div><\/div>\n\n\n\n<p>Next, run the following command to set a password for the Postgres user:<\/p>\n\n\n\n<div class=\"wp-block-cgb-code-block code-block\"><div class=\"code-block-snippet is-type-body-default\">\n<p>\\password postgres<\/p>\n<\/div><\/div>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"512\" height=\"176\" src=\"https:\/\/jumpcloud.com\/wp-content\/uploads\/2024\/02\/10-4.png\" alt=\"tutorial code\" class=\"wp-image-106716\" srcset=\"https:\/\/jumpcloud.com\/wp-content\/uploads\/2024\/02\/10-4.png 512w, https:\/\/jumpcloud.com\/wp-content\/uploads\/2024\/02\/10-4-300x103.png 300w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><\/figure>\n\n\n\n<p>Finally, exit the psql prompt.<\/p>\n\n\n\n<div class=\"wp-block-cgb-code-block code-block\"><div class=\"code-block-snippet is-type-body-default\">\n<p>\\q<\/p>\n<\/div><\/div>\n\n\n\n<p>Next, access the PostgreSQL access policy configuration file.<\/p>\n\n\n\n<div class=\"wp-block-cgb-code-block code-block\"><div class=\"code-block-snippet is-type-body-default\">\n<p>$ sudo vim \/var\/lib\/pgsql\/16\/data\/pg_hba.conf<\/p>\n<\/div><\/div>\n\n\n\n<p>Locate the line that starts with <strong>local <\/strong>and change the attribute <strong>peer <\/strong>to <strong>md5 <\/strong>to enable md5 authentication.&nbsp;<\/p>\n\n\n\n<div class=\"wp-block-cgb-code-block code-block\"><div class=\"code-block-snippet is-type-body-default\">\n<p>local  all  all  md5<\/p>\n<\/div><\/div>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"512\" height=\"111\" src=\"https:\/\/jumpcloud.com\/wp-content\/uploads\/2024\/02\/11-3.png\" alt=\"tutorial code\" class=\"wp-image-106721\" srcset=\"https:\/\/jumpcloud.com\/wp-content\/uploads\/2024\/02\/11-3.png 512w, https:\/\/jumpcloud.com\/wp-content\/uploads\/2024\/02\/11-3-300x65.png 300w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><\/figure>\n\n\n\n<p>Save the changes and exit. Then reload PostgreSQL for the changes to come into effect.<\/p>\n\n\n\n<div class=\"wp-block-cgb-code-block code-block\"><div class=\"code-block-snippet is-type-body-default\">\n<p>$ sudo systemctl reload postgresql-16<\/p>\n<\/div><\/div>\n\n\n\n<p>When you access the psql shell, this time around, you will be required to provide a password. Type it in and hit ENTER.<\/p>\n\n\n\n<p>To list all the database users, run the query:<\/p>\n\n\n\n<div class=\"wp-block-cgb-code-block code-block\"><div class=\"code-block-snippet is-type-body-default\">\n<p># \\du<\/p>\n<\/div><\/div>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"512\" height=\"169\" src=\"https:\/\/jumpcloud.com\/wp-content\/uploads\/2024\/02\/12-3.png\" alt=\"tutorial code\" class=\"wp-image-106722\" srcset=\"https:\/\/jumpcloud.com\/wp-content\/uploads\/2024\/02\/12-3.png 512w, https:\/\/jumpcloud.com\/wp-content\/uploads\/2024\/02\/12-3-300x99.png 300w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><\/figure>\n\n\n\n<p>To list all the existing databases on the server, run the query:<\/p>\n\n\n\n<div class=\"wp-block-cgb-code-block code-block\"><div class=\"code-block-snippet is-type-body-default\">\n<p>\\l<\/p>\n<\/div><\/div>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"512\" height=\"97\" src=\"https:\/\/jumpcloud.com\/wp-content\/uploads\/2024\/02\/13-5.png\" alt=\"tutorial code\" class=\"wp-image-106723\" srcset=\"https:\/\/jumpcloud.com\/wp-content\/uploads\/2024\/02\/13-5.png 512w, https:\/\/jumpcloud.com\/wp-content\/uploads\/2024\/02\/13-5-300x57.png 300w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Conclusion<\/strong><\/h2>\n\n\n\n<p>In this guide, we have demonstrated how to install PostgreSQL 16 on RHEL 9. We have further demonstrated how to enable authentication and perform basic database operations.&nbsp;<\/p>\n\n\n\n<p>It\u2019s advisable to consult with a network security specialist to establish the appropriate firewall setup as well as network and transport-level security settings to harden your database. The database can be protected through the use of its built-in roles and features such as row-level security. It also has built-in auditing capabilities for auditing and visibility into events such as SQL statements being executed.<\/p>\n\n\n\n<p>If you\u2019d like to develop more RHEL 9 skills, check out the following tutorials:<\/p>\n\n\n\n<ul>\n<li><a href=\"https:\/\/jumpcloud.com\/blog\/how-to-install-php-8-rhel-9\">How to Install PHP 8 on RHEL 9<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/jumpcloud.com\/blog\/how-to-install-mariadb-rhel-9\">How to Install &amp; Secure MariaDB in RHEL 9<\/a>&nbsp;<\/li>\n\n\n\n<li><a href=\"https:\/\/jumpcloud.com\/blog\/how-to-install-node-js-20-rocky-linux-9-rhel-9\">How to Install Node.js 20 on RHEL 9<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Learn how to install PostgreSQL 16 on RHEL 9 in this tutorial.<\/p>\n","protected":false},"author":150,"featured_media":106714,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_oasis_is_in_workflow":0,"_oasis_original":0,"_oasis_task_priority":"","inline_featured_image":false,"footnotes":""},"categories":[2781],"tags":[],"collection":[],"platform":[],"funnel_stage":[3017],"coauthors":[2535],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v22.9 (Yoast SEO v22.9) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Install PostgreSQL 16 on RHEL 9 - JumpCloud<\/title>\n<meta name=\"description\" content=\"Learn how to install PostgreSQL 16 on RHEL 9 in this tutorial.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jumpcloud.com\/blog\/how-to-install-postgresql-16-rhel-9\" \/>\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 16 on RHEL 9\" \/>\n<meta property=\"og:description\" content=\"Learn how to install PostgreSQL 16 on RHEL 9 in this tutorial.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jumpcloud.com\/blog\/how-to-install-postgresql-16-rhel-9\" \/>\n<meta property=\"og:site_name\" content=\"JumpCloud\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-01T16:30:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-02-18T17:59:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/jumpcloud.com\/wp-content\/uploads\/2024\/02\/4-6.png\" \/>\n\t<meta property=\"og:image:width\" content=\"512\" \/>\n\t<meta property=\"og:image:height\" content=\"206\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"David Worthington\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"David Worthington\" \/>\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:\/\/jumpcloud.com\/blog\/how-to-install-postgresql-16-rhel-9#article\",\"isPartOf\":{\"@id\":\"https:\/\/jumpcloud.com\/blog\/how-to-install-postgresql-16-rhel-9\"},\"author\":{\"name\":\"David Worthington\",\"@id\":\"https:\/\/jumpcloud.com\/#\/schema\/person\/185ca12034835ee50ee17b100abdfb2e\"},\"headline\":\"How to Install PostgreSQL 16 on RHEL 9\",\"datePublished\":\"2024-03-01T16:30:00+00:00\",\"dateModified\":\"2025-02-18T17:59:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jumpcloud.com\/blog\/how-to-install-postgresql-16-rhel-9\"},\"wordCount\":1033,\"publisher\":{\"@id\":\"https:\/\/jumpcloud.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/jumpcloud.com\/blog\/how-to-install-postgresql-16-rhel-9#primaryimage\"},\"thumbnailUrl\":\"https:\/\/jumpcloud.com\/wp-content\/uploads\/2024\/02\/4-6.png\",\"articleSection\":[\"How-To\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jumpcloud.com\/blog\/how-to-install-postgresql-16-rhel-9\",\"url\":\"https:\/\/jumpcloud.com\/blog\/how-to-install-postgresql-16-rhel-9\",\"name\":\"How to Install PostgreSQL 16 on RHEL 9 - JumpCloud\",\"isPartOf\":{\"@id\":\"https:\/\/jumpcloud.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/jumpcloud.com\/blog\/how-to-install-postgresql-16-rhel-9#primaryimage\"},\"image\":{\"@id\":\"https:\/\/jumpcloud.com\/blog\/how-to-install-postgresql-16-rhel-9#primaryimage\"},\"thumbnailUrl\":\"https:\/\/jumpcloud.com\/wp-content\/uploads\/2024\/02\/4-6.png\",\"datePublished\":\"2024-03-01T16:30:00+00:00\",\"dateModified\":\"2025-02-18T17:59:36+00:00\",\"description\":\"Learn how to install PostgreSQL 16 on RHEL 9 in this tutorial.\",\"breadcrumb\":{\"@id\":\"https:\/\/jumpcloud.com\/blog\/how-to-install-postgresql-16-rhel-9#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jumpcloud.com\/blog\/how-to-install-postgresql-16-rhel-9\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jumpcloud.com\/blog\/how-to-install-postgresql-16-rhel-9#primaryimage\",\"url\":\"https:\/\/jumpcloud.com\/wp-content\/uploads\/2024\/02\/4-6.png\",\"contentUrl\":\"https:\/\/jumpcloud.com\/wp-content\/uploads\/2024\/02\/4-6.png\",\"width\":512,\"height\":206,\"caption\":\"tutorial code\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jumpcloud.com\/blog\/how-to-install-postgresql-16-rhel-9#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jumpcloud.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Install PostgreSQL 16 on RHEL 9\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jumpcloud.com\/#website\",\"url\":\"https:\/\/jumpcloud.com\/\",\"name\":\"JumpCloud\",\"description\":\"Daily insights on directory services, IAM, LDAP, identity security, SSO, system management (Mac, Windows, Linux), networking, and the cloud.\",\"publisher\":{\"@id\":\"https:\/\/jumpcloud.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jumpcloud.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jumpcloud.com\/#organization\",\"name\":\"JumpCloud\",\"url\":\"https:\/\/jumpcloud.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jumpcloud.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jumpcloud.com\/wp-content\/uploads\/2021\/01\/jc-logo-brand-2021.png\",\"contentUrl\":\"https:\/\/jumpcloud.com\/wp-content\/uploads\/2021\/01\/jc-logo-brand-2021.png\",\"width\":598,\"height\":101,\"caption\":\"JumpCloud\"},\"image\":{\"@id\":\"https:\/\/jumpcloud.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jumpcloud.com\/#\/schema\/person\/185ca12034835ee50ee17b100abdfb2e\",\"name\":\"David Worthington\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jumpcloud.com\/#\/schema\/person\/image\/d9acf1381c6e5b50c0f50d47b7b05411\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a6dde901b469c9005c22973e42038d62?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a6dde901b469c9005c22973e42038d62?s=96&d=mm&r=g\",\"caption\":\"David Worthington\"},\"description\":\"I'm the JumpCloud Champion for Product, Security. JumpCloud and Microsoft certified, security analyst, a one-time tech journalist, and former IT director.\",\"sameAs\":[\"https:\/\/jumpcloud.com\/blog\",\"david.worthington@jumpcloud.com\"]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to Install PostgreSQL 16 on RHEL 9 - JumpCloud","description":"Learn how to install PostgreSQL 16 on RHEL 9 in this tutorial.","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:\/\/jumpcloud.com\/blog\/how-to-install-postgresql-16-rhel-9","og_locale":"en_US","og_type":"article","og_title":"How to Install PostgreSQL 16 on RHEL 9","og_description":"Learn how to install PostgreSQL 16 on RHEL 9 in this tutorial.","og_url":"https:\/\/jumpcloud.com\/blog\/how-to-install-postgresql-16-rhel-9","og_site_name":"JumpCloud","article_published_time":"2024-03-01T16:30:00+00:00","article_modified_time":"2025-02-18T17:59:36+00:00","og_image":[{"width":512,"height":206,"url":"https:\/\/jumpcloud.com\/wp-content\/uploads\/2024\/02\/4-6.png","type":"image\/png"}],"author":"David Worthington","twitter_card":"summary_large_image","twitter_misc":{"Written by":"David Worthington","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jumpcloud.com\/blog\/how-to-install-postgresql-16-rhel-9#article","isPartOf":{"@id":"https:\/\/jumpcloud.com\/blog\/how-to-install-postgresql-16-rhel-9"},"author":{"name":"David Worthington","@id":"https:\/\/jumpcloud.com\/#\/schema\/person\/185ca12034835ee50ee17b100abdfb2e"},"headline":"How to Install PostgreSQL 16 on RHEL 9","datePublished":"2024-03-01T16:30:00+00:00","dateModified":"2025-02-18T17:59:36+00:00","mainEntityOfPage":{"@id":"https:\/\/jumpcloud.com\/blog\/how-to-install-postgresql-16-rhel-9"},"wordCount":1033,"publisher":{"@id":"https:\/\/jumpcloud.com\/#organization"},"image":{"@id":"https:\/\/jumpcloud.com\/blog\/how-to-install-postgresql-16-rhel-9#primaryimage"},"thumbnailUrl":"https:\/\/jumpcloud.com\/wp-content\/uploads\/2024\/02\/4-6.png","articleSection":["How-To"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jumpcloud.com\/blog\/how-to-install-postgresql-16-rhel-9","url":"https:\/\/jumpcloud.com\/blog\/how-to-install-postgresql-16-rhel-9","name":"How to Install PostgreSQL 16 on RHEL 9 - JumpCloud","isPartOf":{"@id":"https:\/\/jumpcloud.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/jumpcloud.com\/blog\/how-to-install-postgresql-16-rhel-9#primaryimage"},"image":{"@id":"https:\/\/jumpcloud.com\/blog\/how-to-install-postgresql-16-rhel-9#primaryimage"},"thumbnailUrl":"https:\/\/jumpcloud.com\/wp-content\/uploads\/2024\/02\/4-6.png","datePublished":"2024-03-01T16:30:00+00:00","dateModified":"2025-02-18T17:59:36+00:00","description":"Learn how to install PostgreSQL 16 on RHEL 9 in this tutorial.","breadcrumb":{"@id":"https:\/\/jumpcloud.com\/blog\/how-to-install-postgresql-16-rhel-9#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jumpcloud.com\/blog\/how-to-install-postgresql-16-rhel-9"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jumpcloud.com\/blog\/how-to-install-postgresql-16-rhel-9#primaryimage","url":"https:\/\/jumpcloud.com\/wp-content\/uploads\/2024\/02\/4-6.png","contentUrl":"https:\/\/jumpcloud.com\/wp-content\/uploads\/2024\/02\/4-6.png","width":512,"height":206,"caption":"tutorial code"},{"@type":"BreadcrumbList","@id":"https:\/\/jumpcloud.com\/blog\/how-to-install-postgresql-16-rhel-9#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jumpcloud.com\/"},{"@type":"ListItem","position":2,"name":"How to Install PostgreSQL 16 on RHEL 9"}]},{"@type":"WebSite","@id":"https:\/\/jumpcloud.com\/#website","url":"https:\/\/jumpcloud.com\/","name":"JumpCloud","description":"Daily insights on directory services, IAM, LDAP, identity security, SSO, system management (Mac, Windows, Linux), networking, and the cloud.","publisher":{"@id":"https:\/\/jumpcloud.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jumpcloud.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jumpcloud.com\/#organization","name":"JumpCloud","url":"https:\/\/jumpcloud.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jumpcloud.com\/#\/schema\/logo\/image\/","url":"https:\/\/jumpcloud.com\/wp-content\/uploads\/2021\/01\/jc-logo-brand-2021.png","contentUrl":"https:\/\/jumpcloud.com\/wp-content\/uploads\/2021\/01\/jc-logo-brand-2021.png","width":598,"height":101,"caption":"JumpCloud"},"image":{"@id":"https:\/\/jumpcloud.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jumpcloud.com\/#\/schema\/person\/185ca12034835ee50ee17b100abdfb2e","name":"David Worthington","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jumpcloud.com\/#\/schema\/person\/image\/d9acf1381c6e5b50c0f50d47b7b05411","url":"https:\/\/secure.gravatar.com\/avatar\/a6dde901b469c9005c22973e42038d62?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a6dde901b469c9005c22973e42038d62?s=96&d=mm&r=g","caption":"David Worthington"},"description":"I'm the JumpCloud Champion for Product, Security. JumpCloud and Microsoft certified, security analyst, a one-time tech journalist, and former IT director.","sameAs":["https:\/\/jumpcloud.com\/blog","david.worthington@jumpcloud.com"]}]}},"_links":{"self":[{"href":"https:\/\/jumpcloud.com\/wp-json\/wp\/v2\/posts\/106707"}],"collection":[{"href":"https:\/\/jumpcloud.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jumpcloud.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jumpcloud.com\/wp-json\/wp\/v2\/users\/150"}],"replies":[{"embeddable":true,"href":"https:\/\/jumpcloud.com\/wp-json\/wp\/v2\/comments?post=106707"}],"version-history":[{"count":3,"href":"https:\/\/jumpcloud.com\/wp-json\/wp\/v2\/posts\/106707\/revisions"}],"predecessor-version":[{"id":121357,"href":"https:\/\/jumpcloud.com\/wp-json\/wp\/v2\/posts\/106707\/revisions\/121357"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/jumpcloud.com\/wp-json\/wp\/v2\/media\/106714"}],"wp:attachment":[{"href":"https:\/\/jumpcloud.com\/wp-json\/wp\/v2\/media?parent=106707"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jumpcloud.com\/wp-json\/wp\/v2\/categories?post=106707"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jumpcloud.com\/wp-json\/wp\/v2\/tags?post=106707"},{"taxonomy":"collection","embeddable":true,"href":"https:\/\/jumpcloud.com\/wp-json\/wp\/v2\/collection?post=106707"},{"taxonomy":"platform","embeddable":true,"href":"https:\/\/jumpcloud.com\/wp-json\/wp\/v2\/platform?post=106707"},{"taxonomy":"funnel_stage","embeddable":true,"href":"https:\/\/jumpcloud.com\/wp-json\/wp\/v2\/funnel_stage?post=106707"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/jumpcloud.com\/wp-json\/wp\/v2\/coauthors?post=106707"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}