{"id":710,"date":"2022-09-03T22:07:08","date_gmt":"2022-09-03T15:07:08","guid":{"rendered":"https:\/\/insideofcode.com\/blog\/?p=710"},"modified":"2022-09-15T11:38:03","modified_gmt":"2022-09-15T04:38:03","slug":"streaming-replication-postgresql-14-di-ubuntu-22-04-lts","status":"publish","type":"post","link":"https:\/\/insideofcode.com\/blog\/streaming-replication-postgresql-14-di-ubuntu-22-04-lts\/","title":{"rendered":"Streaming Replication Postgresql 14 di Ubuntu Server 22.04 LTS"},"content":{"rendered":"\n<p><em>Streaming Replication<\/em>, adalah salah satu fitur dari PostgreSQL, yang memungkinkan untuk melakukan replikasi data terhadap server <em>standby<\/em> yang bersumber dari server utama <em>(primary)<\/em>, informasi terbaru di server <em>primary<\/em> ditransfer ke server standby secara <em>realtime<\/em>, sehingga database server utama dan server <em>standby<\/em> dapat tetap sinkron. Fitur <em>Streaming Replication<\/em> ini membawa manfaat besar bagi sistem Anda.<\/p>\n\n\n\n<p>Baca juga : <a href=\"https:\/\/insideofcode.com\/blog\/cara-install-squid-proxy-di-ubuntu-22-04\/\">Cara-Install-Squid-Proxy-di-Ubuntu-22.04<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Cara Melakukan Streaming Replication Postgresql 14<\/h2>\n\n\n\n<p>Berikut ini adalah langkah-langkah untuk melakukan Streaming Replication Postgrsql 14 di Ubuntu Server 22.04 LTS :<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">1. Install dan jalankan Postgrsql 14<\/h3>\n\n\n\n<p>Langkap pertama install dan jalankan service postgrsql 14 di semua node server primary maupun standby.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">2. Konfigurasi server primary <em>(Primary Node)<\/em><\/h3>\n\n\n\n<p>Edit file konfigurasi <code>postgresql.conf<\/code><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">root@primary-node:~# nano \/etc\/postgresql\/14\/main\/postgresql.conf<\/code><\/pre>\n\n\n\n<p>Modifikasi beberapa konfigurasi untuk kebutuhan replikasi<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\"># line 60 : uncomment and change\n# Bagian ini supaya server postgresql dapat diakses secara remote\nlisten_addresses = '*'\n\n# line 205 : uncomment\nwal_level = replica\n\n# line 210 : uncomment\nsynchronous_commit = on\n\n# line 298 : uncomment\n# maximum koneksi yang terhubung secara bersamaan dari server streaming client\nmax_wal_senders = 10\n\n# line 312 : uncomment and change\nsynchronous_standby_names = '*'<\/code><\/pre>\n\n\n\n<p>Selanjutnya, edit file konfigurasi <em>authentication<\/em> <code>pg_hba.conf<\/code><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">root@primary-node:~# nano \/etc\/postgresql\/14\/main\/pg_hba.conf<\/code><\/pre>\n\n\n\n<p>Tambahkan beberapa baris konfigurasi berikut ini di akhir baris<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\"># host replication [replication user] [allowed network] [authentication method]\nhost    replication     user_replica        10.0.0.30\/32            scram-sha-256\n\n\n# Keterangan :\n# host = jalur koneksi\n# replication = tipe koneksi\n# rep_user = user yang bisa replikasi\n# 10.0.0.30\/32 = IP node replika bisa ip public atau private IP jika dalam 1 network\n# scram-sha-256 = metode autentikasi<\/code><\/pre>\n\n\n\n<p>Buat user replikasi <em>(<code>user_replica<\/code>)<\/em><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">root@primary-node:~# su - postgres\npostgres@primary-node:~$ createuser --replication -P user_replica\n\nEnter password for new role:   # masukan password untuk user 'user_replica'\nEnter it again:\n\npostgres@primary-node:~$ exit\n\n#Restart service\nroot@primary-node:~# systemctl restart postgresql<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">3. Konfigurasi server replika <em>(Replica Node)<\/em><\/h3>\n\n\n\n<p>Pertama-tama stop service database yang sedang berjalan<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">root@replica-node:~# systemctl stop postgresql<\/code><\/pre>\n\n\n\n<p>Hapus data yang sudah ada, karena akan diganti dengan backup dari <em>node primary<\/em>.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">root@replica-node:~# rm -rf \/var\/lib\/postgresql\/14\/main\/*<\/code><\/pre>\n\n\n\n<p>Backup data dari server primary <em>(primary node)<\/em><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">root@replica-node:~# su - postgres\npostgres@replica-node:~$ pg_basebackup -R -h www.host-or-ip-primary-node.com -U user_replica -D \/var\/lib\/postgresql\/14\/main -P\nPassword:   # password of replication user 'user_replica' yang sudah dibuat diatas\n\n34825\/34825 kB (100%), 1\/1 tablespace\n\npostgres@replica-node:~$ exit<\/code><\/pre>\n\n\n\n<p>Atur konfigurasi <code>postgresql.conf <\/code> di server replika<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">postgres@replica-node:~# nano \/etc\/postgresql\/14\/main\/postgresql.conf\n\n# line 60 : uncomment and change\nlisten_addresses = '*'\n\n# line 325 : uncomment\nhot_standby = on<\/code><\/pre>\n\n\n\n<p>Restart service database postgrsql<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code class=\"\">root@replica-node:~# systemctl start postgresql<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">4. Sekarang tinggal pastikan bahwa server <em>replica<\/em> sudah terhubung dengan server <em>primary<\/em><\/h3>\n\n\n\n<p>Jalankan query <code>'select usename, application_name, client_addr, state, sync_priority, sync_state from pg_stat_replication;'<\/code> untuk melihat server yang terhubung ke server <em>primary<\/em>.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">root@replica-node:~# su - postgres\npostgres@primary-node:~$ psql -c \"select usename, application_name, client_addr, state, sync_priority, sync_state from pg_stat_replication;\"\n\n usename  | application_name | client_addr |   state   | sync_priority | sync_state\n----------+------------------+-------------+-----------+---------------+------------\n rep_user | 14\/main          | 10.0.0.30   | streaming |             1 | sync\n(1 row)<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Penutup<\/h2>\n\n\n\n<p>Itulah cara melakukan streaming replication postgresql di Ubuntu 22.04 LTS, silahkan share atau <em>bookmark<\/em> jika artikel ini bermanfaat. Terimakasih.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Refferance<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/www.postgresql.org\/docs\/current\/runtime-config-replication.html\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">https:\/\/www.postgresql.org\/docs\/current\/runtime-config-replication.html<\/a><\/li><\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Streaming Replication, adalah salah satu fitur dari PostgreSQL, yang memungkinkan untuk melakukan replikasi data terhadap server standby yang bersumber dari server utama (primary), informasi terbaru di server primary ditransfer ke server standby secara realtime, sehingga database server utama dan server standby dapat tetap sinkron. <\/p>\n","protected":false},"author":1,"featured_media":718,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[26,58,42,2],"tags":[40,41,127],"class_list":["post-710","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-sql","category-postgresql","category-server","category-linux-tutorial","tag-database","tag-postgresql","tag-replication"],"blocksy_meta":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Streaming Replication Postgresql 14 di Ubuntu Server 22.04 LTS<\/title>\n<meta name=\"description\" content=\"Streaming Replication, adalah salah satu fitur dari PostgreSQL, yang memungkinkan untuk melakukan replikasi data terhadap server standby yang bersumber dari server utama (primary)\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/insideofcode.com\/blog\/streaming-replication-postgresql-14-di-ubuntu-22-04-lts\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Streaming Replication Postgresql 14 di Ubuntu Server 22.04 LTS\" \/>\n<meta property=\"og:description\" content=\"Streaming Replication, adalah salah satu fitur dari PostgreSQL, yang memungkinkan untuk melakukan replikasi data terhadap server standby yang bersumber dari server utama (primary)\" \/>\n<meta property=\"og:url\" content=\"https:\/\/insideofcode.com\/blog\/streaming-replication-postgresql-14-di-ubuntu-22-04-lts\/\" \/>\n<meta property=\"og:site_name\" content=\"Inside of Code\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-03T15:07:08+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-09-15T04:38:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/insideofcode.com\/wp-content\/uploads\/2022\/08\/streaming-replication-postgresql-14.png\" \/>\n\t<meta property=\"og:image:width\" content=\"674\" \/>\n\t<meta property=\"og:image:height\" content=\"402\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Dani\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dani\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/insideofcode.com\/blog\/streaming-replication-postgresql-14-di-ubuntu-22-04-lts\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/insideofcode.com\/blog\/streaming-replication-postgresql-14-di-ubuntu-22-04-lts\/\"},\"author\":{\"name\":\"Dani\",\"@id\":\"https:\/\/insideofcode.com\/blog\/#\/schema\/person\/1c6cafc6659067aa7ac1fd1a5ced218d\"},\"headline\":\"Streaming Replication Postgresql 14 di Ubuntu Server 22.04 LTS\",\"datePublished\":\"2022-09-03T15:07:08+00:00\",\"dateModified\":\"2022-09-15T04:38:03+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/insideofcode.com\/blog\/streaming-replication-postgresql-14-di-ubuntu-22-04-lts\/\"},\"wordCount\":221,\"publisher\":{\"@id\":\"https:\/\/insideofcode.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/insideofcode.com\/blog\/streaming-replication-postgresql-14-di-ubuntu-22-04-lts\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/insideofcode.com\/wp-content\/uploads\/2022\/08\/streaming-replication-postgresql-14.png\",\"keywords\":[\"database\",\"postgresql\",\"replication\"],\"articleSection\":[\"Database (SQL)\",\"Postgresql\",\"Server\",\"Tutorial Linux\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/insideofcode.com\/blog\/streaming-replication-postgresql-14-di-ubuntu-22-04-lts\/\",\"url\":\"https:\/\/insideofcode.com\/blog\/streaming-replication-postgresql-14-di-ubuntu-22-04-lts\/\",\"name\":\"Streaming Replication Postgresql 14 di Ubuntu Server 22.04 LTS\",\"isPartOf\":{\"@id\":\"https:\/\/insideofcode.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/insideofcode.com\/blog\/streaming-replication-postgresql-14-di-ubuntu-22-04-lts\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/insideofcode.com\/blog\/streaming-replication-postgresql-14-di-ubuntu-22-04-lts\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/insideofcode.com\/wp-content\/uploads\/2022\/08\/streaming-replication-postgresql-14.png\",\"datePublished\":\"2022-09-03T15:07:08+00:00\",\"dateModified\":\"2022-09-15T04:38:03+00:00\",\"description\":\"Streaming Replication, adalah salah satu fitur dari PostgreSQL, yang memungkinkan untuk melakukan replikasi data terhadap server standby yang bersumber dari server utama (primary)\",\"breadcrumb\":{\"@id\":\"https:\/\/insideofcode.com\/blog\/streaming-replication-postgresql-14-di-ubuntu-22-04-lts\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/insideofcode.com\/blog\/streaming-replication-postgresql-14-di-ubuntu-22-04-lts\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/insideofcode.com\/blog\/streaming-replication-postgresql-14-di-ubuntu-22-04-lts\/#primaryimage\",\"url\":\"https:\/\/insideofcode.com\/wp-content\/uploads\/2022\/08\/streaming-replication-postgresql-14.png\",\"contentUrl\":\"https:\/\/insideofcode.com\/wp-content\/uploads\/2022\/08\/streaming-replication-postgresql-14.png\",\"width\":674,\"height\":402,\"caption\":\"Replication Postgrsql 14\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/insideofcode.com\/blog\/streaming-replication-postgresql-14-di-ubuntu-22-04-lts\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/insideofcode.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Streaming Replication Postgresql 14 di Ubuntu Server 22.04 LTS\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/insideofcode.com\/blog\/#website\",\"url\":\"https:\/\/insideofcode.com\/blog\/\",\"name\":\"Inside of Code\",\"description\":\"A software engineer who wants to share what he has learned, and document his journey.\",\"publisher\":{\"@id\":\"https:\/\/insideofcode.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/insideofcode.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/insideofcode.com\/blog\/#organization\",\"name\":\"Inside of Code\",\"url\":\"https:\/\/insideofcode.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/insideofcode.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/insideofcode.com\/wp-content\/uploads\/2022\/10\/logo-ioc.png\",\"contentUrl\":\"https:\/\/insideofcode.com\/wp-content\/uploads\/2022\/10\/logo-ioc.png\",\"width\":324,\"height\":324,\"caption\":\"Inside of Code\"},\"image\":{\"@id\":\"https:\/\/insideofcode.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/insideofcode.com\/blog\/#\/schema\/person\/1c6cafc6659067aa7ac1fd1a5ced218d\",\"name\":\"Dani\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/insideofcode.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a4b1e4251720747aef0418e09fe0f6e7786ff89358b57f76822f1c52c286552b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a4b1e4251720747aef0418e09fe0f6e7786ff89358b57f76822f1c52c286552b?s=96&d=mm&r=g\",\"caption\":\"Dani\"},\"sameAs\":[\"https:\/\/insideofcode.com\/blog\"],\"url\":\"https:\/\/insideofcode.com\/blog\/author\/daniwork\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Streaming Replication Postgresql 14 di Ubuntu Server 22.04 LTS","description":"Streaming Replication, adalah salah satu fitur dari PostgreSQL, yang memungkinkan untuk melakukan replikasi data terhadap server standby yang bersumber dari server utama (primary)","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:\/\/insideofcode.com\/blog\/streaming-replication-postgresql-14-di-ubuntu-22-04-lts\/","og_locale":"en_US","og_type":"article","og_title":"Streaming Replication Postgresql 14 di Ubuntu Server 22.04 LTS","og_description":"Streaming Replication, adalah salah satu fitur dari PostgreSQL, yang memungkinkan untuk melakukan replikasi data terhadap server standby yang bersumber dari server utama (primary)","og_url":"https:\/\/insideofcode.com\/blog\/streaming-replication-postgresql-14-di-ubuntu-22-04-lts\/","og_site_name":"Inside of Code","article_published_time":"2022-09-03T15:07:08+00:00","article_modified_time":"2022-09-15T04:38:03+00:00","og_image":[{"width":674,"height":402,"url":"https:\/\/insideofcode.com\/wp-content\/uploads\/2022\/08\/streaming-replication-postgresql-14.png","type":"image\/png"}],"author":"Dani","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Dani","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/insideofcode.com\/blog\/streaming-replication-postgresql-14-di-ubuntu-22-04-lts\/#article","isPartOf":{"@id":"https:\/\/insideofcode.com\/blog\/streaming-replication-postgresql-14-di-ubuntu-22-04-lts\/"},"author":{"name":"Dani","@id":"https:\/\/insideofcode.com\/blog\/#\/schema\/person\/1c6cafc6659067aa7ac1fd1a5ced218d"},"headline":"Streaming Replication Postgresql 14 di Ubuntu Server 22.04 LTS","datePublished":"2022-09-03T15:07:08+00:00","dateModified":"2022-09-15T04:38:03+00:00","mainEntityOfPage":{"@id":"https:\/\/insideofcode.com\/blog\/streaming-replication-postgresql-14-di-ubuntu-22-04-lts\/"},"wordCount":221,"publisher":{"@id":"https:\/\/insideofcode.com\/blog\/#organization"},"image":{"@id":"https:\/\/insideofcode.com\/blog\/streaming-replication-postgresql-14-di-ubuntu-22-04-lts\/#primaryimage"},"thumbnailUrl":"https:\/\/insideofcode.com\/wp-content\/uploads\/2022\/08\/streaming-replication-postgresql-14.png","keywords":["database","postgresql","replication"],"articleSection":["Database (SQL)","Postgresql","Server","Tutorial Linux"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/insideofcode.com\/blog\/streaming-replication-postgresql-14-di-ubuntu-22-04-lts\/","url":"https:\/\/insideofcode.com\/blog\/streaming-replication-postgresql-14-di-ubuntu-22-04-lts\/","name":"Streaming Replication Postgresql 14 di Ubuntu Server 22.04 LTS","isPartOf":{"@id":"https:\/\/insideofcode.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/insideofcode.com\/blog\/streaming-replication-postgresql-14-di-ubuntu-22-04-lts\/#primaryimage"},"image":{"@id":"https:\/\/insideofcode.com\/blog\/streaming-replication-postgresql-14-di-ubuntu-22-04-lts\/#primaryimage"},"thumbnailUrl":"https:\/\/insideofcode.com\/wp-content\/uploads\/2022\/08\/streaming-replication-postgresql-14.png","datePublished":"2022-09-03T15:07:08+00:00","dateModified":"2022-09-15T04:38:03+00:00","description":"Streaming Replication, adalah salah satu fitur dari PostgreSQL, yang memungkinkan untuk melakukan replikasi data terhadap server standby yang bersumber dari server utama (primary)","breadcrumb":{"@id":"https:\/\/insideofcode.com\/blog\/streaming-replication-postgresql-14-di-ubuntu-22-04-lts\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/insideofcode.com\/blog\/streaming-replication-postgresql-14-di-ubuntu-22-04-lts\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/insideofcode.com\/blog\/streaming-replication-postgresql-14-di-ubuntu-22-04-lts\/#primaryimage","url":"https:\/\/insideofcode.com\/wp-content\/uploads\/2022\/08\/streaming-replication-postgresql-14.png","contentUrl":"https:\/\/insideofcode.com\/wp-content\/uploads\/2022\/08\/streaming-replication-postgresql-14.png","width":674,"height":402,"caption":"Replication Postgrsql 14"},{"@type":"BreadcrumbList","@id":"https:\/\/insideofcode.com\/blog\/streaming-replication-postgresql-14-di-ubuntu-22-04-lts\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/insideofcode.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Streaming Replication Postgresql 14 di Ubuntu Server 22.04 LTS"}]},{"@type":"WebSite","@id":"https:\/\/insideofcode.com\/blog\/#website","url":"https:\/\/insideofcode.com\/blog\/","name":"Inside of Code","description":"A software engineer who wants to share what he has learned, and document his journey.","publisher":{"@id":"https:\/\/insideofcode.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/insideofcode.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/insideofcode.com\/blog\/#organization","name":"Inside of Code","url":"https:\/\/insideofcode.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/insideofcode.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/insideofcode.com\/wp-content\/uploads\/2022\/10\/logo-ioc.png","contentUrl":"https:\/\/insideofcode.com\/wp-content\/uploads\/2022\/10\/logo-ioc.png","width":324,"height":324,"caption":"Inside of Code"},"image":{"@id":"https:\/\/insideofcode.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/insideofcode.com\/blog\/#\/schema\/person\/1c6cafc6659067aa7ac1fd1a5ced218d","name":"Dani","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/insideofcode.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/a4b1e4251720747aef0418e09fe0f6e7786ff89358b57f76822f1c52c286552b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a4b1e4251720747aef0418e09fe0f6e7786ff89358b57f76822f1c52c286552b?s=96&d=mm&r=g","caption":"Dani"},"sameAs":["https:\/\/insideofcode.com\/blog"],"url":"https:\/\/insideofcode.com\/blog\/author\/daniwork\/"}]}},"_links":{"self":[{"href":"https:\/\/insideofcode.com\/blog\/wp-json\/wp\/v2\/posts\/710","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/insideofcode.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/insideofcode.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/insideofcode.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/insideofcode.com\/blog\/wp-json\/wp\/v2\/comments?post=710"}],"version-history":[{"count":0,"href":"https:\/\/insideofcode.com\/blog\/wp-json\/wp\/v2\/posts\/710\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/insideofcode.com\/blog\/wp-json\/wp\/v2\/media\/718"}],"wp:attachment":[{"href":"https:\/\/insideofcode.com\/blog\/wp-json\/wp\/v2\/media?parent=710"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/insideofcode.com\/blog\/wp-json\/wp\/v2\/categories?post=710"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/insideofcode.com\/blog\/wp-json\/wp\/v2\/tags?post=710"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}