{"id":1807,"date":"2018-12-03T04:15:38","date_gmt":"2018-12-03T04:15:38","guid":{"rendered":"https:\/\/www.hostnic.id\/blog\/?p=1807"},"modified":"2018-12-03T04:15:38","modified_gmt":"2018-12-03T04:15:38","slug":"cara-install-dan-setup-postgresql-di-rhel-8-centos-7","status":"publish","type":"post","link":"https:\/\/www.hostnic.id\/blog\/tutorial\/linux\/cara-install-dan-setup-postgresql-di-rhel-8-centos-7\/","title":{"rendered":"Cara install dan setup PostgreSQL di RHEL 8 \/ Centos 7"},"content":{"rendered":"<p>Bagaimana cara menginstal manajemen basis data PostgreSQL di RHEL 8 atau Centos 7 menggunakan perintah? Bagaimana cara menginstal dan mengatur PostgreSQL di RHEL 8 server?<\/p>\n<p><strong>Pendahuluan:<\/strong> PostgreSQL adalah gratis dan open dari ORDBMS (sistem manajemen database objek-relasional). Ini adalah basis data sumber terbuka paling canggih di dunia. Halaman ini menunjukkan cara menginstal PostgreSQL di RHEL 8 dan mengkonfigurasi nya dari server database.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_75 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Daftar Isi<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-69e17b0a04077\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-69e17b0a04077\"  aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.hostnic.id\/blog\/tutorial\/linux\/cara-install-dan-setup-postgresql-di-rhel-8-centos-7\/#Cara_install_dan_setup_PostgreSQL_di_RHEL_8_Centos_7\" >Cara install dan setup PostgreSQL di RHEL 8 \/ Centos 7<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.hostnic.id\/blog\/tutorial\/linux\/cara-install-dan-setup-postgresql-di-rhel-8-centos-7\/#Cara_melihat_semua_list_PostgreSQL_application_streams\" >Cara melihat semua list PostgreSQL application streams<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.hostnic.id\/blog\/tutorial\/linux\/cara-install-dan-setup-postgresql-di-rhel-8-centos-7\/#Cara_install_dan_menggunakan_PostgreSQL_di_RHEL_8\" >Cara install dan menggunakan PostgreSQL di RHEL 8<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.hostnic.id\/blog\/tutorial\/linux\/cara-install-dan-setup-postgresql-di-rhel-8-centos-7\/#Cara_untuk_initialisasi_PostgreSQL_database_baru\" >Cara untuk initialisasi PostgreSQL database baru<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.hostnic.id\/blog\/tutorial\/linux\/cara-install-dan-setup-postgresql-di-rhel-8-centos-7\/#Cara_setup_password_untuk_postgres_account\" >Cara setup password untuk postgres account<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.hostnic.id\/blog\/tutorial\/linux\/cara-install-dan-setup-postgresql-di-rhel-8-centos-7\/#Cara_menjalankanstoprestart_PostgreSQL_server\" >Cara menjalankan\/stop\/restart PostgreSQL server<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.hostnic.id\/blog\/tutorial\/linux\/cara-install-dan-setup-postgresql-di-rhel-8-centos-7\/#How_to_enable_the_PostgreSQL_server_at_boot_time_on_RHEL_8\" >How to enable the PostgreSQL server at boot time on RHEL 8<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.hostnic.id\/blog\/tutorial\/linux\/cara-install-dan-setup-postgresql-di-rhel-8-centos-7\/#How_do_I_log_in_using_psql\" >How do I log in using psql?<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.hostnic.id\/blog\/tutorial\/linux\/cara-install-dan-setup-postgresql-di-rhel-8-centos-7\/#How_to_create_a_new_PostgreSQL_user_account\" >How to create a new PostgreSQL user account<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.hostnic.id\/blog\/tutorial\/linux\/cara-install-dan-setup-postgresql-di-rhel-8-centos-7\/#How_do_I_connect_to_jerry_database_with_tom_user\" >How do I connect to jerry database with tom user?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/www.hostnic.id\/blog\/tutorial\/linux\/cara-install-dan-setup-postgresql-di-rhel-8-centos-7\/#How_to_create_a_new_table\" >How to create a new table<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/www.hostnic.id\/blog\/tutorial\/linux\/cara-install-dan-setup-postgresql-di-rhel-8-centos-7\/#Kesmipulan\" >Kesmipulan<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cara_install_dan_setup_PostgreSQL_di_RHEL_8_Centos_7\"><\/span>Cara install dan setup PostgreSQL di RHEL 8 \/ Centos 7<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ol>\n<li>Buka terminal Window<\/li>\n<li>Temukan version dari PostgreSQL yang kamu mau untuk di install:<br \/>\n<kbd><strong>sudo yum module list | grep postgresql<\/strong><\/kbd><\/li>\n<li>Install the default, PostgreSQL version 10 on RHEL 8:<br \/>\n<kbd><strong>sudo yum install @postgresql<\/strong><\/kbd><\/li>\n<li>Selanjtunya initialisasi PostgreSQL database baru di RHEL 8:<br \/>\n<kbd><strong>sudo postgresql-setup --initdb<\/strong><\/kbd><\/li>\n<\/ol>\n<p>Mari kita lihat semua command.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cara_melihat_semua_list_PostgreSQL_application_streams\"><\/span>Cara melihat semua list PostgreSQL application streams<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Jalankan perintah yum<\/p>\n<pre class=\"lang:default decode:true\">$ sudo yum module list | grep postgresql<\/pre>\n<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-147475\" src=\"https:\/\/i0.wp.com\/www.cyberciti.biz\/media\/new\/faq\/2018\/12\/How-to-see-a-list-of-all-available-PostgreSQL-versions-or-application-streams.png?resize=599%2C112&#038;ssl=1\" sizes=\"auto, (max-width: 599px) 85vw, 599px\" srcset=\"https:\/\/www.cyberciti.biz\/media\/new\/faq\/2018\/12\/How-to-see-a-list-of-all-available-PostgreSQL-versions-or-application-streams.png 599w, https:\/\/www.cyberciti.biz\/media\/new\/faq\/2018\/12\/How-to-see-a-list-of-all-available-PostgreSQL-versions-or-application-streams-300x56.png 300w\" alt=\"How to see a list of all available PostgreSQL versions or application streams\" width=\"599\" height=\"112\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cara_install_dan_menggunakan_PostgreSQL_di_RHEL_8\"><\/span>Cara install dan menggunakan PostgreSQL di RHEL 8<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>In the previous step, we saw that RHEL 8 shipped with two Applications streams for PostgreSQL server. To install PostgreSQL 9.6, run:<br \/>\n<code>$ sudo yum install @postgresql:9.6 <\/code><br \/>\nThe default is PostgreSQL 10, so running the following yum command installs the latest stable version:<br \/>\n<code>$ sudo yum install @postgresql<\/code><\/p>\n<figure id=\"attachment_147476\" class=\"wp-caption aligncenter\" style=\"width: 300px;\"><a href=\"https:\/\/i0.wp.com\/www.cyberciti.biz\/media\/new\/faq\/2018\/12\/Install-and-setup-PostgreSQL-on-RHEL-8.png?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-147476\" src=\"https:\/\/i0.wp.com\/www.cyberciti.biz\/media\/new\/faq\/2018\/12\/Install-and-setup-PostgreSQL-on-RHEL-8-300x263.png?resize=300%2C263&#038;ssl=1\" sizes=\"auto, (max-width: 300px) 85vw, 300px\" srcset=\"https:\/\/www.cyberciti.biz\/media\/new\/faq\/2018\/12\/Install-and-setup-PostgreSQL-on-RHEL-8-300x263.png 300w, https:\/\/www.cyberciti.biz\/media\/new\/faq\/2018\/12\/Install-and-setup-PostgreSQL-on-RHEL-8-1024x899.png 1024w, https:\/\/www.cyberciti.biz\/media\/new\/faq\/2018\/12\/Install-and-setup-PostgreSQL-on-RHEL-8.png 1181w\" alt=\"Install and setup PostgreSQL on RHEL 8\" width=\"300\" height=\"263\" \/><\/a><figcaption class=\"wp-caption-text\">Installing and use PostgreSQL on RHEL 8 using application streams (click to enlarge)<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Cara_untuk_initialisasi_PostgreSQL_database_baru\"><\/span>Cara untuk initialisasi PostgreSQL database baru<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The first action you perform after PostgreSQL server installation is to run the following command:<br \/>\n<code>$ sudo postgresql-setup --initdb<\/code><\/p>\n<figure id=\"attachment_147477\" class=\"wp-caption aligncenter\" style=\"width: 599px;\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-147477\" src=\"https:\/\/i0.wp.com\/www.cyberciti.biz\/media\/new\/faq\/2018\/12\/How-to-create-a-new-PostgreSQL-database-cluster-on-RHEL-8.png?resize=599%2C209&#038;ssl=1\" sizes=\"auto, (max-width: 599px) 85vw, 599px\" srcset=\"https:\/\/www.cyberciti.biz\/media\/new\/faq\/2018\/12\/How-to-create-a-new-PostgreSQL-database-cluster-on-RHEL-8.png 599w, https:\/\/www.cyberciti.biz\/media\/new\/faq\/2018\/12\/How-to-create-a-new-PostgreSQL-database-cluster-on-RHEL-8-300x105.png 300w\" alt=\"How to create a new PostgreSQL database cluster on RHEL 8\" width=\"599\" height=\"209\" \/><figcaption class=\"wp-caption-text\">Creating a new PostgreSQL database cluster on RHEL 8<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Cara_setup_password_untuk_postgres_account\"><\/span>Cara setup password untuk postgres account<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Jalankan perintah passwd untuk setup password:<br \/>\n<code>$ sudo passwd postgres<\/code><br \/>\nContoh output:<\/p>\n<pre class=\"lang:default decode:true\">Changing password for user postgres.\r\nNew password: \r\nRetype new password: \r\npasswd: all authentication tokens updated successfully.<\/pre>\n<h3><span class=\"ez-toc-section\" id=\"Cara_menjalankanstoprestart_PostgreSQL_server\"><\/span>Cara menjalankan\/stop\/restart PostgreSQL server<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>You need to use the systemctl command:<br \/>\n<code>sudo systemctl start postgresql ## <span style=\"color: #009900;\">&lt;-- start the server<\/span> ##<br \/>\nsudo systemctl stop postgresql ## <span style=\"color: #009900;\">&lt;-- stop the server<\/span> ##<br \/>\nsudo systemctl restart postgresql ## <span style=\"color: #009900;\">&lt;-- resstart the server<\/span> ##<br \/>\nsudo systemctl status postgresql ## <span style=\"color: #009900;\">&lt;-- get status of the server<\/span> ##<\/code><\/p>\n<h3><span class=\"ez-toc-section\" id=\"How_to_enable_the_PostgreSQL_server_at_boot_time_on_RHEL_8\"><\/span>How to enable the PostgreSQL server at boot time on RHEL 8<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Again use the systemctl command as follows:<br \/>\n<code>$ sudo systemctl enable postgresql<\/code><\/p>\n<figure id=\"attachment_147478\" class=\"wp-caption aligncenter\" style=\"width: 599px;\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-147478\" src=\"https:\/\/i0.wp.com\/www.cyberciti.biz\/media\/new\/faq\/2018\/12\/Start-stop-restart-PostgreSQL-server-on-RHEL-8.png?resize=599%2C400&#038;ssl=1\" sizes=\"auto, (max-width: 599px) 85vw, 599px\" srcset=\"https:\/\/www.cyberciti.biz\/media\/new\/faq\/2018\/12\/Start-stop-restart-PostgreSQL-server-on-RHEL-8.png 599w, https:\/\/www.cyberciti.biz\/media\/new\/faq\/2018\/12\/Start-stop-restart-PostgreSQL-server-on-RHEL-8-300x200.png 300w\" alt=\"Start stop restart PostgreSQL server on RHEL 8\" width=\"599\" height=\"400\" \/><figcaption class=\"wp-caption-text\">Start and enable the PostgreSQL server<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"How_do_I_log_in_using_psql\"><\/span>How do I log in using psql?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>You need to use the psql command. It is a terminal-based front-end to PostgreSQL server. It enables you to type in queries interactively. The installation script created a user named postgres. That is the default account for default database and roles. Let us log in as postgres using the sudo command:<br \/>\n<code>$ sudo -i -u postgres<\/code><br \/>\nRun it:<br \/>\n<code>$ psql<\/code><\/p>\n<figure id=\"attachment_147479\" class=\"wp-caption aligncenter\" style=\"width: 599px;\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-147479\" src=\"https:\/\/i0.wp.com\/www.cyberciti.biz\/media\/new\/faq\/2018\/12\/Login-to-PostgreSQL-Databases.png?resize=599%2C406&#038;ssl=1\" sizes=\"auto, (max-width: 599px) 85vw, 599px\" srcset=\"https:\/\/www.cyberciti.biz\/media\/new\/faq\/2018\/12\/Login-to-PostgreSQL-Databases.png 599w, https:\/\/www.cyberciti.biz\/media\/new\/faq\/2018\/12\/Login-to-PostgreSQL-Databases-300x203.png 300w\" alt=\"Login to PostgreSQL Databases\" width=\"599\" height=\"406\" \/><figcaption class=\"wp-caption-text\">Validating installation of PostgreSQL database server<\/figcaption><\/figure>\n<p>At <kbd>postgres=#<\/kbd> prompt type <kbd>\\q<\/kbd> to quit from the command-line interface to PostgreSQL server. Did you notice you logged into PostgreSQL without any password? Let us fix this by creating HBA config:<br \/>\n<code>$ sudo vi \/var\/lib\/pgsql\/data\/pg_hba.conf<\/code><br \/>\nFind lines that read as follows:<\/p>\n<div class=\"wp_syntax\" style=\"position: relative;\">\n<table>\n<tbody>\n<tr>\n<td class=\"code\">\n<pre class=\"lang:default decode:true\"># IPv4 local connections:\r\nhost    all             all             127.0.0.1\/32            ident\r\n# IPv6 local connections:\r\nhost    all             all             ::1\/128                 ident<\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p class=\"theCode\" style=\"display: none;\"># IPv4 local connections:<br \/>\nhost all all 127.0.0.1\/32 ident<br \/>\n# IPv6 local connections:<br \/>\nhost all all ::1\/128 ident<\/p>\n<\/div>\n<p>Replace <kbd>ident<\/kbd> with <kbd>scram-sha-256<\/kbd>:<\/p>\n<div class=\"wp_syntax\" style=\"position: relative; width: auto;\">\n<table>\n<tbody>\n<tr>\n<td class=\"code\">\n<pre class=\"lang:default decode:true\"># IPv4 local connections:\r\nhost    all             all             127.0.0.1\/32            scram-sha-256\r\n# IPv6 local connections:\r\nhost    all             all             ::1\/128                 scram-sha-256<\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p class=\"theCode\" style=\"display: none;\"># IPv4 local connections:<br \/>\nhost all all 127.0.0.1\/32 scram-sha-256<br \/>\n# IPv6 local connections:<br \/>\nhost all all ::1\/128 scram-sha-256<\/p>\n<\/div>\n<p>Restart the postgresql server:<br \/>\n<code>$ sudo systemctl restart postgresql<\/code><\/p>\n<h2><span class=\"ez-toc-section\" id=\"How_to_create_a_new_PostgreSQL_user_account\"><\/span>How to create a new PostgreSQL user account<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>First create a Linux user account named tom:<br \/>\n<code>$ sudo useradd tom<br \/>\n$ sudo passwd tom<\/code><br \/>\nSample outputs:<\/p>\n<pre class=\"lang:default decode:true\">Changing password for user tom.\r\nNew password: \r\nRetype new password: \r\npasswd: all authentication tokens updated successfully.<\/pre>\n<p>The postgres account is nothing but an administrative user for PostgreSQL server. So log in as postgres:<br \/>\n<code>$ sudo -i -u postgres<\/code><br \/>\nRun the following createuser command to creates a new PostgreSQL role for tom Linux user:<br \/>\n<code>$ createuser --interactive <\/code><\/p>\n<figure id=\"attachment_147480\" class=\"wp-caption aligncenter\" style=\"width: 599px;\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-147480\" src=\"https:\/\/i0.wp.com\/www.cyberciti.biz\/media\/new\/faq\/2018\/12\/How-to-create-a-new-PostgreSQL-user-or-role-on-RHEL-8.png?resize=599%2C186&#038;ssl=1\" sizes=\"auto, (max-width: 599px) 85vw, 599px\" srcset=\"https:\/\/www.cyberciti.biz\/media\/new\/faq\/2018\/12\/How-to-create-a-new-PostgreSQL-user-or-role-on-RHEL-8.png 599w, https:\/\/www.cyberciti.biz\/media\/new\/faq\/2018\/12\/How-to-create-a-new-PostgreSQL-user-or-role-on-RHEL-8-300x93.png 300w\" alt=\"How to create a new PostgreSQL user or role on RHEL 8\" width=\"599\" height=\"186\" \/><figcaption class=\"wp-caption-text\">Define a new PostgreSQL user account named tom<\/figcaption><\/figure>\n<p>Create a new user account with password for new role:<br \/>\n<code>$ createuser --interactive --pwprompt<\/code><\/p>\n<figure id=\"attachment_147481\" class=\"wp-caption aligncenter\" style=\"width: 599px;\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-147481\" src=\"https:\/\/i0.wp.com\/www.cyberciti.biz\/media\/new\/faq\/2018\/12\/Creating-user-with-password-on-PostgreSQL.png?resize=599%2C197&#038;ssl=1\" sizes=\"auto, (max-width: 599px) 85vw, 599px\" srcset=\"https:\/\/www.cyberciti.biz\/media\/new\/faq\/2018\/12\/Creating-user-with-password-on-PostgreSQL.png 599w, https:\/\/www.cyberciti.biz\/media\/new\/faq\/2018\/12\/Creating-user-with-password-on-PostgreSQL-300x99.png 300w\" alt=\"Creating user with password on PostgreSQL\" width=\"599\" height=\"197\" \/><figcaption class=\"wp-caption-text\">Creating user with password on PostgreSQL<\/figcaption><\/figure>\n<p>Finally create a new database named jerry for tom user by log in as postgres admin user:<br \/>\n<code>$ sudo -i -u postgres<br \/>\n$ createdb -O tom jerry<\/code><\/p>\n<h3><span class=\"ez-toc-section\" id=\"How_do_I_connect_to_jerry_database_with_tom_user\"><\/span>How do I connect to jerry database with tom user?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Simply run the following commands:<br \/>\n<code>$ sudo -i -u tom<br \/>\n$ psql -d jerry -U tom<\/code><\/p>\n<figure id=\"attachment_147482\" class=\"wp-caption aligncenter\" style=\"width: 599px;\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-147482\" src=\"https:\/\/i0.wp.com\/www.cyberciti.biz\/media\/new\/faq\/2018\/12\/How-to-connect-to-postgresql-with-the-new-user.png?resize=599%2C231&#038;ssl=1\" sizes=\"auto, (max-width: 599px) 85vw, 599px\" srcset=\"https:\/\/www.cyberciti.biz\/media\/new\/faq\/2018\/12\/How-to-connect-to-postgresql-with-the-new-user.png 599w, https:\/\/www.cyberciti.biz\/media\/new\/faq\/2018\/12\/How-to-connect-to-postgresql-with-the-new-user-300x116.png 300w\" alt=\"How to connect to postgresql with the new user\" width=\"599\" height=\"231\" \/><figcaption class=\"wp-caption-text\">Connecting to PostgreSQL server with the new user named tom for jerry database<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"How_to_create_a_new_table\"><\/span>How to create a new table<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Log in:<br \/>\n<code>$ psql -d jerry -U tom<\/code><br \/>\nType the following SQL to create demo table:<\/p>\n<pre class=\"lang:default decode:true\">CREATE TABLE demo(\r\n id serial PRIMARY KEY,\r\n email VARCHAR (100) UNIQUE NOT NULL,\r\n name  VARCHAR (50) UNIQUE NOT NULL\r\n);<\/pre>\n<p class=\"theCode\" style=\"display: none;\">CREATE TABLE demo(<br \/>\nid serial PRIMARY KEY,<br \/>\nemail VARCHAR (100) UNIQUE NOT NULL,<br \/>\nname VARCHAR (50) UNIQUE NOT NULL<br \/>\n);<\/p>\n<p>See info about the demo table:<br \/>\n<code>\\d<\/code><br \/>\nOR<br \/>\n<code>\\dt<\/code><br \/>\n<img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-147484\" src=\"https:\/\/i0.wp.com\/www.cyberciti.biz\/media\/new\/faq\/2018\/12\/How-to-create-a-new-PostgreSQL-table-on-RHEL-8.png?resize=599%2C688&#038;ssl=1\" sizes=\"auto, (max-width: 599px) 85vw, 599px\" srcset=\"https:\/\/www.cyberciti.biz\/media\/new\/faq\/2018\/12\/How-to-create-a-new-PostgreSQL-table-on-RHEL-8.png 599w, https:\/\/www.cyberciti.biz\/media\/new\/faq\/2018\/12\/How-to-create-a-new-PostgreSQL-table-on-RHEL-8-261x300.png 261w\" alt=\"How to create a new PostgreSQL table on RHEL 8\" width=\"599\" height=\"688\" \/><br \/>\nLet us add some data to our table, run the following SQL:<\/p>\n<div class=\"wp_syntax\" style=\"position: relative;\">\n<pre class=\"lang:default decode:true \">INSERT INTO demo (id, email, name) VALUES (1, 'webmaster@cyberciti.biz', 'Vivek Gite');\r\nINSERT INTO demo (id, email, name) VALUES (2, 'foo@bar.com', 'Foo Bar');\r\nINSERT INTO demo (id, email, name) VALUES (3, 'roja@nixcraft.com', 'Roja T');\r\nINSERT INTO demo (id, email, name) VALUES (4, 'marlena@gmail.net.in', 'Marlena John');<\/pre>\n<p class=\"theCode\" style=\"display: none;\">INSERT INTO demo (id, email, name) VALUES (1, &#8216;webmaster@cyberciti.biz&#8217;, &#8216;Vivek Gite&#8217;);<br \/>\nINSERT INTO demo (id, email, name) VALUES (2, &#8216;foo@bar.com&#8217;, &#8216;Foo Bar&#8217;);<br \/>\nINSERT INTO demo (id, email, name) VALUES (3, &#8216;roja@nixcraft.com&#8217;, &#8216;Roja T&#8217;);<br \/>\nINSERT INTO demo (id, email, name) VALUES (4, &#8216;marlena@gmail.net.in&#8217;, &#8216;Marlena John&#8217;);<\/p>\n<\/div>\n<p>View data:<\/p>\n<div class=\"wp_syntax\" style=\"position: relative;\">\n<pre class=\"lang:default decode:true \">SELECT * FROM demo;<\/pre>\n<p>Delete some data:<\/p>\n<\/div>\n<div class=\"wp_syntax\" style=\"position: relative;\">\n<pre class=\"lang:default decode:true \">DELETE FROM demo WHERE id = 4;<\/pre>\n<p>Update data:<\/p>\n<\/div>\n<div class=\"wp_syntax\" style=\"position: relative;\">\n<pre class=\"lang:default decode:true \">UPDATE demo SET email = 'foo@gmail.com' WHERE id = 2;<\/pre>\n<p>&nbsp;<\/p>\n<p class=\"theCode\" style=\"display: none;\">UPDATE demo SET email = &#8216;foo@gmail.com&#8217; WHERE id = 2;<\/p>\n<\/div>\n<figure id=\"attachment_147485\" class=\"wp-caption aligncenter\" style=\"width: 300px;\"><a href=\"https:\/\/i0.wp.com\/www.cyberciti.biz\/media\/new\/faq\/2018\/12\/How-to-add-query-delete-and-Update-data-in-a-table.png?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-147485\" src=\"https:\/\/i0.wp.com\/www.cyberciti.biz\/media\/new\/faq\/2018\/12\/How-to-add-query-delete-and-Update-data-in-a-table-300x281.png?resize=300%2C281&#038;ssl=1\" sizes=\"auto, (max-width: 300px) 85vw, 300px\" srcset=\"https:\/\/www.cyberciti.biz\/media\/new\/faq\/2018\/12\/How-to-add-query-delete-and-Update-data-in-a-table-300x281.png 300w, https:\/\/www.cyberciti.biz\/media\/new\/faq\/2018\/12\/How-to-add-query-delete-and-Update-data-in-a-table.png 862w\" alt=\"How to add, query, delete and Update data in a table\" width=\"300\" height=\"281\" \/><\/a><figcaption class=\"wp-caption-text\">How to add, query, delete and Update data in a table (click to enlarge)<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Kesmipulan\"><\/span>Kesmipulan<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Selamat. Anda berhasil mengatur server PostgreSQL di server RHEL 8. Anda juga belajar cara membuat pengguna, database, dan tabel. Untuk info lebih lanjut, lihat dokumentasi PostgreSQL resmi <a href=\"https:\/\/www.postgresql.org\/docs\/\" target=\"_blank\" rel=\"noopener\">here<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Bagaimana cara menginstal manajemen basis data PostgreSQL di RHEL 8 atau Centos 7 menggunakan perintah? Bagaimana cara menginstal dan mengatur PostgreSQL di RHEL 8 server? Pendahuluan: PostgreSQL adalah gratis dan open dari ORDBMS (sistem manajemen database objek-relasional). Ini adalah basis data sumber terbuka paling canggih di dunia. Halaman ini menunjukkan cara menginstal PostgreSQL di RHEL [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1811,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[91],"tags":[],"class_list":["post-1807","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-linux"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Cara install dan setup PostgreSQL di RHEL 8 \/ Centos 7 - Hostnic.id<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.hostnic.id\/blog\/tutorial\/linux\/cara-install-dan-setup-postgresql-di-rhel-8-centos-7\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara install dan setup PostgreSQL di RHEL 8 \/ Centos 7 - Hostnic.id\" \/>\n<meta property=\"og:description\" content=\"Bagaimana cara menginstal manajemen basis data PostgreSQL di RHEL 8 atau Centos 7 menggunakan perintah? Bagaimana cara menginstal dan mengatur PostgreSQL di RHEL 8 server? Pendahuluan: PostgreSQL adalah gratis dan open dari ORDBMS (sistem manajemen database objek-relasional). Ini adalah basis data sumber terbuka paling canggih di dunia. Halaman ini menunjukkan cara menginstal PostgreSQL di RHEL [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.hostnic.id\/blog\/tutorial\/linux\/cara-install-dan-setup-postgresql-di-rhel-8-centos-7\/\" \/>\n<meta property=\"og:site_name\" content=\"Hostnic.id\" \/>\n<meta property=\"article:published_time\" content=\"2018-12-03T04:15:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.hostnic.id\/blog\/wp-content\/uploads\/2018\/12\/How-to-see-a-list-of-all-available-PostgreSQL-versions-or-application-streams.png\" \/>\n\t<meta property=\"og:image:width\" content=\"599\" \/>\n\t<meta property=\"og:image:height\" content=\"112\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Ari Sigit\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ari Sigit\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.hostnic.id\\\/blog\\\/tutorial\\\/linux\\\/cara-install-dan-setup-postgresql-di-rhel-8-centos-7\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.hostnic.id\\\/blog\\\/tutorial\\\/linux\\\/cara-install-dan-setup-postgresql-di-rhel-8-centos-7\\\/\"},\"author\":{\"name\":\"Ari Sigit\",\"@id\":\"https:\\\/\\\/www.hostnic.id\\\/blog\\\/#\\\/schema\\\/person\\\/a782d1235d484e7630007157996e5a49\"},\"headline\":\"Cara install dan setup PostgreSQL di RHEL 8 \\\/ Centos 7\",\"datePublished\":\"2018-12-03T04:15:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.hostnic.id\\\/blog\\\/tutorial\\\/linux\\\/cara-install-dan-setup-postgresql-di-rhel-8-centos-7\\\/\"},\"wordCount\":682,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.hostnic.id\\\/blog\\\/tutorial\\\/linux\\\/cara-install-dan-setup-postgresql-di-rhel-8-centos-7\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i0.wp.com\\\/www.hostnic.id\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/12\\\/How-to-see-a-list-of-all-available-PostgreSQL-versions-or-application-streams.png?fit=599%2C112&ssl=1\",\"articleSection\":[\"Linux\"],\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.hostnic.id\\\/blog\\\/tutorial\\\/linux\\\/cara-install-dan-setup-postgresql-di-rhel-8-centos-7\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.hostnic.id\\\/blog\\\/tutorial\\\/linux\\\/cara-install-dan-setup-postgresql-di-rhel-8-centos-7\\\/\",\"url\":\"https:\\\/\\\/www.hostnic.id\\\/blog\\\/tutorial\\\/linux\\\/cara-install-dan-setup-postgresql-di-rhel-8-centos-7\\\/\",\"name\":\"Cara install dan setup PostgreSQL di RHEL 8 \\\/ Centos 7 - Hostnic.id\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.hostnic.id\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.hostnic.id\\\/blog\\\/tutorial\\\/linux\\\/cara-install-dan-setup-postgresql-di-rhel-8-centos-7\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.hostnic.id\\\/blog\\\/tutorial\\\/linux\\\/cara-install-dan-setup-postgresql-di-rhel-8-centos-7\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i0.wp.com\\\/www.hostnic.id\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/12\\\/How-to-see-a-list-of-all-available-PostgreSQL-versions-or-application-streams.png?fit=599%2C112&ssl=1\",\"datePublished\":\"2018-12-03T04:15:38+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.hostnic.id\\\/blog\\\/#\\\/schema\\\/person\\\/a782d1235d484e7630007157996e5a49\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.hostnic.id\\\/blog\\\/tutorial\\\/linux\\\/cara-install-dan-setup-postgresql-di-rhel-8-centos-7\\\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.hostnic.id\\\/blog\\\/tutorial\\\/linux\\\/cara-install-dan-setup-postgresql-di-rhel-8-centos-7\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\\\/\\\/www.hostnic.id\\\/blog\\\/tutorial\\\/linux\\\/cara-install-dan-setup-postgresql-di-rhel-8-centos-7\\\/#primaryimage\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/www.hostnic.id\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/12\\\/How-to-see-a-list-of-all-available-PostgreSQL-versions-or-application-streams.png?fit=599%2C112&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/www.hostnic.id\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/12\\\/How-to-see-a-list-of-all-available-PostgreSQL-versions-or-application-streams.png?fit=599%2C112&ssl=1\",\"width\":599,\"height\":112},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.hostnic.id\\\/blog\\\/tutorial\\\/linux\\\/cara-install-dan-setup-postgresql-di-rhel-8-centos-7\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.hostnic.id\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara install dan setup PostgreSQL di RHEL 8 \\\/ Centos 7\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.hostnic.id\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.hostnic.id\\\/blog\\\/\",\"name\":\"hostnic.id\",\"description\":\"Info, Tips dan Tutorial Seputar Layanan Hostnic\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.hostnic.id\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.hostnic.id\\\/blog\\\/#\\\/schema\\\/person\\\/a782d1235d484e7630007157996e5a49\",\"name\":\"Ari Sigit\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/140001cab6874fc4d4cecb4b3519ceca05b4fa2543ed46c5dae3704831ed3a2d?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/140001cab6874fc4d4cecb4b3519ceca05b4fa2543ed46c5dae3704831ed3a2d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/140001cab6874fc4d4cecb4b3519ceca05b4fa2543ed46c5dae3704831ed3a2d?s=96&d=mm&r=g\",\"caption\":\"Ari Sigit\"},\"description\":\"Application Developer &amp; Support Specialist\",\"url\":\"https:\\\/\\\/www.hostnic.id\\\/blog\\\/author\\\/admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cara install dan setup PostgreSQL di RHEL 8 \/ Centos 7 - Hostnic.id","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:\/\/www.hostnic.id\/blog\/tutorial\/linux\/cara-install-dan-setup-postgresql-di-rhel-8-centos-7\/","og_locale":"id_ID","og_type":"article","og_title":"Cara install dan setup PostgreSQL di RHEL 8 \/ Centos 7 - Hostnic.id","og_description":"Bagaimana cara menginstal manajemen basis data PostgreSQL di RHEL 8 atau Centos 7 menggunakan perintah? Bagaimana cara menginstal dan mengatur PostgreSQL di RHEL 8 server? Pendahuluan: PostgreSQL adalah gratis dan open dari ORDBMS (sistem manajemen database objek-relasional). Ini adalah basis data sumber terbuka paling canggih di dunia. Halaman ini menunjukkan cara menginstal PostgreSQL di RHEL [&hellip;]","og_url":"https:\/\/www.hostnic.id\/blog\/tutorial\/linux\/cara-install-dan-setup-postgresql-di-rhel-8-centos-7\/","og_site_name":"Hostnic.id","article_published_time":"2018-12-03T04:15:38+00:00","og_image":[{"width":599,"height":112,"url":"https:\/\/www.hostnic.id\/blog\/wp-content\/uploads\/2018\/12\/How-to-see-a-list-of-all-available-PostgreSQL-versions-or-application-streams.png","type":"image\/png"}],"author":"Ari Sigit","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Ari Sigit","Estimasi waktu membaca":"5 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.hostnic.id\/blog\/tutorial\/linux\/cara-install-dan-setup-postgresql-di-rhel-8-centos-7\/#article","isPartOf":{"@id":"https:\/\/www.hostnic.id\/blog\/tutorial\/linux\/cara-install-dan-setup-postgresql-di-rhel-8-centos-7\/"},"author":{"name":"Ari Sigit","@id":"https:\/\/www.hostnic.id\/blog\/#\/schema\/person\/a782d1235d484e7630007157996e5a49"},"headline":"Cara install dan setup PostgreSQL di RHEL 8 \/ Centos 7","datePublished":"2018-12-03T04:15:38+00:00","mainEntityOfPage":{"@id":"https:\/\/www.hostnic.id\/blog\/tutorial\/linux\/cara-install-dan-setup-postgresql-di-rhel-8-centos-7\/"},"wordCount":682,"commentCount":0,"image":{"@id":"https:\/\/www.hostnic.id\/blog\/tutorial\/linux\/cara-install-dan-setup-postgresql-di-rhel-8-centos-7\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/www.hostnic.id\/blog\/wp-content\/uploads\/2018\/12\/How-to-see-a-list-of-all-available-PostgreSQL-versions-or-application-streams.png?fit=599%2C112&ssl=1","articleSection":["Linux"],"inLanguage":"id","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.hostnic.id\/blog\/tutorial\/linux\/cara-install-dan-setup-postgresql-di-rhel-8-centos-7\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.hostnic.id\/blog\/tutorial\/linux\/cara-install-dan-setup-postgresql-di-rhel-8-centos-7\/","url":"https:\/\/www.hostnic.id\/blog\/tutorial\/linux\/cara-install-dan-setup-postgresql-di-rhel-8-centos-7\/","name":"Cara install dan setup PostgreSQL di RHEL 8 \/ Centos 7 - Hostnic.id","isPartOf":{"@id":"https:\/\/www.hostnic.id\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.hostnic.id\/blog\/tutorial\/linux\/cara-install-dan-setup-postgresql-di-rhel-8-centos-7\/#primaryimage"},"image":{"@id":"https:\/\/www.hostnic.id\/blog\/tutorial\/linux\/cara-install-dan-setup-postgresql-di-rhel-8-centos-7\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/www.hostnic.id\/blog\/wp-content\/uploads\/2018\/12\/How-to-see-a-list-of-all-available-PostgreSQL-versions-or-application-streams.png?fit=599%2C112&ssl=1","datePublished":"2018-12-03T04:15:38+00:00","author":{"@id":"https:\/\/www.hostnic.id\/blog\/#\/schema\/person\/a782d1235d484e7630007157996e5a49"},"breadcrumb":{"@id":"https:\/\/www.hostnic.id\/blog\/tutorial\/linux\/cara-install-dan-setup-postgresql-di-rhel-8-centos-7\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.hostnic.id\/blog\/tutorial\/linux\/cara-install-dan-setup-postgresql-di-rhel-8-centos-7\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/www.hostnic.id\/blog\/tutorial\/linux\/cara-install-dan-setup-postgresql-di-rhel-8-centos-7\/#primaryimage","url":"https:\/\/i0.wp.com\/www.hostnic.id\/blog\/wp-content\/uploads\/2018\/12\/How-to-see-a-list-of-all-available-PostgreSQL-versions-or-application-streams.png?fit=599%2C112&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.hostnic.id\/blog\/wp-content\/uploads\/2018\/12\/How-to-see-a-list-of-all-available-PostgreSQL-versions-or-application-streams.png?fit=599%2C112&ssl=1","width":599,"height":112},{"@type":"BreadcrumbList","@id":"https:\/\/www.hostnic.id\/blog\/tutorial\/linux\/cara-install-dan-setup-postgresql-di-rhel-8-centos-7\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.hostnic.id\/blog\/"},{"@type":"ListItem","position":2,"name":"Cara install dan setup PostgreSQL di RHEL 8 \/ Centos 7"}]},{"@type":"WebSite","@id":"https:\/\/www.hostnic.id\/blog\/#website","url":"https:\/\/www.hostnic.id\/blog\/","name":"hostnic.id","description":"Info, Tips dan Tutorial Seputar Layanan Hostnic","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.hostnic.id\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/www.hostnic.id\/blog\/#\/schema\/person\/a782d1235d484e7630007157996e5a49","name":"Ari Sigit","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/secure.gravatar.com\/avatar\/140001cab6874fc4d4cecb4b3519ceca05b4fa2543ed46c5dae3704831ed3a2d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/140001cab6874fc4d4cecb4b3519ceca05b4fa2543ed46c5dae3704831ed3a2d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/140001cab6874fc4d4cecb4b3519ceca05b4fa2543ed46c5dae3704831ed3a2d?s=96&d=mm&r=g","caption":"Ari Sigit"},"description":"Application Developer &amp; Support Specialist","url":"https:\/\/www.hostnic.id\/blog\/author\/admin\/"}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.hostnic.id\/blog\/wp-content\/uploads\/2018\/12\/How-to-see-a-list-of-all-available-PostgreSQL-versions-or-application-streams.png?fit=599%2C112&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p8D2mv-t9","jetpack-related-posts":[{"id":1746,"url":"https:\/\/www.hostnic.id\/blog\/tutorial\/linux\/cara-install-dan-konfigurasi-askbot-dengan-nginx-di-centos-7\/","url_meta":{"origin":1807,"position":0},"title":"Cara Install dan Konfigurasi Askbot dengan Nginx di CentOS 7","author":"Ari Sigit","date":"2018-11-25","format":false,"excerpt":"Askbot adalah perangkat lunak open source untuk membuat forum Q&A yangg mengggunakan Python Django Framework. Pada dasarnya sistem Q&A seperti StackOverflow, Yahoo Answers, dan lainnya. Dibuat oleh Mike Chan dan Sailing Cai pada tahun 2009, dan mudah untuk menginstal dan mengkonfigurasi pada sistem Linux seperti Ubuntu dan CentOS. Banyak proyek\u2026","rel":"","context":"dalam &quot;Linux&quot;","block_context":{"text":"Linux","link":"https:\/\/www.hostnic.id\/blog\/.\/tutorial\/linux\/"},"img":{"alt_text":"Cara Install dan Konfigurasi Askbot dengan Nginx di CentOS 7","src":"https:\/\/i0.wp.com\/www.hostnic.id\/blog\/wp-content\/uploads\/2018\/11\/askbot.png?fit=1200%2C764&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.hostnic.id\/blog\/wp-content\/uploads\/2018\/11\/askbot.png?fit=1200%2C764&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.hostnic.id\/blog\/wp-content\/uploads\/2018\/11\/askbot.png?fit=1200%2C764&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.hostnic.id\/blog\/wp-content\/uploads\/2018\/11\/askbot.png?fit=1200%2C764&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.hostnic.id\/blog\/wp-content\/uploads\/2018\/11\/askbot.png?fit=1200%2C764&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":1735,"url":"https:\/\/www.hostnic.id\/blog\/tutorial\/linux\/cara-install-dan-mengaktifkan-cockpit-web-console-di-rhel-8\/","url_meta":{"origin":1807,"position":1},"title":"Cara install dan mengaktifkan Cockpit web console di RHEL 8","author":"Ari Sigit","date":"2018-11-25","format":false,"excerpt":"Bagaimana cara install dan mengaktifkan Cockpit untuk mengelola GNU\/Linux dan RHEL 8 dalam bentuk web? Bagaimana melihat dan memanage RHEL 8 server dalam web browser dan melakukan pekerjaan dengan sebuah mouse? Pendahuluan: Cockpit adalah alat manajemen server berbasis web gratis dan terbuka. Secara default, Cockpit sudah terpasang di server RHEL\u2026","rel":"","context":"dalam &quot;Linux&quot;","block_context":{"text":"Linux","link":"https:\/\/www.hostnic.id\/blog\/.\/tutorial\/linux\/"},"img":{"alt_text":"Cara Install Web Console Cockpit pada RHEL 8","src":"https:\/\/i0.wp.com\/www.hostnic.id\/blog\/wp-content\/uploads\/2018\/11\/Embedded-terminal-shell-session-in-Cockpit-web-interface-on-RHEL-8.png?fit=599%2C460&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.hostnic.id\/blog\/wp-content\/uploads\/2018\/11\/Embedded-terminal-shell-session-in-Cockpit-web-interface-on-RHEL-8.png?fit=599%2C460&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.hostnic.id\/blog\/wp-content\/uploads\/2018\/11\/Embedded-terminal-shell-session-in-Cockpit-web-interface-on-RHEL-8.png?fit=599%2C460&ssl=1&resize=525%2C300 1.5x"},"classes":[]},{"id":1989,"url":"https:\/\/www.hostnic.id\/blog\/tutorial\/linux\/cara-install-apache-mysql-mariadb-dan-php-pada-rhel-8\/","url_meta":{"origin":1807,"position":2},"title":"Cara Install Apache, MySQL\/MariaDB dan PHP pada RHEL 8","author":"Ari Sigit","date":"2018-12-31","format":false,"excerpt":"Dalam tutorial ini, Anda akan belajar cara menginstal LAMP stack - Linux, Apache, MySQL \/ MariaDB, PHP pada sistem RHEL 8. Tutorial ini menganggap bahwa Anda telah mengaktifkan langganan RHEL 8 dan bahwa Anda memiliki akses root ke sistem Anda. Step 1: Install Apache Web Server 1. Pertama, kita akan\u2026","rel":"","context":"dalam &quot;Linux&quot;","block_context":{"text":"Linux","link":"https:\/\/www.hostnic.id\/blog\/.\/tutorial\/linux\/"},"img":{"alt_text":"Cara Install Apache, MySQL\/MariaDB dan PHP pada RHEL 8","src":"https:\/\/i0.wp.com\/www.hostnic.id\/blog\/wp-content\/uploads\/2018\/12\/lamp.png?fit=940%2C529&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.hostnic.id\/blog\/wp-content\/uploads\/2018\/12\/lamp.png?fit=940%2C529&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.hostnic.id\/blog\/wp-content\/uploads\/2018\/12\/lamp.png?fit=940%2C529&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.hostnic.id\/blog\/wp-content\/uploads\/2018\/12\/lamp.png?fit=940%2C529&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":1968,"url":"https:\/\/www.hostnic.id\/blog\/tutorial\/linux\/cara-install-virtualbox-6-0-pada-os-linux\/","url_meta":{"origin":1807,"position":3},"title":"Cara Install VirtualBox 6.0 Pada OS Linux","author":"Ari Sigit","date":"2018-12-25","format":false,"excerpt":"VirtualBox adalah perangkat lunak virtualisasi lintas-platform open source, dapat diinstal pada sistem operasi apa pun dan memungkinkan Anda untuk menginstal dan menjalankan beberapa sistem operasi di komputer yang sama. Misalnya, jika Anda menginstalnya di sistem Linux, Anda dapat menjalankan sistem operasi Windows XP di bawahnya sebagai OS Tamu atau menjalankan\u2026","rel":"","context":"dalam &quot;Linux&quot;","block_context":{"text":"Linux","link":"https:\/\/www.hostnic.id\/blog\/.\/tutorial\/linux\/"},"img":{"alt_text":"Cara Install VirtualBox 6.0 Pada OS Linux","src":"https:\/\/i0.wp.com\/www.hostnic.id\/blog\/wp-content\/uploads\/2018\/12\/virtualbox-6-0-officially-released-with-major-new-features-here-s-what-s-new-524331-2.jpg?fit=625%2C361&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.hostnic.id\/blog\/wp-content\/uploads\/2018\/12\/virtualbox-6-0-officially-released-with-major-new-features-here-s-what-s-new-524331-2.jpg?fit=625%2C361&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.hostnic.id\/blog\/wp-content\/uploads\/2018\/12\/virtualbox-6-0-officially-released-with-major-new-features-here-s-what-s-new-524331-2.jpg?fit=625%2C361&ssl=1&resize=525%2C300 1.5x"},"classes":[]},{"id":1992,"url":"https:\/\/www.hostnic.id\/blog\/tutorial\/linux\/cara-install-nginx-mysql-mariadb-dan-php-pada-rhel-8\/","url_meta":{"origin":1807,"position":4},"title":"Cara Install Nginx, MySQL\/MariaDB dan PHP pada RHEL 8","author":"Ari Sigit","date":"2018-12-31","format":false,"excerpt":"Banyak pembaca tahu tentang LAMP, tetapi sedikit orang yang menyadari LEMP, yang menggantikan server web Apache dengan Nginx. Setiap server web memiliki pro dan kontra dan itu tergantung pada situasi spesifik Anda yang mana yang akan Anda pilih untuk digunakan. Dalam tutorial ini, kami akan menunjukkan kepada Anda bagaimana menginstal\u2026","rel":"","context":"dalam &quot;Linux&quot;","block_context":{"text":"Linux","link":"https:\/\/www.hostnic.id\/blog\/.\/tutorial\/linux\/"},"img":{"alt_text":"Cara Install Apache, MySQL\/MariaDB dan PHP pada RHEL 8","src":"https:\/\/i0.wp.com\/www.hostnic.id\/blog\/wp-content\/uploads\/2018\/12\/lamp.png?fit=940%2C529&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.hostnic.id\/blog\/wp-content\/uploads\/2018\/12\/lamp.png?fit=940%2C529&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.hostnic.id\/blog\/wp-content\/uploads\/2018\/12\/lamp.png?fit=940%2C529&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.hostnic.id\/blog\/wp-content\/uploads\/2018\/12\/lamp.png?fit=940%2C529&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":4842,"url":"https:\/\/www.hostnic.id\/blog\/tutorial\/website\/berkenalan-dengan-database-postgresql-pengertian-serta-fiturnya\/","url_meta":{"origin":1807,"position":5},"title":"Berkenalan Dengan Database Postgresql : Pengertian serta fiturnya\u00a0","author":"Monic","date":"2021-04-26","format":false,"excerpt":"Pada artikel sebelumnya, kita sudah berkenalan dengan database MySQL melalui artikel berikut Mengenal MySQL Serta Fungsinya Untuk Website. Database MySQL merupakan jenis database yang sangat populer dan digunakan oleh banyak orang. Nah, kali ini kita akan berkenalan dengan jenis database lain yaitu Postgresql Database. Apa Itu Database Postgresql? PostgreSQL Database\u2026","rel":"","context":"dalam &quot;MySQL&quot;","block_context":{"text":"MySQL","link":"https:\/\/www.hostnic.id\/blog\/.\/tutorial\/mysql\/"},"img":{"alt_text":"database postgresql","src":"https:\/\/i0.wp.com\/www.hostnic.id\/blog\/wp-content\/uploads\/2021\/04\/1269454-1.jpg?fit=1200%2C1200&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.hostnic.id\/blog\/wp-content\/uploads\/2021\/04\/1269454-1.jpg?fit=1200%2C1200&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.hostnic.id\/blog\/wp-content\/uploads\/2021\/04\/1269454-1.jpg?fit=1200%2C1200&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.hostnic.id\/blog\/wp-content\/uploads\/2021\/04\/1269454-1.jpg?fit=1200%2C1200&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.hostnic.id\/blog\/wp-content\/uploads\/2021\/04\/1269454-1.jpg?fit=1200%2C1200&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.hostnic.id\/blog\/wp-json\/wp\/v2\/posts\/1807","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hostnic.id\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hostnic.id\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hostnic.id\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostnic.id\/blog\/wp-json\/wp\/v2\/comments?post=1807"}],"version-history":[{"count":4,"href":"https:\/\/www.hostnic.id\/blog\/wp-json\/wp\/v2\/posts\/1807\/revisions"}],"predecessor-version":[{"id":1812,"href":"https:\/\/www.hostnic.id\/blog\/wp-json\/wp\/v2\/posts\/1807\/revisions\/1812"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.hostnic.id\/blog\/wp-json\/wp\/v2\/media\/1811"}],"wp:attachment":[{"href":"https:\/\/www.hostnic.id\/blog\/wp-json\/wp\/v2\/media?parent=1807"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostnic.id\/blog\/wp-json\/wp\/v2\/categories?post=1807"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostnic.id\/blog\/wp-json\/wp\/v2\/tags?post=1807"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}