{"id":3835,"date":"2023-03-29T12:49:01","date_gmt":"2023-03-29T12:49:01","guid":{"rendered":"https:\/\/test.opensource-db.in\/wp1\/?p=3835"},"modified":"2023-05-24T05:44:10","modified_gmt":"2023-05-24T05:44:10","slug":"setting-up-and-configuring-pgbackrest","status":"publish","type":"post","link":"https:\/\/test.opensource-db.in\/wp1\/setting-up-and-configuring-pgbackrest\/","title":{"rendered":"Setting up and Configuring pgBackRest"},"content":{"rendered":"\n<figure class=\"wp-block-image size-large\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"537\" src=\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/05\/image-4-1024x537.png\" alt=\"\" class=\"wp-image-4032\" srcset=\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/05\/image-4-1024x537.png 1024w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/05\/image-4-300x157.png 300w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/05\/image-4-768x403.png 768w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/05\/image-4-1536x806.png 1536w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/05\/image-4-189x99.png 189w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/05\/image-4-152x80.png 152w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/05\/image-4-394x207.png 394w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/05\/image-4-915x480.png 915w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/05\/image-4-1240x651.png 1240w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/05\/image-4.png 1801w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-black-color\">Introduction<\/mark><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Having a strong backup and recovery strategy is crucial for any organization that relies on Postgres as its database management system, and pgBackRest plays a vital role in ensuring the safety and integrity of data. With pgBackRest, organizations can establish a robust backup process that provides peace of mind and minimizes the risk of data loss. By implementing regular backups, organizations can recover from various incidents, such as hardware failures, software glitches, or human errors. Additionally, pgBackRest offers features like incremental backups, parallel compression, and backup integrity checks, enhancing the efficiency and reliability of the backup and recovery process. In the event of a disaster or data corruption, a well-planned backup and recovery strategy with pgBackRest allows organizations to quickly restore their Postgres databases, minimize downtime, and safeguard critical information. Investing in a strong backup and recovery strategy is an essential aspect of maintaining data continuity, meeting regulatory requirements, and ensuring business continuity in the face of unforeseen challenges.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">As discussed on the <a href=\"https:\/\/test.opensource-db.in\/wp1\/unveiling-the-mystery-of-postgres-backups-for-my-peeps\/\" target=\"_blank\" rel=\"noreferrer noopener\">Postgres Backup for Peeps blog<\/a>, here are the basic steps to install and configure <a href=\"https:\/\/pgbackrest.org\/\" target=\"_blank\" rel=\"noreferrer noopener\">pgBackRest<\/a> for backing up a production PostgreSQL server:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>PgBackRest Installation:<\/strong><br><code>[root@localhost ~]# yum install pgbackrest<br>[root@localhost ~]# pgbackrest version<br>pgBackRest 2.45<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Change Parameters on postgresql.conf<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&#91;postgres@localhost ~]$ cd \/var\/lib\/pgsql\/15\/data\/\n&#91;postgres@localhost data]$ vi postgresql.conf \nwal_level = replica\nmax_wal_senders = 10\nhot_standby = on\narchive_mode = on\narchive_command = 'pgbackrest --stanza=12_data archive_push %p'\n:wq!\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Restart PostgreSQL to enable the change to the parameters.<br><code>systemctl restart postgresql-12<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Change Parameters on pgbackrest.conf<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>bash-5.1$ vi \/etc\/pgbackrest.conf\n&#91;global]\nrepo1-path=\/var\/lib\/pgbackrest\nlog-level-console=info\nlog-level-file=debug\n&#91;main]\npg1-path=\/var\/lib\/pgsql\/15\/data\n&#91;postgres@localhost ~]$ pgbackrest stanza-create --stanza=main --log-level-console=info\nNFO: stanza-create command end: completed successfully (830ms)\n\n&#91;postgres@localhost ~]$ pgbackrest check --stanza=main --log-level-console=info<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><img decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/dIq8k-0VQU6h07gIGbZfBVKh8In3nFRhaOwNivhnsXySOTNsF0vKR39_vwxKLv7ZT5JyZQcFtkC5SQqiAH-R8B55BhMwr8aeWFy4XyXZSkJbkb6IZ_728HQe4QYBor267CqG1ih0lr9U4cIVejznYEQ\" width=\"601\" height=\"155\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><code>bash-5.1$<strong> pgbackrest backup --stanza=main --log-level-console=info<\/strong><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><img decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/BFqJ8_jQoZ2pNZDCCXA6yp934MAUXgiilpZIMXz2j4sm5qc4-RecjMYqQVhaFJ5KZoJeZ-FTf4uzl5IxOM2DBJGa8Vq7nvRuPi2rlIdGdpA1tSBU3wQNowEbpAaTqXgVFU2uuAFg2_ss9f7u6ckaB6I\" width=\"602\" height=\"306\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><code>bash-5.1$ <strong>pgbackrest info<\/strong><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/lh5.googleusercontent.com\/i-2IF15_jpu00HUd2o42KGkzU63lJMOL6EO8BZDrOQjvCK6fUasjGNWyERydlrAP0nEEdAU1zETsulXYqJGZB8Esjkls0RywKd5f25k_3BYTNrZ3tXyUSASEz_snKW5ZzjB3PYMhI3tC8IeB_HXroOc\" width=\"625\" height=\"270\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Perform incremental backup:<\/strong><br><code>bash-5.1$<strong>pgbackrest backup --stanza=main --type=incr --log-level-console=info<\/strong><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/xJIe0PLOhIYuM6m0Zf1sczFxvoHSbAQYZrsOuC_sRTf4rkXg3X-AHY7_5PLajrfVpU3fEDhHkYiMHKnO_6EgkZ0zyXhw4fOOtt7qmpogK3uip7BZpW9i3fEH4Rm3sPs8SXh1g1WNDsjHkT-m4MGLdZQ\" width=\"602\" height=\"331\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Perform&nbsp; differential backup:<\/strong><br><code>bash-5.1$ <strong>pgbackrest --stanza=main --type=diff backup<\/strong><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/aiItECVVpnmcPoTgw7rloGOIcVLBvYIx5AaTLmn5xRnxmkw5RQTKez-RuBa8XJus8Mx85kzs6qAvQQhqaObY9dc8sL-mbRPt3Wa8kVHRyGYqMbzP_kDqwneDDNEiHy4_rfVco2zTIV00XFfNPTn5HpM\" width=\"602\" height=\"311\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Perform Restoration using pgBackrest :<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Stop the server for restoration<br><code>[postgres@localhost ~]$ systemctl stop postgresql-15.service<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Restoring a Backup from a backup Repository<br><code>[postgres@localhost ~]$ pgbackrest restore --stanza=test --delta<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/lh5.googleusercontent.com\/9BfoULQsiEGggPLu1SrlCcCHixt-nNHLkcjelk_ZFeSObQHoMjNA7Hxz1D1yyHpNWe1L_-WSNs-XfwaHnes0rTEGcvxEjP8sTkenEw8n1qM5ekDyayVdwMdIDRrj3ezMe6OnA4fFu-zGB5MbZDl98Xk\" width=\"512\" height=\"80\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction Having a strong backup and recovery strategy is crucial for any organization that relies on Postgres as its database [&hellip;]<\/p>\n","protected":false},"author":9,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[23,42],"tags":[56,45,29,26,74],"class_list":["post-3835","post","type-post","status-publish","format-standard","hentry","category-postgresql-14","category-postgresql-15","tag-backup","tag-open-source-databases","tag-performance","tag-postgresql","tag-recovery"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Setting up and Configuring pgBackRest - OpenSource DB<\/title>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Setting up and Configuring pgBackRest - OpenSource DB\" \/>\n<meta property=\"og:description\" content=\"Introduction Having a strong backup and recovery strategy is crucial for any organization that relies on Postgres as its database [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/test.opensource-db.in\/wp1\/setting-up-and-configuring-pgbackrest\/\" \/>\n<meta property=\"og:site_name\" content=\"OpenSource DB\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/people\/OpenSource-DB\/100072970755470\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-03-29T12:49:01+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-05-24T05:44:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/05\/image-4-1024x537.png\" \/>\n<meta name=\"author\" content=\"Venkat Akhil\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@opensource_db\" \/>\n<meta name=\"twitter:site\" content=\"@opensource_db\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Venkat Akhil\" \/>\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:\/\/test.opensource-db.in\/wp1\/setting-up-and-configuring-pgbackrest\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/setting-up-and-configuring-pgbackrest\/\"},\"author\":{\"name\":\"Venkat Akhil\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/a37b142ecbf953189a4f9209b0b8d328\"},\"headline\":\"Setting up and Configuring pgBackRest\",\"datePublished\":\"2023-03-29T12:49:01+00:00\",\"dateModified\":\"2023-05-24T05:44:10+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/setting-up-and-configuring-pgbackrest\/\"},\"wordCount\":235,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#organization\"},\"image\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/setting-up-and-configuring-pgbackrest\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/05\/image-4-1024x537.png\",\"keywords\":[\"backup\",\"open-source databases\",\"performance\",\"postgresql\",\"recovery\"],\"articleSection\":[\"PostgreSQL 14\",\"PostgreSQL 15\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/test.opensource-db.in\/wp1\/setting-up-and-configuring-pgbackrest\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/setting-up-and-configuring-pgbackrest\/\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/setting-up-and-configuring-pgbackrest\/\",\"name\":\"Setting up and Configuring pgBackRest - OpenSource DB\",\"isPartOf\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/setting-up-and-configuring-pgbackrest\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/setting-up-and-configuring-pgbackrest\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/05\/image-4-1024x537.png\",\"datePublished\":\"2023-03-29T12:49:01+00:00\",\"dateModified\":\"2023-05-24T05:44:10+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/setting-up-and-configuring-pgbackrest\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/test.opensource-db.in\/wp1\/setting-up-and-configuring-pgbackrest\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/setting-up-and-configuring-pgbackrest\/#primaryimage\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/05\/image-4.png\",\"contentUrl\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/05\/image-4.png\",\"width\":1801,\"height\":945},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/setting-up-and-configuring-pgbackrest\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/test.opensource-db.in\/wp1\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Setting up and Configuring pgBackRest\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#website\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/\",\"name\":\"OpenSource DB\",\"description\":\"Your Trusted OpenSource Databases partner\",\"publisher\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/test.opensource-db.in\/wp1\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#organization\",\"name\":\"OPENSOURCE DB PRIVATE LIMITED\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/osdb-logo-tm-2.png\",\"contentUrl\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/osdb-logo-tm-2.png\",\"width\":368,\"height\":120,\"caption\":\"OPENSOURCE DB PRIVATE LIMITED\"},\"image\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/people\/OpenSource-DB\/100072970755470\/\",\"https:\/\/x.com\/opensource_db\",\"https:\/\/www.youtube.com\/channel\/UCmTI5h\",\"https:\/\/www.linkedin.com\/company\/opensource-db\",\"https:\/\/www.instagram.com\/opensource_db\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/a37b142ecbf953189a4f9209b0b8d328\",\"name\":\"Venkat Akhil\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/522c0947d21b2c2c89f10698fd9131f9db4110f65c8d02b53d9b4559c7650865?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/522c0947d21b2c2c89f10698fd9131f9db4110f65c8d02b53d9b4559c7650865?s=96&d=mm&r=g\",\"caption\":\"Venkat Akhil\"},\"url\":\"https:\/\/test.opensource-db.in\/wp1\/author\/sudheer-sopensource-db-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Setting up and Configuring pgBackRest - OpenSource DB","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_US","og_type":"article","og_title":"Setting up and Configuring pgBackRest - OpenSource DB","og_description":"Introduction Having a strong backup and recovery strategy is crucial for any organization that relies on Postgres as its database [&hellip;]","og_url":"https:\/\/test.opensource-db.in\/wp1\/setting-up-and-configuring-pgbackrest\/","og_site_name":"OpenSource DB","article_publisher":"https:\/\/www.facebook.com\/people\/OpenSource-DB\/100072970755470\/","article_published_time":"2023-03-29T12:49:01+00:00","article_modified_time":"2023-05-24T05:44:10+00:00","og_image":[{"url":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/05\/image-4-1024x537.png","type":"","width":"","height":""}],"author":"Venkat Akhil","twitter_card":"summary_large_image","twitter_creator":"@opensource_db","twitter_site":"@opensource_db","twitter_misc":{"Written by":"Venkat Akhil","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/test.opensource-db.in\/wp1\/setting-up-and-configuring-pgbackrest\/#article","isPartOf":{"@id":"https:\/\/test.opensource-db.in\/wp1\/setting-up-and-configuring-pgbackrest\/"},"author":{"name":"Venkat Akhil","@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/a37b142ecbf953189a4f9209b0b8d328"},"headline":"Setting up and Configuring pgBackRest","datePublished":"2023-03-29T12:49:01+00:00","dateModified":"2023-05-24T05:44:10+00:00","mainEntityOfPage":{"@id":"https:\/\/test.opensource-db.in\/wp1\/setting-up-and-configuring-pgbackrest\/"},"wordCount":235,"commentCount":0,"publisher":{"@id":"https:\/\/test.opensource-db.in\/wp1\/#organization"},"image":{"@id":"https:\/\/test.opensource-db.in\/wp1\/setting-up-and-configuring-pgbackrest\/#primaryimage"},"thumbnailUrl":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/05\/image-4-1024x537.png","keywords":["backup","open-source databases","performance","postgresql","recovery"],"articleSection":["PostgreSQL 14","PostgreSQL 15"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/test.opensource-db.in\/wp1\/setting-up-and-configuring-pgbackrest\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/test.opensource-db.in\/wp1\/setting-up-and-configuring-pgbackrest\/","url":"https:\/\/test.opensource-db.in\/wp1\/setting-up-and-configuring-pgbackrest\/","name":"Setting up and Configuring pgBackRest - OpenSource DB","isPartOf":{"@id":"https:\/\/test.opensource-db.in\/wp1\/#website"},"primaryImageOfPage":{"@id":"https:\/\/test.opensource-db.in\/wp1\/setting-up-and-configuring-pgbackrest\/#primaryimage"},"image":{"@id":"https:\/\/test.opensource-db.in\/wp1\/setting-up-and-configuring-pgbackrest\/#primaryimage"},"thumbnailUrl":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/05\/image-4-1024x537.png","datePublished":"2023-03-29T12:49:01+00:00","dateModified":"2023-05-24T05:44:10+00:00","breadcrumb":{"@id":"https:\/\/test.opensource-db.in\/wp1\/setting-up-and-configuring-pgbackrest\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/test.opensource-db.in\/wp1\/setting-up-and-configuring-pgbackrest\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/test.opensource-db.in\/wp1\/setting-up-and-configuring-pgbackrest\/#primaryimage","url":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/05\/image-4.png","contentUrl":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/05\/image-4.png","width":1801,"height":945},{"@type":"BreadcrumbList","@id":"https:\/\/test.opensource-db.in\/wp1\/setting-up-and-configuring-pgbackrest\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/test.opensource-db.in\/wp1\/"},{"@type":"ListItem","position":2,"name":"Setting up and Configuring pgBackRest"}]},{"@type":"WebSite","@id":"https:\/\/test.opensource-db.in\/wp1\/#website","url":"https:\/\/test.opensource-db.in\/wp1\/","name":"OpenSource DB","description":"Your Trusted OpenSource Databases partner","publisher":{"@id":"https:\/\/test.opensource-db.in\/wp1\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/test.opensource-db.in\/wp1\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/test.opensource-db.in\/wp1\/#organization","name":"OPENSOURCE DB PRIVATE LIMITED","url":"https:\/\/test.opensource-db.in\/wp1\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/logo\/image\/","url":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/osdb-logo-tm-2.png","contentUrl":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/osdb-logo-tm-2.png","width":368,"height":120,"caption":"OPENSOURCE DB PRIVATE LIMITED"},"image":{"@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/people\/OpenSource-DB\/100072970755470\/","https:\/\/x.com\/opensource_db","https:\/\/www.youtube.com\/channel\/UCmTI5h","https:\/\/www.linkedin.com\/company\/opensource-db","https:\/\/www.instagram.com\/opensource_db\/"]},{"@type":"Person","@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/a37b142ecbf953189a4f9209b0b8d328","name":"Venkat Akhil","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/522c0947d21b2c2c89f10698fd9131f9db4110f65c8d02b53d9b4559c7650865?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/522c0947d21b2c2c89f10698fd9131f9db4110f65c8d02b53d9b4559c7650865?s=96&d=mm&r=g","caption":"Venkat Akhil"},"url":"https:\/\/test.opensource-db.in\/wp1\/author\/sudheer-sopensource-db-com\/"}]}},"rttpg_featured_image_url":null,"rttpg_author":{"display_name":"Venkat Akhil","author_link":"https:\/\/test.opensource-db.in\/wp1\/author\/sudheer-sopensource-db-com\/"},"rttpg_comment":0,"rttpg_category":"<a href=\"https:\/\/test.opensource-db.in\/wp1\/category\/postgres\/postgresql-14\/\" rel=\"category tag\">PostgreSQL 14<\/a> <a href=\"https:\/\/test.opensource-db.in\/wp1\/category\/postgres\/postgresql-15\/\" rel=\"category tag\">PostgreSQL 15<\/a>","rttpg_excerpt":"Introduction Having a strong backup and recovery strategy is crucial for any organization that relies on Postgres as its database [&hellip;]","_links":{"self":[{"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/posts\/3835","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/comments?post=3835"}],"version-history":[{"count":15,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/posts\/3835\/revisions"}],"predecessor-version":[{"id":4033,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/posts\/3835\/revisions\/4033"}],"wp:attachment":[{"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/media?parent=3835"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/categories?post=3835"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/tags?post=3835"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}