{"id":3025,"date":"2019-11-13T16:04:46","date_gmt":"2019-11-13T09:04:46","guid":{"rendered":"https:\/\/www.linuxid.net\/post\/?p=3025"},"modified":"2025-04-18T16:06:09","modified_gmt":"2025-04-18T09:06:09","slug":"cara-melihat-atau-periksa-versi-postgresql-2","status":"publish","type":"post","link":"https:\/\/www.linuxid.net\/post\/cara-melihat-atau-periksa-versi-postgresql-2\/","title":{"rendered":"Cara Melihat atau Periksa Versi PostgreSQL"},"content":{"rendered":"<p>PostgreSQL atau Postgres adalah\u00a0sistem manajemen relasional database open-source dengan banyak fitur canggih yang memungkinkan Anda untuk membangun lingkungan\u00a0<em>fault-tolerant<\/em>\u00a0ataupun aplikasi yang kompleks.<\/p>\n<p>Dalam panduan ini, kita akan membahas cara\u00a0mengetahui versi PostgreSQL server yang berjalan pada sistem Anda,\u00a0mengetahui versi PostgreSQL sangat penting dalam beberapa situasi. Misalnya, jika Anda menginstal aplikasi yang memerlukan versi PostgreSQL tertentu, Anda harus mengetahui versi server PostgreSQL Anda.<\/p>\n<h2>Format Versi PostgreSQL<\/h2>\n<p>Rilis PostgreSQL menggunakan skema versi berikut:<\/p>\n<div class=\"highlight\">\n<pre class=\"chroma\"><code class=\"language-sh\" data-lang=\"sh\">MAJOR.MINOR<\/code><\/pre>\n<\/div>\n<p>Sebagai contoh, dalam PostgreSQL 12.1, angka <code>12<\/code> adalah versi major, dan <code>1<\/code> adalah versi minor.<\/p>\n<ul>\n<li><strong>MAJOR<\/strong> &#8211; Dimulai dengan PostgreSQL 10, setiap rilis baru maka penomoran versi MAJOR meningkat satu, mis., 10, 11 atau 12. Sebelum PostgreSQL 10, versi major diwakili dengan angka desimal mis. 9.0 atau 9.6.<\/li>\n<li><strong>MINOR<\/strong> &#8211; Nomor rilis minor adalah bagian terakhir dari nomor versi. Sebagai contoh, 11.4 dan 11.6 adalah versi minor yang merupakan bagian dari PostgreSQL versi 11, dan 9.6.15 dan 9.6.16 adalah bagian dari PostgreSQL versi 9.6.<\/li>\n<\/ul>\n<p>Rilis major PostgreSQL dengan fitur baru biasanya dikirimkan setahun sekali. Setiap rilis major didukung selama 5 tahun.<\/p>\n<h2>Mengetahui versi PostgreSQL dari Baris Perintah<\/h2>\n<p>Untuk mengetahui versi PostgreSQL apa yang berjalan di sistem Anda, aktifkan perintah <code>postgres<\/code>\u00a0dengan opsi <code>--version<\/code> atau <code>-V<\/code>:<\/p>\n<div class=\"highlight\">\n<pre class=\"chroma console-bash\"><code class=\"language-console-bash\" data-lang=\"console-bash\"><span class=\"line\">postgres --version<\/span><\/code><\/pre>\n<\/div>\n<p>Perintah akan mencetak versi PostgreSQL:<\/p>\n<div class=\"highlight\">\n<pre class=\"chroma\"><code class=\"language-output\" data-lang=\"output\">postgres (PostgreSQL) 10.5<\/code><\/pre>\n<\/div>\n<p>Dalam contoh ini, versi server PostgreSQL adalah <code>10.6<\/code>.<\/p>\n<p>Jika\u00a0binary <code>postgres<\/code>tidak ada dalam <a href=\"https:\/\/www.linuxid.net\/post\/cara-menambahkan-direktori-ke-path-di-linux\/\">PATH<\/a> sistem, Anda akan mendapatkan pesan error &#8220;<em>postgres: command not found<\/em>&#8220;. Ini biasanya terjadi ketika paket PostgreSQL tidak diinstal dari repositori standar distribusi.<\/p>\n<p>Anda dapat menemukan path ke biner dengan perintah <a href=\"https:\/\/www.linuxid.net\/post\/tutorial-dan-penggunaan-perintah-locate-di-linux\/\"><code>locate<\/code><\/a>\u00a0atau dengan perintah <a href=\"https:\/\/www.linuxid.net\/post\/tutorial-perintah-find-untuk-mencari-file-di-linux-terminal\/\"><code>find<\/code><\/a>\u00a0:<\/p>\n<div class=\"highlight\">\n<pre class=\"chroma console-bash\"><code class=\"language-console-bash\" data-lang=\"console-bash\"><span class=\"line\">sudo find \/usr -wholename '*\/bin\/postgres'\r\n<\/span><\/code><\/pre>\n<\/div>\n<div class=\"highlight\">\n<pre class=\"chroma console-bash\"><code class=\"language-console-bash\" data-lang=\"console-bash\"><span class=\"line\">sudo updatedb\r\n<\/span><span class=\"line\">locate bin\/postgres<\/span><\/code><\/pre>\n<\/div>\n<p>Outputnya akan terlihat seperti ini:<\/p>\n<div class=\"highlight\">\n<pre class=\"chroma\"><code class=\"language-output\" data-lang=\"output\">\/usr\/lib\/postgresql\/9.6\/bin\/postgres<\/code><\/pre>\n<\/div>\n<p>Setelah Anda menemukan path ke binary, Anda dapat menggunakannya untuk mendapatkan versi server PostgreSQL:<\/p>\n<div class=\"highlight\">\n<pre class=\"chroma console-bash\"><code class=\"language-console-bash\" data-lang=\"console-bash\"><span class=\"line\">\/usr\/lib\/postgresql\/9.6\/bin\/postgres -V<\/span><\/code><\/pre>\n<\/div>\n<p>Versi PostgreSQL client utility, <code>psql<\/code>\u00a0dapat ditemukan menggunakan perintah berikut:<\/p>\n<div class=\"highlight\">\n<pre class=\"chroma console-bash\"><code class=\"language-console-bash\" data-lang=\"console-bash\"><span class=\"line\">psql --version<\/span><\/code><\/pre>\n<\/div>\n<p>Outputnya akan terlihat seperti ini :<\/p>\n<div class=\"highlight\">\n<pre class=\"chroma\"><code class=\"language-output\" data-lang=\"output\">postgres (PostgreSQL) 10.6<\/code><\/pre>\n<\/div>\n<p><code>psql<\/code>\u00a0adalah utilitas baris perintah interaktif yang memungkinkan Anda untuk berinteraksi dengan PostgreSQL server .<\/p>\n<h2>Menggunakan SQL Shell<\/h2>\n<p>Cara lain untuk melihat versi PostgreSQL server adalah masuk ke prompt SQL server dan gunakan pernyataan SQL untuk mencetak versi.<\/p>\n<p>Anda dapat mengakses shell PostgreSQL menggunakan klien GUI seperti pgAdmin atau dengan <code>psql<\/code>:<\/p>\n<div class=\"highlight\">\n<pre class=\"chroma console-bash\"><code class=\"language-console-bash\" data-lang=\"console-bash\"><span class=\"line\">sudo -u postgres psql\r\n<\/span><\/code><\/pre>\n<\/div>\n<p>Statement berikut menampilkan versi PostgreSQL server bersama dengan informasi build:<\/p>\n<div class=\"highlight\">\n<pre class=\"chroma\"><code class=\"language-sql\" data-lang=\"sql\"><span class=\"k\">SELECT<\/span> <span class=\"k\">version<\/span><span class=\"p\">();<\/span><\/code><\/pre>\n<\/div>\n<div class=\"highlight\">\n<pre class=\"chroma\"><code class=\"language-output\" data-lang=\"output\">                                                  version                                                   \r\n------------------------------------------------------------------------------------------------------------\r\n PostgreSQL 10.6 on x86_64-redhat-linux-gnu, compiled by gcc (GCC) 8.2.1 20180905 (Red Hat 8.2.1-3), 64-bit\r\n(1 row)<\/code><\/pre>\n<\/div>\n<p>Jika Anda hanya ingin mendapatkan nomor versi PostgreSQL\u00a0server gunakan kueri berikut:<\/p>\n<div class=\"highlight\">\n<pre class=\"chroma\"><code class=\"language-sql\" data-lang=\"sql\"><span class=\"k\">SHOW<\/span> <span class=\"n\">server_version<\/span><span class=\"p\">;<\/span><\/code><\/pre>\n<\/div>\n<div class=\"highlight\">\n<pre class=\"chroma\"><code class=\"language-output\" data-lang=\"output\"> server_version \r\n----------------\r\n 10.6\r\n(1 row)<\/code><\/pre>\n<\/div>\n<h2>Kesimpulan<\/h2>\n<p>Pada artikel ini, kami telah menunjukkan beberapa opsi berbeda tentang cara menemukan versi PostgreSQL\u00a0server yang berjalan di sistem Anda.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>PostgreSQL atau Postgres adalah\u00a0sistem manajemen relasional database open-source dengan banyak fitur canggih yang memungkinkan Anda&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[107],"tags":[185,14],"class_list":["post-3025","post","type-post","status-publish","format-standard","hentry","category-other","tag-postgresql","tag-web-server"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Cara Melihat atau Periksa Versi PostgreSQL - 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-melihat-atau-periksa-versi-postgresql-2\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Melihat atau Periksa Versi PostgreSQL - Linuxid\" \/>\n<meta property=\"og:description\" content=\"PostgreSQL atau Postgres adalah\u00a0sistem manajemen relasional database open-source dengan banyak fitur canggih yang memungkinkan Anda&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/linuxid.net\/post\/cara-melihat-atau-periksa-versi-postgresql-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Linuxid\" \/>\n<meta property=\"article:published_time\" content=\"2019-11-13T09:04:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-18T09:06:09+00:00\" \/>\n<meta name=\"author\" content=\"adhit\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"adhit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/linuxid.net\/post\/cara-melihat-atau-periksa-versi-postgresql-2\/\",\"url\":\"https:\/\/linuxid.net\/post\/cara-melihat-atau-periksa-versi-postgresql-2\/\",\"name\":\"Cara Melihat atau Periksa Versi PostgreSQL - Linuxid\",\"isPartOf\":{\"@id\":\"https:\/\/linuxid.net\/post\/#website\"},\"datePublished\":\"2019-11-13T09:04:46+00:00\",\"dateModified\":\"2025-04-18T09:06:09+00:00\",\"author\":{\"@id\":\"https:\/\/linuxid.net\/post\/#\/schema\/person\/9670f38ed887366bf773a282796d5c55\"},\"breadcrumb\":{\"@id\":\"https:\/\/linuxid.net\/post\/cara-melihat-atau-periksa-versi-postgresql-2\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/linuxid.net\/post\/cara-melihat-atau-periksa-versi-postgresql-2\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/linuxid.net\/post\/cara-melihat-atau-periksa-versi-postgresql-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Beranda\",\"item\":\"https:\/\/linuxid.net\/post\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara Melihat atau Periksa Versi PostgreSQL\"}]},{\"@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\/9670f38ed887366bf773a282796d5c55\",\"name\":\"adhit\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/linuxid.net\/post\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f57a6d7efa0a8715b2ef7bafcd878e89?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f57a6d7efa0a8715b2ef7bafcd878e89?s=96&d=mm&r=g\",\"caption\":\"adhit\"},\"sameAs\":[\"https:\/\/linuxid.net\/post\"],\"url\":\"https:\/\/www.linuxid.net\/post\/author\/adhit\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cara Melihat atau Periksa Versi PostgreSQL - 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-melihat-atau-periksa-versi-postgresql-2\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Melihat atau Periksa Versi PostgreSQL - Linuxid","og_description":"PostgreSQL atau Postgres adalah\u00a0sistem manajemen relasional database open-source dengan banyak fitur canggih yang memungkinkan Anda&hellip;","og_url":"https:\/\/linuxid.net\/post\/cara-melihat-atau-periksa-versi-postgresql-2\/","og_site_name":"Linuxid","article_published_time":"2019-11-13T09:04:46+00:00","article_modified_time":"2025-04-18T09:06:09+00:00","author":"adhit","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"adhit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/linuxid.net\/post\/cara-melihat-atau-periksa-versi-postgresql-2\/","url":"https:\/\/linuxid.net\/post\/cara-melihat-atau-periksa-versi-postgresql-2\/","name":"Cara Melihat atau Periksa Versi PostgreSQL - Linuxid","isPartOf":{"@id":"https:\/\/linuxid.net\/post\/#website"},"datePublished":"2019-11-13T09:04:46+00:00","dateModified":"2025-04-18T09:06:09+00:00","author":{"@id":"https:\/\/linuxid.net\/post\/#\/schema\/person\/9670f38ed887366bf773a282796d5c55"},"breadcrumb":{"@id":"https:\/\/linuxid.net\/post\/cara-melihat-atau-periksa-versi-postgresql-2\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/linuxid.net\/post\/cara-melihat-atau-periksa-versi-postgresql-2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/linuxid.net\/post\/cara-melihat-atau-periksa-versi-postgresql-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Beranda","item":"https:\/\/linuxid.net\/post\/"},{"@type":"ListItem","position":2,"name":"Cara Melihat atau Periksa Versi PostgreSQL"}]},{"@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\/9670f38ed887366bf773a282796d5c55","name":"adhit","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/linuxid.net\/post\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/f57a6d7efa0a8715b2ef7bafcd878e89?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f57a6d7efa0a8715b2ef7bafcd878e89?s=96&d=mm&r=g","caption":"adhit"},"sameAs":["https:\/\/linuxid.net\/post"],"url":"https:\/\/www.linuxid.net\/post\/author\/adhit\/"}]}},"_links":{"self":[{"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/posts\/3025","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/comments?post=3025"}],"version-history":[{"count":1,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/posts\/3025\/revisions"}],"predecessor-version":[{"id":3026,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/posts\/3025\/revisions\/3026"}],"wp:attachment":[{"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/media?parent=3025"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/categories?post=3025"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/tags?post=3025"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}