{"id":37733,"date":"2022-04-06T11:18:15","date_gmt":"2022-04-06T11:18:15","guid":{"rendered":"https:\/\/dbtut.com\/?p=37733"},"modified":"2022-04-06T11:18:57","modified_gmt":"2022-04-06T11:18:57","slug":"creating-a-hot-standby-in-postgresql","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2022\/04\/06\/creating-a-hot-standby-in-postgresql\/","title":{"rendered":"Creating A Hot Standby In PostgreSQL"},"content":{"rendered":"<p>In today&#8217;s post, I will show you Creating A Hot Standby In PostgreSQL.<\/p>\n<p>PostgreSQL Community 13 Installation:<\/p>\n<pre class=\"lang:default decode:true\">https:\/\/dbtut.com\/index.php\/2022\/03\/13\/postgresql-community-13-installation-on-oracle-linux-7\/<\/pre>\n<p>To create Stanby, we need two servers with Postgresql Community 13 installed.<\/p>\n<p>If you have not installed, you can install from the link above.<\/p>\n<p>There are operations that need to be done on both the master and standby server.<\/p>\n<p>We will start with the operations that need to be done on the master server.<\/p>\n<p>Master Server IP:192.168.1.12<\/p>\n<p>Standby Server IP:192.168.1.14<\/p>\n<h4>Actions to be taken on the Master Server:<\/h4>\n<p>1.We check if the master database is in archive mode.<\/p>\n<pre class=\"lang:default decode:true \">postgres=# show archive_mode;\r\n archive_mode \r\n--------------\r\n off\r\n(1 row)<\/pre>\n<p>2. Since the database is not in archive mode, we put the database in archive mode.<\/p>\n<p>We ensure that our archives are sent to the standby database with the archive_command parameter.<\/p>\n<p>With vi, we change the contents of the postgresql.conf file as follows.<\/p>\n<pre class=\"lang:default decode:true \">bash-4.2$ vi \/var\/lib\/pgsql\/13\/data\/postgresql.conf\r\narchive_mode = on\r\narchive_command = 'rsync -a %p postgres@192.168.1.14:\/var\/lib\/pgsql\/13\/ARCHIVELOG\/%f'<\/pre>\n<p>3. Since we will create stanby later, we also set the following parameters in the postgresql.conf file.<\/p>\n<pre class=\"lang:default decode:true \">bash-4.2$ vi \/var\/lib\/pgsql\/13\/data\/postgresql.conf\r\nwal_level = replica\r\nmax_wal_senders = 3\r\nmax_replication_slots = 4<\/pre>\n<p>4. We must restart the postgresql service for the changes we made in the postgresql.conf file to take effect.<\/p>\n<pre class=\"lang:default decode:true \">$ systemctl restart postgresql-13.service<\/pre>\n<p>5. Replication user is created.<\/p>\n<pre class=\"lang:default decode:true \">bash-4.2$ psql postgres\r\npostgres# CREATE ROLE replication WITH REPLICATION PASSWORD 'pass' LOGIN<\/pre>\n<p>6. To access the database from outside, the listen address should be set as follows and the following changes should be made in pg_hba.conf.<\/p>\n<pre class=\"lang:default decode:true \">bash-4.2$ vi \/var\/lib\/pgsql\/13\/data\/postgresql.conf\r\nlisten_addresses = '*'\r\n-bash-4.2$ vi \/var\/lib\/pgsql\/13\/data\/pg_hba.conf\r\n# IPv4 local connections:\r\nhost    all             all             0.0.0.0\/0               md5<\/pre>\n<p>7. Add the following line to the pg_hba.conf file. (We set the IP of the standby server.)<\/p>\n<pre class=\"lang:default decode:true \">-bash-4.2$ vi \/var\/lib\/pgsql\/13\/data\/pg_hba.conf\r\nhost  replication     replication     192.168.1.14\/32         md5<\/pre>\n<p>8. After the change is made, we restart the service.<\/p>\n<pre class=\"lang:default decode:true \">$ systemctl restart postgresql-13.service<\/pre>\n<h4>Actions to be taken on Standby Server:<\/h4>\n<p>1.We stop the service.<\/p>\n<pre class=\"lang:default decode:true \">$ systemctl stop postgresql-13.service<\/pre>\n<p>2.We back up the second data directory.<\/p>\n<pre class=\"lang:default decode:true \">-bash-4.2$ mv \/var\/lib\/pgsql\/13\/data\/ \/var\/lib\/pgsql\/13\/data_old<\/pre>\n<p>3. We connect to the master server, take a backup and restore it.<\/p>\n<pre class=\"lang:default decode:true \">bash-4.2$ pg_basebackup -h 192.168.1.12 -U postgres -D \/var\/lib\/pgsql\/13\/data -U replication -v -P --wal-method=stream --write-recovery-conf<\/pre>\n<p>4. We create the standby.signal file.<\/p>\n<pre class=\"lang:default decode:true \">bash-4.2$ touch \/var\/lib\/pgsql\/13\/data\/standby.signal<\/pre>\n<p>5. We start the service.<\/p>\n<pre class=\"lang:default decode:true \">$ systemctl start postgresql-13.service<\/pre>\n<p>When we complete the above steps, we will have the standby database.<\/p>\n<p>If you want to test it, you can query a table on the master server on the standby server, or you can check the standby with the query below.<\/p>\n<pre class=\"lang:default decode:true \">select now(),pg_last_xact_replay_timestamp();<\/pre>\n<p>I hope it will be a useful document for you.<\/p>\n<p>&nbsp;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_37733\" class=\"pvc_stats all  \" data-element-id=\"37733\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>In today&#8217;s post, I will show you Creating A Hot Standby In PostgreSQL. PostgreSQL Community 13 Installation: https:\/\/dbtut.com\/index.php\/2022\/03\/13\/postgresql-community-13-installation-on-oracle-linux-7\/ To create Stanby, we need two servers with Postgresql Community 13 installed. If you have not installed, you can install from the link above. There are operations that need to be done on both the master and &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_37733\" class=\"pvc_stats all  \" data-element-id=\"37733\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":3068,"featured_media":37734,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[5],"tags":[],"class_list":["post-37733","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-postgres"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":730,"today_views":0},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Creating A Hot Standby In PostgreSQL - Database Tutorials<\/title>\n<meta name=\"description\" content=\"In today&#039;s post, I will show you Creating A Hot Standby In PostgreSQL.PostgreSQL Community 13 Installation:\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2022\/04\/06\/creating-a-hot-standby-in-postgresql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Creating A Hot Standby In PostgreSQL - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"In today&#039;s post, I will show you Creating A Hot Standby In PostgreSQL.PostgreSQL Community 13 Installation:\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2022\/04\/06\/creating-a-hot-standby-in-postgresql\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2022-04-06T11:18:15+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-04-06T11:18:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/04\/Ekran-Alintisi-4.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"848\" \/>\n\t<meta property=\"og:image:height\" content=\"381\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Melek Durdu\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Melek Durdu\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/04\/06\/creating-a-hot-standby-in-postgresql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/04\/06\/creating-a-hot-standby-in-postgresql\/\"},\"author\":{\"name\":\"Melek Durdu\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/f9c7aff3fe68fef0255caa38a944ce4b\"},\"headline\":\"Creating A Hot Standby In PostgreSQL\",\"datePublished\":\"2022-04-06T11:18:15+00:00\",\"dateModified\":\"2022-04-06T11:18:57+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/04\/06\/creating-a-hot-standby-in-postgresql\/\"},\"wordCount\":327,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/04\/06\/creating-a-hot-standby-in-postgresql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/04\/Ekran-Alintisi-4.jpg\",\"articleSection\":[\"PostgreSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2022\/04\/06\/creating-a-hot-standby-in-postgresql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/04\/06\/creating-a-hot-standby-in-postgresql\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2022\/04\/06\/creating-a-hot-standby-in-postgresql\/\",\"name\":\"Creating A Hot Standby In PostgreSQL - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/04\/06\/creating-a-hot-standby-in-postgresql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/04\/06\/creating-a-hot-standby-in-postgresql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/04\/Ekran-Alintisi-4.jpg\",\"datePublished\":\"2022-04-06T11:18:15+00:00\",\"dateModified\":\"2022-04-06T11:18:57+00:00\",\"description\":\"In today's post, I will show you Creating A Hot Standby In PostgreSQL.PostgreSQL Community 13 Installation:\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/04\/06\/creating-a-hot-standby-in-postgresql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2022\/04\/06\/creating-a-hot-standby-in-postgresql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/04\/06\/creating-a-hot-standby-in-postgresql\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/04\/Ekran-Alintisi-4.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/04\/Ekran-Alintisi-4.jpg\",\"width\":848,\"height\":381},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/04\/06\/creating-a-hot-standby-in-postgresql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Creating A Hot Standby In PostgreSQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/f9c7aff3fe68fef0255caa38a944ce4b\",\"name\":\"Melek Durdu\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/58ca612f54e80376df00d6a004a13776cc9d0e2fe204974ec63003d803c26896?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/58ca612f54e80376df00d6a004a13776cc9d0e2fe204974ec63003d803c26896?s=96&d=mm&r=g\",\"caption\":\"Melek Durdu\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/melekdurdu\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Creating A Hot Standby In PostgreSQL - Database Tutorials","description":"In today's post, I will show you Creating A Hot Standby In PostgreSQL.PostgreSQL Community 13 Installation:","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:\/\/dbtut.com\/index.php\/2022\/04\/06\/creating-a-hot-standby-in-postgresql\/","og_locale":"en_US","og_type":"article","og_title":"Creating A Hot Standby In PostgreSQL - Database Tutorials","og_description":"In today's post, I will show you Creating A Hot Standby In PostgreSQL.PostgreSQL Community 13 Installation:","og_url":"https:\/\/dbtut.com\/index.php\/2022\/04\/06\/creating-a-hot-standby-in-postgresql\/","og_site_name":"Database Tutorials","article_published_time":"2022-04-06T11:18:15+00:00","article_modified_time":"2022-04-06T11:18:57+00:00","og_image":[{"width":848,"height":381,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/04\/Ekran-Alintisi-4.jpg","type":"image\/jpeg"}],"author":"Melek Durdu","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Melek Durdu","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2022\/04\/06\/creating-a-hot-standby-in-postgresql\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/04\/06\/creating-a-hot-standby-in-postgresql\/"},"author":{"name":"Melek Durdu","@id":"https:\/\/dbtut.com\/#\/schema\/person\/f9c7aff3fe68fef0255caa38a944ce4b"},"headline":"Creating A Hot Standby In PostgreSQL","datePublished":"2022-04-06T11:18:15+00:00","dateModified":"2022-04-06T11:18:57+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/04\/06\/creating-a-hot-standby-in-postgresql\/"},"wordCount":327,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/04\/06\/creating-a-hot-standby-in-postgresql\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/04\/Ekran-Alintisi-4.jpg","articleSection":["PostgreSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2022\/04\/06\/creating-a-hot-standby-in-postgresql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2022\/04\/06\/creating-a-hot-standby-in-postgresql\/","url":"https:\/\/dbtut.com\/index.php\/2022\/04\/06\/creating-a-hot-standby-in-postgresql\/","name":"Creating A Hot Standby In PostgreSQL - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/04\/06\/creating-a-hot-standby-in-postgresql\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/04\/06\/creating-a-hot-standby-in-postgresql\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/04\/Ekran-Alintisi-4.jpg","datePublished":"2022-04-06T11:18:15+00:00","dateModified":"2022-04-06T11:18:57+00:00","description":"In today's post, I will show you Creating A Hot Standby In PostgreSQL.PostgreSQL Community 13 Installation:","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/04\/06\/creating-a-hot-standby-in-postgresql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2022\/04\/06\/creating-a-hot-standby-in-postgresql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2022\/04\/06\/creating-a-hot-standby-in-postgresql\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/04\/Ekran-Alintisi-4.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/04\/Ekran-Alintisi-4.jpg","width":848,"height":381},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2022\/04\/06\/creating-a-hot-standby-in-postgresql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Creating A Hot Standby In PostgreSQL"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/f9c7aff3fe68fef0255caa38a944ce4b","name":"Melek Durdu","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/58ca612f54e80376df00d6a004a13776cc9d0e2fe204974ec63003d803c26896?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/58ca612f54e80376df00d6a004a13776cc9d0e2fe204974ec63003d803c26896?s=96&d=mm&r=g","caption":"Melek Durdu"},"url":"https:\/\/dbtut.com\/index.php\/author\/melekdurdu\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/37733","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/3068"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=37733"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/37733\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/37734"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=37733"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=37733"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=37733"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}