{"id":14838,"date":"2020-01-27T11:02:25","date_gmt":"2020-01-27T11:02:25","guid":{"rendered":"https:\/\/dbtut.com\/?p=14838"},"modified":"2020-01-30T06:26:50","modified_gmt":"2020-01-30T06:26:50","slug":"streaming-backup-with-postgresql-barman","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/streaming-backup-with-postgresql-barman\/","title":{"rendered":"Streaming Backup with PostgreSQL Barman"},"content":{"rendered":"<h2>What is Barman?<\/h2>\n<p>Barman is an open source backup \/ restore management tool in PostgreSQL.<\/p>\n<h3>What can you do with Barman?<\/h3>\n<ul>\n<li>You can create backups on the same server.<\/li>\n<li>You can create a backup to a different backup server.<\/li>\n<li>You can create multiple PostgreSQL cluster backups.<\/li>\n<li>You can back up multiple PostgreSQL Clusters running in different major versions of PostgreSQL. So you can collect your backups on a central backup server.<\/li>\n<li>With Barman, you can create backups in 2 different ways:<br \/>\n-rsync \/ ssh<br \/>\n-streaming<\/li>\n<\/ul>\n<p>In this article, we will create a backup to the \/ pg_backup directory on the PostgreSQL server.<\/p>\n<h2>Barman Installation<\/h2>\n<h4>For Debian and Derivatives:<\/h4>\n<pre class=\"lang:default decode:true \">sudo apt update\nsudo apt install barman<\/pre>\n<h4>For Redhat and Derivatives:<\/h4>\n<pre class=\"lang:default decode:true \">sudo yum update \nsudo yum install barman<\/pre>\n<h2>Configure PostgreSQL For Barman<\/h2>\n<p>In PostgreSQL, create the barman user with the superuser right for backup operations and the streaming_barman user with the replication right for streaming operations.<\/p>\n<pre class=\"lang:default decode:true \">createuser --superuser barman\ncreateuser --replication streaming_barman<\/pre>\n<p>Or by connecting with psql, we can create it as follows:<\/p>\n<pre class=\"lang:default decode:true \">CREATE USER barman SUPERUSER;\nCREATE USER streaming_barman REPLICATION;<\/pre>\n<p>We edit the pg_hba.conf file so that the user can connect to the database.<\/p>\n<pre class=\"lang:default decode:true \">vim \/var\/lib\/pgsql\/12\/data\/pg_hba.conf\n&gt;&gt;\nlocal   all             barman                       trust \nlocal   replication     streaming_barman             trust<\/pre>\n<p>PostgreSQL service requires reload operation for a change in the pg_hba.conf file to take effect. By connecting with psql, we can do it with the following command.<\/p>\n<pre class=\"lang:default decode:true \">SELECT pg_reload_conf();<\/pre>\n<p id=\"LkDJcUf\"><img loading=\"lazy\" decoding=\"async\" width=\"780\" height=\"427\" class=\"size-full wp-image-14839  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/img_5e2ea0a7d6718.png\" alt=\"\" \/><\/p>\n<p>We can check the access of the barman user we created with the command below.<\/p>\n<pre class=\"lang:default decode:true \">su - barman \npsql -c 'SELECT version()' -U barman -d postgres<\/pre>\n<p id=\"TClFzBN\"><img loading=\"lazy\" decoding=\"async\" width=\"836\" height=\"156\" class=\"size-full wp-image-14840  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/img_5e2ea0efa23e3.png\" alt=\"\" \/><\/p>\n<p>We can check the access of the streaming_barman user as follows.<\/p>\n<pre class=\"lang:default decode:true \">su - barman \npsql -U streaming_barman -c \"IDENTIFY_SYSTEM\" replication=1<\/pre>\n<p id=\"UtBFKfC\"><img loading=\"lazy\" decoding=\"async\" width=\"705\" height=\"154\" class=\"size-full wp-image-14841  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/img_5e2ea148a9f2d.png\" alt=\"\" \/><\/p>\n<h2>Configure Barman<\/h2>\n<p><strong>Barman has 2 types of configuration files:<\/strong><\/p>\n<ul>\n<li><strong class=\"gi ij\">barman.conf<\/strong><\/li>\n<li><strong class=\"gi ij\">barman.d<\/strong><\/li>\n<\/ul>\n<p><strong class=\"gi ij\">\/etc\/barman.conf\u00a0<\/strong>-&gt; It is a global configuration file. It contains general backup configurations such as log file, backup user, backup directory.<\/p>\n<p><strong>Edit the barman.conf file as follows:<\/strong><\/p>\n<pre class=\"lang:default decode:true \">vim \/etc\/barman.conf\n&gt;&gt;\n[barman]\nactive = true\nbarman_user = barman\nbarman_home = Backup_Dizini\nlog_file = Backup_Log_Dosyas\u0131\nlog_level = INFO\ncompression = gzip\nretention_policy = REDUNDANCY 3\nimmediate_checkpoint = true\nlast_backup_maximum_age = 4 DAYS\nminimum_redundancy = 1<\/pre>\n<p><strong class=\"gi ij\">\/etc\/barman.d<\/strong>\u00a0-&gt;Server configuration files are located under \/etc\/barman.d directory by default. Template configuration files are available under this directory for the backup methods(streaming and rsync).<\/p>\n<p>You can create a configuration file for each PostgreSQL cluster you want to backup with Barman using these template files.<\/p>\n<p>First of all, copy the streaming-server.conf-template file from the template files with the name of the cluster data directory and edit the file.<\/p>\n<p><strong>We create slots with the command of Barman:<\/strong><\/p>\n<pre class=\"lang:default decode:true \">su - barman\nbarman receive-wal --create-slot 12_data<\/pre>\n<p id=\"iPLiYTy\"><img loading=\"lazy\" decoding=\"async\" width=\"582\" height=\"74\" class=\"size-full wp-image-14842  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/img_5e2ea308a28a3.png\" alt=\"\" \/><\/p>\n<p><strong>To check the streaming settings of WAL files;<\/strong><\/p>\n<pre class=\"lang:default decode:true \">su - barman\nbarman switch-wal --force --archive 12_data<\/pre>\n<p id=\"gVBXtQw\"><img loading=\"lazy\" decoding=\"async\" width=\"730\" height=\"108\" class=\"size-full wp-image-14843  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/img_5e2ea3399f51e.png\" alt=\"\" \/><\/p>\n<h4>Check Barman Configuration<\/h4>\n<p>You can check the Barman configuration as follows.<\/p>\n<pre class=\"lang:default decode:true \">barman check 12_data<\/pre>\n<p id=\"RFLjmgc\"><img loading=\"lazy\" decoding=\"async\" width=\"829\" height=\"373\" class=\"size-full wp-image-14844  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/img_5e2ea3960c42b.png\" alt=\"\" \/><\/p>\n<h3>Barman Create Backup<\/h3>\n<p>You can create the first backup with the following command.<\/p>\n<pre class=\"lang:default decode:true \">barman backup 12_data --wait<\/pre>\n<p id=\"LNLWklC\"><img loading=\"lazy\" decoding=\"async\" width=\"878\" height=\"276\" class=\"size-full wp-image-14845  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/img_5e2ea4030e784.png\" alt=\"\" \/><\/p>\n<p>You can check the general status of the server as follows.<\/p>\n<pre class=\"lang:default decode:true \">barman status 12_data<\/pre>\n<p id=\"dXiCiEF\"><img loading=\"lazy\" decoding=\"async\" width=\"765\" height=\"308\" class=\"size-full wp-image-14846  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/img_5e2ea42ecf372.png\" alt=\"\" \/><\/p>\n<h2>Barman Restore<\/h2>\n<h3>Restore PostgreSQL Cluster With Barman<\/h3>\n<p>You can recover the backup to a directory on the server accessible by the barman user as follows.<\/p>\n<pre class=\"lang:default decode:true \">barman recover &lt;Server_Name&gt; &lt;Backup_ID&gt; &lt;Recovery_Directory&gt;<\/pre>\n<p id=\"DCHjRMf\"><img loading=\"lazy\" decoding=\"async\" width=\"727\" height=\"293\" class=\"size-full wp-image-14847  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/img_5e2ea53432039.png\" alt=\"\" \/><\/p>\n<h3>Barman Point in Time Recovery<\/h3>\n<p>For Point in Time Restore, we can specify the time with the target-time parameter.<\/p>\n<pre class=\"lang:default decode:true \">barman recover 12_data 20200113T230114 \/db\/pg_data\/12\/data --target-time \"Mon Jan 13 23:20:29 +03 2020\"<\/pre>\n<p id=\"MTTXPse\"><img loading=\"lazy\" decoding=\"async\" width=\"923\" height=\"271\" class=\"size-full wp-image-14848  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/img_5e2ea5d449e61.png\" alt=\"\" \/><\/p>\n<p>In this article I mentioned backup with basic level configurations. For more detailed information, you can use the barman&#8217;s web page, https:\/\/www.pgbarman.org\/.<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_14838\" class=\"pvc_stats all  \" data-element-id=\"14838\" 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>What is Barman? Barman is an open source backup \/ restore management tool in PostgreSQL. What can you do with Barman? You can create backups on the same server. You can create a backup to a different backup server. You can create multiple PostgreSQL cluster backups. You can back up multiple PostgreSQL Clusters running in &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_14838\" class=\"pvc_stats all  \" data-element-id=\"14838\" 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":477,"featured_media":14850,"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":[8036,8041,8045,8027,8048,8061,8038,8031,8037,8029,8028,8030,8059,8053,8054,8055,8056,8026,3868,8062,8047,8052,8050,8049,8051,8034,8032,8033,8042,8046,8021,8020,8022,8044,8058,8043,8023,8057,8025,8040,8035,8060,8039,8019,8017,8018,8024],"class_list":["post-14838","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-postgres","tag-backup-database-barman","tag-backup-postgresql-databases-with-barman","tag-barman-backup-methods","tag-barman-backup-tutorial","tag-barman-configuration-files","tag-barman-create-backup","tag-barman-documentation","tag-barman-install-linux","tag-barman-install-ubuntu","tag-barman-installation","tag-barman-installation-and-configuration","tag-barman-installation-steps","tag-barman-point-in-time-recovery","tag-barman-restore","tag-barman-restore-backup","tag-barman-restore-database","tag-barman-restore_command","tag-barman-tutorial","tag-can-we-restore-database-from-mdf-file","tag-check-barman-configuration","tag-configure-barman","tag-create-backup-barman","tag-create-backups-barman","tag-create-backups-with-barman","tag-create-barman-backup","tag-how-to-create-backups-with-barman","tag-how-to-install-barman","tag-how-to-install-postgresql-barman","tag-implementing-postgresql-with-barman","tag-install-and-configure-barman","tag-install-barman","tag-install-barman-centos-7","tag-install-barman-postgresql","tag-installing-and-configuring-barman","tag-postgres-barman-restore","tag-postgresql-backup-and-recovery-with-barman","tag-postgresql-barman-install","tag-postgresql-barman-restore","tag-postgresql-barman-tutorial","tag-postgresql-configuration-for-barman","tag-restore-database-barman","tag-restore-postgresql-cluster-with-barman","tag-using-barman-to-backup-postgresql","tag-what-is-barman-postgresql","tag-what-is-barman","tag-what-is-postgresql-barman","tag-yum-install-barman"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Streaming Backup with PostgreSQL Barman - Database Tutorials<\/title>\n<meta name=\"description\" content=\"Streaming Backup with PostgreSQL Barman\" \/>\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\/2020\/01\/27\/streaming-backup-with-postgresql-barman\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Streaming Backup with PostgreSQL Barman - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"Streaming Backup with PostgreSQL Barman\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/streaming-backup-with-postgresql-barman\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2020-01-27T11:02:25+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-01-30T06:26:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-16.png\" \/>\n\t<meta property=\"og:image:width\" content=\"479\" \/>\n\t<meta property=\"og:image:height\" content=\"280\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Zekiye AYDEM\u0130R\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Zekiye AYDEM\u0130R\" \/>\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:\/\/dbtut.com\/index.php\/2020\/01\/27\/streaming-backup-with-postgresql-barman\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/streaming-backup-with-postgresql-barman\/\"},\"author\":{\"name\":\"Zekiye AYDEM\u0130R\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/44676b832bdd5cfa774e985b6d85cd3b\"},\"headline\":\"Streaming Backup with PostgreSQL Barman\",\"datePublished\":\"2020-01-27T11:02:25+00:00\",\"dateModified\":\"2020-01-30T06:26:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/streaming-backup-with-postgresql-barman\/\"},\"wordCount\":465,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/streaming-backup-with-postgresql-barman\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-16.png\",\"keywords\":[\"backup database barman\",\"Backup PostgreSQL databases with Barman\",\"barman backup methods\",\"barman backup tutorial\",\"barman configuration files\",\"Barman Create Backup\",\"barman documentation\",\"barman install linux\",\"barman install ubuntu\",\"barman installation\",\"barman installation and configuration\",\"barman installation steps\",\"barman point in time recovery\",\"barman restore\",\"barman restore backup\",\"barman restore database\",\"barman restore_command\",\"barman tutorial\",\"Can we restore database from MDF file?\",\"Check Barman Configuration\",\"configure barman\",\"create backup barman\",\"Create Backups barman\",\"Create Backups With Barman\",\"create barman backup\",\"how to create backups with barman\",\"how to install barman\",\"how to install postgresql barman\",\"Implementing PostgreSQL with Barman\",\"install and configure barman\",\"install barman\",\"install barman centos 7\",\"install barman postgresql\",\"Installing and configuring Barman\",\"postgres barman restore\",\"Postgresql backup and recovery with Barman\",\"postgresql barman install\",\"postgresql barman restore\",\"postgresql barman tutorial\",\"postgresql configuration for barman\",\"restore database barman\",\"Restore PostgreSQL Cluster With Barman\",\"Using Barman to Backup PostgreSQL\",\"What is Barman PostgreSQL\",\"What is Barman?\",\"What is PostgreSQL Barman?\",\"yum install barman\"],\"articleSection\":[\"PostgreSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/streaming-backup-with-postgresql-barman\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/streaming-backup-with-postgresql-barman\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/streaming-backup-with-postgresql-barman\/\",\"name\":\"Streaming Backup with PostgreSQL Barman - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/streaming-backup-with-postgresql-barman\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/streaming-backup-with-postgresql-barman\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-16.png\",\"datePublished\":\"2020-01-27T11:02:25+00:00\",\"dateModified\":\"2020-01-30T06:26:50+00:00\",\"description\":\"Streaming Backup with PostgreSQL Barman\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/streaming-backup-with-postgresql-barman\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/streaming-backup-with-postgresql-barman\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/streaming-backup-with-postgresql-barman\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-16.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-16.png\",\"width\":479,\"height\":280},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/streaming-backup-with-postgresql-barman\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Streaming Backup with PostgreSQL Barman\"}]},{\"@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\/44676b832bdd5cfa774e985b6d85cd3b\",\"name\":\"Zekiye AYDEM\u0130R\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/eac70389d03a5a61b22bd277efdc0bae561e8ee31279a0c187c57f9b16e15620?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/eac70389d03a5a61b22bd277efdc0bae561e8ee31279a0c187c57f9b16e15620?s=96&d=mm&r=g\",\"caption\":\"Zekiye AYDEM\u0130R\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/zekiyeaydemir\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Streaming Backup with PostgreSQL Barman - Database Tutorials","description":"Streaming Backup with PostgreSQL Barman","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\/2020\/01\/27\/streaming-backup-with-postgresql-barman\/","og_locale":"en_US","og_type":"article","og_title":"Streaming Backup with PostgreSQL Barman - Database Tutorials","og_description":"Streaming Backup with PostgreSQL Barman","og_url":"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/streaming-backup-with-postgresql-barman\/","og_site_name":"Database Tutorials","article_published_time":"2020-01-27T11:02:25+00:00","article_modified_time":"2020-01-30T06:26:50+00:00","og_image":[{"width":479,"height":280,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-16.png","type":"image\/png"}],"author":"Zekiye AYDEM\u0130R","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Zekiye AYDEM\u0130R","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/streaming-backup-with-postgresql-barman\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/streaming-backup-with-postgresql-barman\/"},"author":{"name":"Zekiye AYDEM\u0130R","@id":"https:\/\/dbtut.com\/#\/schema\/person\/44676b832bdd5cfa774e985b6d85cd3b"},"headline":"Streaming Backup with PostgreSQL Barman","datePublished":"2020-01-27T11:02:25+00:00","dateModified":"2020-01-30T06:26:50+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/streaming-backup-with-postgresql-barman\/"},"wordCount":465,"commentCount":2,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/streaming-backup-with-postgresql-barman\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-16.png","keywords":["backup database barman","Backup PostgreSQL databases with Barman","barman backup methods","barman backup tutorial","barman configuration files","Barman Create Backup","barman documentation","barman install linux","barman install ubuntu","barman installation","barman installation and configuration","barman installation steps","barman point in time recovery","barman restore","barman restore backup","barman restore database","barman restore_command","barman tutorial","Can we restore database from MDF file?","Check Barman Configuration","configure barman","create backup barman","Create Backups barman","Create Backups With Barman","create barman backup","how to create backups with barman","how to install barman","how to install postgresql barman","Implementing PostgreSQL with Barman","install and configure barman","install barman","install barman centos 7","install barman postgresql","Installing and configuring Barman","postgres barman restore","Postgresql backup and recovery with Barman","postgresql barman install","postgresql barman restore","postgresql barman tutorial","postgresql configuration for barman","restore database barman","Restore PostgreSQL Cluster With Barman","Using Barman to Backup PostgreSQL","What is Barman PostgreSQL","What is Barman?","What is PostgreSQL Barman?","yum install barman"],"articleSection":["PostgreSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2020\/01\/27\/streaming-backup-with-postgresql-barman\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/streaming-backup-with-postgresql-barman\/","url":"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/streaming-backup-with-postgresql-barman\/","name":"Streaming Backup with PostgreSQL Barman - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/streaming-backup-with-postgresql-barman\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/streaming-backup-with-postgresql-barman\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-16.png","datePublished":"2020-01-27T11:02:25+00:00","dateModified":"2020-01-30T06:26:50+00:00","description":"Streaming Backup with PostgreSQL Barman","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/streaming-backup-with-postgresql-barman\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2020\/01\/27\/streaming-backup-with-postgresql-barman\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/streaming-backup-with-postgresql-barman\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-16.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-16.png","width":479,"height":280},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/27\/streaming-backup-with-postgresql-barman\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Streaming Backup with PostgreSQL Barman"}]},{"@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\/44676b832bdd5cfa774e985b6d85cd3b","name":"Zekiye AYDEM\u0130R","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/eac70389d03a5a61b22bd277efdc0bae561e8ee31279a0c187c57f9b16e15620?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/eac70389d03a5a61b22bd277efdc0bae561e8ee31279a0c187c57f9b16e15620?s=96&d=mm&r=g","caption":"Zekiye AYDEM\u0130R"},"url":"https:\/\/dbtut.com\/index.php\/author\/zekiyeaydemir\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/14838","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\/477"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=14838"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/14838\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/14850"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=14838"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=14838"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=14838"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}