{"id":1180,"date":"2019-11-18T01:06:21","date_gmt":"2019-11-17T18:06:21","guid":{"rendered":"https:\/\/www.linuxid.net\/post\/?p=1180"},"modified":"2025-04-18T15:21:24","modified_gmt":"2025-04-18T08:21:24","slug":"cara-install-dan-konfigurasi-postgresql-di-centos-8","status":"publish","type":"post","link":"https:\/\/www.linuxid.net\/post\/cara-install-dan-konfigurasi-postgresql-di-centos-8\/","title":{"rendered":"Cara Install dan Konfigurasi PostgreSQL di CentOS 8"},"content":{"rendered":"<h2>PostgreSQL Role dan Metode Otentikasi<\/h2>\n<p>Izin akses basis data dalam PostgreSQL ditangani dengan konsep peran. Peran dapat mewakili pengguna basis data atau sekelompok pengguna database.<\/p>\n<p>PostgreSQL mendukung banyak\u00a0<a href=\"https:\/\/www.postgresql.org\/docs\/10\/static\/auth-methods.html\" target=\"_blank\" rel=\"noopener\">metode otentikasi<\/a>. Yang paling umum digunakan adalah:<\/p>\n<ul>\n<li><strong>Trust<\/strong>\u00a0\u2013 Dengan metode ini, peran dapat terhubung tanpa kata sandi, selama kriteria yang ditentukan dalam\u00a0<code>pg_hba.conf<\/code>\u00a0terpenuhi.<\/li>\n<li><strong>Password<\/strong>\u00a0\u2013 Peran dapat terhubung dengan memberikan kata sandi. Kata sandi dapat disimpan sebagai\u00a0<code>scram-sha-256md5<\/code>\u00a0dan\u00a0<code>password<\/code>\u00a0(clear-text)<\/li>\n<li><strong>Ident<\/strong>\u00a0\u2013 Metode ini hanya didukung pada koneksi TCP \/ IP. Bekerja dengan mendapatkan nama pengguna sistem operasi klien, dengan pemetaan nama pengguna opsional.<\/li>\n<li><strong>Peer<\/strong>\u00a0\u2013 Sama seperti Ident tetapi hanya didukung pada koneksi lokal.<\/li>\n<\/ul>\n<p>Otentikasi klien PostgreSQL didefinisikan dalam file konfigurasi bernama\u00a0<code>pg_hba.conf<\/code>. Secara default untuk koneksi lokal, PostgreSQL diatur untuk menggunakan metode otentikasi peer.<\/p>\n<p>Pengguna\u00a0<code>postgres<\/code>\u00a0dibuat secara otomatis ketika menginstal PostgreSQL. Pengguna ini adalah\u00a0<code>superuser<\/code>\u00a0untuk instance PostgreSQL dan itu setara dengan root di MySQL.<\/p>\n<p>Untuk masuk ke server PostgreSQL sebagai\u00a0<code>postgres<\/code>, terlebih dahulu Anda harus beralih ke user\u00a0<code>postgres<\/code>\u00a0dan kemudian Anda dapat mengakses prompt PostgreSQL menggunakan utilitas\u00a0<code>psql<\/code>:<\/p>\n<pre>sudo su - postgres&#13;\npsql<\/pre>\n<p>Dari sini Anda dapat berinteraksi dengan instance PostgreSQL Anda. Untuk keluar dari shell PostgreSQL ketik perintah berikut:<\/p>\n<pre>\\q<\/pre>\n<p>Anda juga dapat mengakses prompt PostgreSQL tanpa mengalihkan pengguna menggunakan perintah\u00a0<code>sudo<\/code>:<\/p>\n<pre>sudo -u postgres psql<\/pre>\n<p>Pengguna\u00a0<code>postgres<\/code>\u00a0biasanya hanya digunakan dari host lokal dan disarankan untuk tidak mengatur password untuk pengguna\u00a0<code>postgres<\/code>ini.<\/p>\n<h2>Membuat Role dan Database PostgreSQL<\/h2>\n<p>Anda dapat membuat peran baru dari baris perintah menggunakan perintah\u00a0<code>createuser<\/code>. Hanya superusers dan user dengan hak istimewa\u00a0<code>CREATEROLE<\/code>\u00a0yang dapat membuat peran baru.<\/p>\n<p>Dalam contoh berikut, kita akan membuat peran baru bernama\u00a0<code>dona<\/code>\u00a0sebuah database bernama\u00a0<code>donadb<\/code>\u00a0dan memberikan hak istimewa pada database.<\/p>\n<ol>\n<li>Perintah berikut akan membuat role baru bernama dona:\n<pre>sudo su - postgres -c \"createuser dona\"<\/pre>\n<\/li>\n<li>Buat Database PostgreSQL baru. Buat database baru bernama donadb menggunakan perintah\u00a0<code>createdb<\/code>:\n<pre>sudo su - postgres -c \"createdb donadb\"<\/pre>\n<\/li>\n<li>Untuk memberikan izin kepada pengguna\u00a0<code>dona<\/code>\u00a0pada database yang telah kita buat di langkah sebelumnya, sambungkan ke shell PostgreSQL:\n<pre>sudo -u postgres psql<\/pre>\n<p>dan jalankan kueri berikut :<\/p>\n<pre>grant all privileges on database donadb to dona;<\/pre>\n<\/li>\n<\/ol>\n<h2>Aktifkan remote access ke server PostgreSQL<\/h2>\n<p>Secara default, server PostgreSQL hanya listen pada antarmuka lokal\u00a0<code>127.0.0.1<\/code>. Untuk mengaktifkan akses jarak jauh ke server PostgreSQL, buka file konfigurasi<code>\u00a0postgresql.conf<\/code>\u00a0dan tambahkan\u00a0<code>listen_addresses=\"*\"<\/code>\u00a0di bagian\u00a0<code>CONNECTIONS AND AUTHENTICATION.<\/code><\/p>\n<pre>sudo nano \/etc\/postgresql\/10\/main\/postgresql.conf<\/pre>\n<pre>#------------------------------------------------------------------------------&#13;\n# CONNECTIONS AND AUTHENTICATION&#13;\n#------------------------------------------------------------------------------&#13;\n&#13;\n# - Connection Settings -&#13;\n&#13;\nlisten_addresses=\"*\"     # what IP address(es) to listen on;<\/pre>\n<p>simpan file dan restart layanan PostgreSQL dengan:<\/p>\n<pre>sudo service postgresql restart<\/pre>\n<p>Verifikasi perubahan dengan utilitas\u00a0<code>ss<\/code><\/p>\n<pre>ss -nlt | grep 5432<\/pre>\n<pre>LISTEN   0         128      0.0.0.0:5432  0.0.0.0:*&#13;\nLISTEN   0         128         [::]:5432     [::]:*<\/pre>\n<p>Seperti yang Anda lihat dari output di atas, server PostgreSQL listen pada semua interface<code>(0.0.0.0)<\/code>.<\/p>\n<p>Langkah terakhir adalah mengkonfigurasi server untuk menerima koneksi jarak jauh dengan mengedit file\u00a0<code>pg_hba.conf<\/code>.<\/p>\n<p>Berikut adalah beberapa contoh yang menunjukkan berbagai kasus penggunaan:<\/p>\n<pre>sudo nano \/etc\/postgresql\/10\/main\/pg_hba.conf<\/pre>\n<pre>\u00a0TYPE \u00a0DATABASE \u00a0 \u00a0 \u00a0 \u00a0USER \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0ADDRESS \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 METHOD&#13;\n# \"local\" is for Unix domain socket connections only&#13;\nlocal \u00a0 all \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 all \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0md5&#13;\n# IPv4 local connections:&#13;\nhost \u00a0 \u00a0all \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 all \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 0.0.0.0\/0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0md5&#13;\n# IPv6 local connections:&#13;\nhost \u00a0 \u00a0all \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 all \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 ::0\/0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 md5&#13;\n# All IPs&#13;\nhost \u00a0 \u00a0all \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 dona \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0all \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 trust<\/pre>\n<h2>Kesimpulan<\/h2>\n<p>Anda telah belajar cara menginstal dan mengkonfigurasi PostgreSQL di server CentOS 8 .<\/p>\n<p>Untuk informasi lebih lanjut tentang topik ini, kunjungi halaman dokumentasi\u00a0<a href=\"https:\/\/www.postgresql.org\/docs\/10.0\/static\/index.html\" target=\"_blank\" rel=\"noopener\">PostgreSQL.<\/a><span id=\"ezoic-pub-ad-placeholder-147\" class=\"ezoic-adpicker-ad\"\/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>PostgreSQL Role dan Metode Otentikasi Izin akses basis data dalam PostgreSQL ditangani dengan konsep peran.&hellip;<\/p>\n","protected":false},"author":2,"featured_media":1181,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[15,111,185,166],"class_list":["post-1180","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-centos","tag-centos","tag-centos-8","tag-postgresql","tag-sql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Cara Install dan Konfigurasi PostgreSQL di CentOS 8 - Linuxid<\/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:\/\/linuxid.net\/post\/cara-install-dan-konfigurasi-postgresql-di-centos-8\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Install dan Konfigurasi PostgreSQL di CentOS 8 - Linuxid\" \/>\n<meta property=\"og:description\" content=\"PostgreSQL Role dan Metode Otentikasi Izin akses basis data dalam PostgreSQL ditangani dengan konsep peran.&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/linuxid.net\/post\/cara-install-dan-konfigurasi-postgresql-di-centos-8\/\" \/>\n<meta property=\"og:site_name\" content=\"Linuxid\" \/>\n<meta property=\"article:published_time\" content=\"2019-11-17T18:06:21+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-18T08:21:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Install-dan-Konfigurasi-PostgreSQL-di-CentOS-8.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1000\" \/>\n\t<meta property=\"og:image:height\" content=\"530\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"xsand\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"xsand\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/linuxid.net\/post\/cara-install-dan-konfigurasi-postgresql-di-centos-8\/\",\"url\":\"https:\/\/linuxid.net\/post\/cara-install-dan-konfigurasi-postgresql-di-centos-8\/\",\"name\":\"Cara Install dan Konfigurasi PostgreSQL di CentOS 8 - Linuxid\",\"isPartOf\":{\"@id\":\"https:\/\/linuxid.net\/post\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/linuxid.net\/post\/cara-install-dan-konfigurasi-postgresql-di-centos-8\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/linuxid.net\/post\/cara-install-dan-konfigurasi-postgresql-di-centos-8\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Install-dan-Konfigurasi-PostgreSQL-di-CentOS-8.jpg\",\"datePublished\":\"2019-11-17T18:06:21+00:00\",\"dateModified\":\"2025-04-18T08:21:24+00:00\",\"author\":{\"@id\":\"https:\/\/linuxid.net\/post\/#\/schema\/person\/e6642d26041eab9fef2677e204e89d79\"},\"breadcrumb\":{\"@id\":\"https:\/\/linuxid.net\/post\/cara-install-dan-konfigurasi-postgresql-di-centos-8\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/linuxid.net\/post\/cara-install-dan-konfigurasi-postgresql-di-centos-8\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/linuxid.net\/post\/cara-install-dan-konfigurasi-postgresql-di-centos-8\/#primaryimage\",\"url\":\"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Install-dan-Konfigurasi-PostgreSQL-di-CentOS-8.jpg\",\"contentUrl\":\"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Install-dan-Konfigurasi-PostgreSQL-di-CentOS-8.jpg\",\"width\":1000,\"height\":530},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/linuxid.net\/post\/cara-install-dan-konfigurasi-postgresql-di-centos-8\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Beranda\",\"item\":\"https:\/\/linuxid.net\/post\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara Install dan Konfigurasi PostgreSQL di CentOS 8\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/linuxid.net\/post\/#website\",\"url\":\"https:\/\/linuxid.net\/post\/\",\"name\":\"Linuxid\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/linuxid.net\/post\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/linuxid.net\/post\/#\/schema\/person\/e6642d26041eab9fef2677e204e89d79\",\"name\":\"xsand\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/linuxid.net\/post\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/cc8513768e15fa0758099a0ba5b898f3?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/cc8513768e15fa0758099a0ba5b898f3?s=96&d=mm&r=g\",\"caption\":\"xsand\"},\"url\":\"https:\/\/www.linuxid.net\/post\/author\/xsand\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cara Install dan Konfigurasi PostgreSQL di CentOS 8 - Linuxid","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:\/\/linuxid.net\/post\/cara-install-dan-konfigurasi-postgresql-di-centos-8\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Install dan Konfigurasi PostgreSQL di CentOS 8 - Linuxid","og_description":"PostgreSQL Role dan Metode Otentikasi Izin akses basis data dalam PostgreSQL ditangani dengan konsep peran.&hellip;","og_url":"https:\/\/linuxid.net\/post\/cara-install-dan-konfigurasi-postgresql-di-centos-8\/","og_site_name":"Linuxid","article_published_time":"2019-11-17T18:06:21+00:00","article_modified_time":"2025-04-18T08:21:24+00:00","og_image":[{"width":1000,"height":530,"url":"https:\/\/linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Install-dan-Konfigurasi-PostgreSQL-di-CentOS-8.jpg","type":"image\/jpeg"}],"author":"xsand","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"xsand","Estimasi waktu membaca":"3 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/linuxid.net\/post\/cara-install-dan-konfigurasi-postgresql-di-centos-8\/","url":"https:\/\/linuxid.net\/post\/cara-install-dan-konfigurasi-postgresql-di-centos-8\/","name":"Cara Install dan Konfigurasi PostgreSQL di CentOS 8 - Linuxid","isPartOf":{"@id":"https:\/\/linuxid.net\/post\/#website"},"primaryImageOfPage":{"@id":"https:\/\/linuxid.net\/post\/cara-install-dan-konfigurasi-postgresql-di-centos-8\/#primaryimage"},"image":{"@id":"https:\/\/linuxid.net\/post\/cara-install-dan-konfigurasi-postgresql-di-centos-8\/#primaryimage"},"thumbnailUrl":"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Install-dan-Konfigurasi-PostgreSQL-di-CentOS-8.jpg","datePublished":"2019-11-17T18:06:21+00:00","dateModified":"2025-04-18T08:21:24+00:00","author":{"@id":"https:\/\/linuxid.net\/post\/#\/schema\/person\/e6642d26041eab9fef2677e204e89d79"},"breadcrumb":{"@id":"https:\/\/linuxid.net\/post\/cara-install-dan-konfigurasi-postgresql-di-centos-8\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/linuxid.net\/post\/cara-install-dan-konfigurasi-postgresql-di-centos-8\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/linuxid.net\/post\/cara-install-dan-konfigurasi-postgresql-di-centos-8\/#primaryimage","url":"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Install-dan-Konfigurasi-PostgreSQL-di-CentOS-8.jpg","contentUrl":"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Install-dan-Konfigurasi-PostgreSQL-di-CentOS-8.jpg","width":1000,"height":530},{"@type":"BreadcrumbList","@id":"https:\/\/linuxid.net\/post\/cara-install-dan-konfigurasi-postgresql-di-centos-8\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Beranda","item":"https:\/\/linuxid.net\/post\/"},{"@type":"ListItem","position":2,"name":"Cara Install dan Konfigurasi PostgreSQL di CentOS 8"}]},{"@type":"WebSite","@id":"https:\/\/linuxid.net\/post\/#website","url":"https:\/\/linuxid.net\/post\/","name":"Linuxid","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/linuxid.net\/post\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/linuxid.net\/post\/#\/schema\/person\/e6642d26041eab9fef2677e204e89d79","name":"xsand","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/linuxid.net\/post\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/cc8513768e15fa0758099a0ba5b898f3?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/cc8513768e15fa0758099a0ba5b898f3?s=96&d=mm&r=g","caption":"xsand"},"url":"https:\/\/www.linuxid.net\/post\/author\/xsand\/"}]}},"_links":{"self":[{"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/posts\/1180","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/comments?post=1180"}],"version-history":[{"count":1,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/posts\/1180\/revisions"}],"predecessor-version":[{"id":2759,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/posts\/1180\/revisions\/2759"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/media\/1181"}],"wp:attachment":[{"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/media?parent=1180"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/categories?post=1180"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/tags?post=1180"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}