{"id":14207,"date":"2020-05-29T12:07:07","date_gmt":"2020-05-29T10:07:07","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/pgbackrest-a-simple-privileges-related-issue\/"},"modified":"2020-05-29T12:07:07","modified_gmt":"2020-05-29T10:07:07","slug":"pgbackrest-a-simple-privileges-related-issue","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/pgbackrest-a-simple-privileges-related-issue\/","title":{"rendered":"pgBackRest – a simple privileges-related issue"},"content":{"rendered":"

I recently had to replace Barman by pgBackRest<\/a> as Backup & Recovery solution for one of my customer.
\nThe purpose of this blog is not to show how I made the setup (some dbi blogs<\/a> already exists for that), but only to share a small issue I encountered during the creation of the Stanza :
\n
\npostgres@pgbackrest:\/ [cms2] pgbackrest --stanza=cms2_primary stanza-create<\/span>
\nERROR: [058]: version '11' and path '(null)'<\/b> queried from cluster do not match version '11' and '\/services\/data\/pgdata\/cms2' read from '\/services\/data\/pgdata\/cms2\/global\/pg_control'
\nHINT: the pg1-path and pg1-port settings likely reference different clusters.
\npostgres@pgbackrest:\/ [cms2]
\n<\/code><\/p>\n

According to the error message it seems that the path to the data directory can not be retrieved.
\nI’m using a dedicated user to perform the backup operations (instead of the “postgres” user) :
\n
\npostgres@pgbackrest:\/ [cms2] cat \/etc\/pgbackrest.conf
\n[global]
\nrepo1-host=pgserver
\nrepo1-host-user=postgres
\nlog-level-file=detail
\n<\/br>
\n[cms2_primary]
\npg1-path=\/services\/data\/pgdata\/cms2
\npg1-socket-path=\/tmp
\npg1-user=backupuser<\/b>
\npostgres@pgbackrest:\/ [cms2]
\n<\/code><\/p>\n

The source of the problem is that backupuser is not allowed to read instance settings :
\n
\n(postgres@[local]:5432) [postgres] > c postgres backupuser
\nYou are now connected to database \"postgres\" as user \"backupuser\".
\n(backupuser@[local]:5432) [postgres] > select setting from pg_catalog.pg_settings where name = 'data_directory';<\/span>
\nsetting
\n---------
\n(0 rows)<\/b>
\n<\/code><\/p>\n

So, to solve this it’s required to grant the “pg_read_all_settings” role to the user :
\n
\n(postgres@[local]:5432) [postgres] > grant pg_read_all_settings to backupuser;<\/span>
\nGRANT ROLE
\n(postgres@[local]:5432) [postgres] > c postgres backupuser
\nYou are now connected to database \"postgres\" as user \"backupuser\".
\n(backupuser@[local]:5432) [postgres] > select setting from pg_catalog.pg_settings where name = 'data_directory';<\/span>
\nsetting
\n----------------------------
\n\/services\/data\/pgdata\/cms2<\/b>
\n(1 row)
\n<\/code><\/p>\n

Some other privileges are also required to allow the user to perform backup\/restore operations :
\n
\n(postgres@[local]:5432) [postgres] > grant execute on function pg_create_restore_point(text) to backupuser;
\nGRANT
\n(postgres@[local]:5432) [postgres] > grant execute on function pg_start_backup(text, boolean, boolean) to backupuser;
\nGRANT
\n(postgres@[local]:5432) [postgres] > grant execute on function pg_stop_backup(boolean, boolean) to backupuser;
\nGRANT
\n(postgres@[local]:5432) [postgres] > grant execute on function pg_create_restore_point(text) to backupuser;
\nGRANT
\n(postgres@[local]:5432) [postgres] > grant execute on function pg_switch_wal() to backupuser;
\nGRANT
\n(postgres@[local]:5432) [postgres] >
\n<\/code><\/p>\n

With the correct privilege the Stanza can now be created :
\n
\npostgres@pgbackrest:\/ [cms2] pgbackrest --stanza=cms2_primary stanza-create --log-level-console=detail<\/span>
\n2020-04-28 20:36:12.252 P00 INFO: stanza-create command begin 2.26: --log-level-console=detail --pg1-path=\/services\/data\/pgdata\/cms2 --pg1-socket-path=\/tmp --pg1-user=backupuser --repo1-path=\/var\/lib\/pgbackrest --stanza=cms2_primary
\n2020-04-28 20:36:12.785 P00 INFO: stanza-create command end: completed successfully (534ms)
\npostgres@pgbackrest:\/ [cms2]
\npostgres@pgbackrest:\/ [cms2] pgbackrest --stanza=cms2_primary check --log-level-console=detail<\/span>
\n2020-04-28 20:36:48.379 P00 INFO: check command begin 2.26: --log-level-console=detail --pg1-path=\/services\/data\/pgdata\/cms2 --pg1-socket-path=\/tmp --pg1-user=backupuser --repo1-path=\/var\/lib\/pgbackrest --stanza=cms2_primary
\n2020-04-28 20:36:49.887 P00 INFO: WAL segment 000000010000004E00000036 successfully archived to '\/var\/lib\/pgbackrest\/archive\/cms2_primary\/11-1\/000000010000004E\/000000010000004E00000036-5164039a67a3f865cfc6c188b9cd02d38c2a1c55.gz'
\n2020-04-28 20:36:49.887 P00 INFO: check command end: completed successfully (1509ms)
\npostgres@pgbackrest:\/ [cms2]
\n<\/code><\/p>\n

And then the first initial full backup can be done :
\n
\npostgres@pgbackrest:\/ [cms2] pgbackrest backup --type=full --stanza=cms2_primary --log-level-console=detail<\/span>
\n2020-04-28 23:21:50.546 P00 INFO: backup command begin 2.26: --pg1-host=pgserver --pg1-path=\/services\/data\/pgdata\/cms2 --pg1-port=5432 --pg1-socket-path=\/tmp --pg1-user=backupuser --repo1-path=\/services\/data\/pgdata --repo1-retention-full=2 --stanza=cms2_primary --start-fast --type=diff
\n2020-04-28 23:21:51.303 P00 WARN: no prior backup exists, diff backup has been changed to full
\n2020-04-28 23:21:51.303 P00 INFO: execute non-exclusive pg_start_backup(): backup begins after the requested immediate checkpoint completes
\n2020-04-28 23:21:52.012 P00 INFO: backup start archive = 000000010000004F00000007, lsn = 4F\/1C000028
\n2020-04-28 23:24:00.160 P01 INFO: backup file pgserver:\/services\/data\/pgdata\/cms2\/base\/23633\/58871.8 (2GB, 2%) checksum 7573c5848b1d2352666d3c3937c818e92654876e
\n2020-04-28 23:25:58.255 P01 INFO: backup file pgserver:\/services\/data\/pgdata\/cms2\/base\/23633\/58871.7 (2GB, 4%) checksum 09149d631f2b703b47e928c296aec70f21a74a00
\n2020-04-28 23:28:04.379 P01 INFO: backup file pgserver:\/services\/data\/pgdata\/cms2\/base\/23633\/58871.6 (2GB, 6%) checksum f4196a0f54037b18577b8f3f08e61b6b7f84deb1
\n2020-04-28 23:29:57.413 P01 INFO: backup file pgserver:\/services\/data\/pgdata\/cms2\/base\/23633\/58871.5 (2GB, 9%) checksum 9e334b2366f5bee850c782a62827e0fe1c83e1df
\n...
\n...
\n2020-04-29 00:54:48.900 P01 INFO: backup file pgserver:\/services\/data\/pgdata\/cms2\/base\/1\/13084 (0B, 100%)
\n2020-04-29 00:54:48.906 P01 INFO: backup file pgserver:\/services\/data\/pgdata\/cms2\/base\/1\/13079 (0B, 100%)
\n2020-04-29 00:54:48.910 P01 INFO: backup file pgserver:\/services\/data\/pgdata\/cms2\/base\/1\/13074 (0B, 100%)
\n2020-04-29 00:54:48.929 P00 INFO: full backup size = 88.1GB
\n2020-04-29 00:54:48.930 P00 INFO: execute non-exclusive pg_stop_backup() and wait for all WAL segments to archive
\n2020-04-29 00:54:49.232 P00 INFO: backup stop archive = 000000010000004F00000008, lsn = 4F\/20000050
\n2020-04-29 00:54:49.339 P00 INFO: check archive for segment(s) 000000010000004F00000007:000000010000004F00000008
\n2020-04-29 00:54:50.011 P00 INFO: new backup label = 20200428-232153F
\n2020-04-29 00:54:50.452 P00 INFO: backup command end: completed successfully (5579906ms)
\npostgres@pgbackrest:\/ [cms2]
\n<\/code><\/p>\n

Fairly easy… but not documented. So I hope this helps.<\/p>\n","protected":false},"excerpt":{"rendered":"

I recently had to replace Barman by pgBackRest as Backup & Recovery solution for one of my customer. The purpose of this blog is not to show how I made the setup (some dbi blogs already exists for that), but only to share a small issue I encountered during the creation of the Stanza :… <\/p>\n","protected":false},"author":30,"featured_media":14208,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","neve_meta_reading_time":"","_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[4133,83],"tags":[202,1293],"class_list":["post-14207","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database","category-postgresql","tag-backup","tag-pgbackrest"],"yoast_head":"\npgBackRest - a simple privileges-related issue - dbi services | Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/pgbackrest-a-simple-privileges-related-issue\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"pgBackRest - a simple privileges-related issue\" \/>\n<meta property=\"og:description\" content=\"I recently had to replace Barman by pgBackRest as Backup & Recovery solution for one of my customer. The purpose of this blog is not to show how I made the setup (some dbi blogs already exists for that), but only to share a small issue I encountered during the creation of the Stanza :… \" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/pgbackrest-a-simple-privileges-related-issue\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi services | Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dbiservices\/\" \/>\n<meta property=\"article:published_time\" content=\"2020-05-29T10:07:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/MX4rk2b2_400x400.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"256\" \/>\n\t<meta property=\"og:image:height\" content=\"256\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Jo\u00ebl Cattin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:site\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jo\u00ebl Cattin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/pgbackrest-a-simple-privileges-related-issue\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/pgbackrest-a-simple-privileges-related-issue\\\/\"},\"author\":{\"name\":\"Jo\u00ebl Cattin\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/caeaf637485f295f1be42de07b3ac4cf\"},\"headline\":\"pgBackRest – a simple privileges-related issue\",\"datePublished\":\"2020-05-29T10:07:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/pgbackrest-a-simple-privileges-related-issue\\\/\"},\"wordCount\":172,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/pgbackrest-a-simple-privileges-related-issue\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/MX4rk2b2_400x400.jpg\",\"keywords\":[\"Backup\",\"pgbackrest\"],\"articleSection\":[\"Database\",\"PostgreSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/pgbackrest-a-simple-privileges-related-issue\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/pgbackrest-a-simple-privileges-related-issue\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/pgbackrest-a-simple-privileges-related-issue\\\/\",\"name\":\"pgBackRest - a simple privileges-related issue - dbi services | Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/pgbackrest-a-simple-privileges-related-issue\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/pgbackrest-a-simple-privileges-related-issue\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/MX4rk2b2_400x400.jpg\",\"datePublished\":\"2020-05-29T10:07:07+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/pgbackrest-a-simple-privileges-related-issue\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/pgbackrest-a-simple-privileges-related-issue\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/pgbackrest-a-simple-privileges-related-issue\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/MX4rk2b2_400x400.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/MX4rk2b2_400x400.jpg\",\"width\":256,\"height\":256},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/pgbackrest-a-simple-privileges-related-issue\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"pgBackRest – a simple privileges-related issue\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi services Blog\",\"description\":\"#BeSharing\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\"},\"alternateName\":\"dbi Blog\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\",\"name\":\"dbi services\",\"alternateName\":\"dbi\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"width\":512,\"height\":512,\"caption\":\"dbi services\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dbiservices\\\/\",\"https:\\\/\\\/x.com\\\/dbiservices\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dbi-services\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/dbiservices\"],\"description\":\"Swiss IT consulting and services company specialised in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.\",\"email\":\"info@dbi-services.com\",\"telephone\":\"+41 32 422 96 00\",\"legalName\":\"dbi services SA\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/caeaf637485f295f1be42de07b3ac4cf\",\"name\":\"Jo\u00ebl Cattin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/JOC_web-scaled.jpg\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/JOC_web-scaled.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/JOC_web-scaled.jpg\",\"caption\":\"Jo\u00ebl Cattin\"},\"description\":\"Jo\u00ebl Cattin has more than seven years of experience in database management, specializing in Oracle solutions including Data Guard, RMAN, Oracle Database Appliance (ODA), Real Application Clusters (RAC), and APEX development, alongside PostgreSQL and MySQL. He is also experienced with AWS cloud solutions and Ansible-based IT automation. He holds Oracle Database 12c Administrator Certified Professional, EDB Postgres Advanced Server Certified Professional, RedHat Certified System Administrator, and ITIL V3 Foundation certifications, and leads three InSite Workshops (Oracle Basics, Linux for DBAs, and Ansible). He holds a degree from ESIG Del\u00e9mont.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/joel-cattin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"pgBackRest - a simple privileges-related issue - dbi services | Blog","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:\/\/www.dbi-services.com\/blog\/pgbackrest-a-simple-privileges-related-issue\/","og_locale":"en_US","og_type":"article","og_title":"pgBackRest - a simple privileges-related issue","og_description":"I recently had to replace Barman by pgBackRest as Backup & Recovery solution for one of my customer. The purpose of this blog is not to show how I made the setup (some dbi blogs already exists for that), but only to share a small issue I encountered during the creation of the Stanza :… ","og_url":"https:\/\/www.dbi-services.com\/blog\/pgbackrest-a-simple-privileges-related-issue\/","og_site_name":"dbi services | Blog","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","article_published_time":"2020-05-29T10:07:07+00:00","og_image":[{"width":256,"height":256,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/MX4rk2b2_400x400.jpg","type":"image\/jpeg"}],"author":"Jo\u00ebl Cattin","twitter_card":"summary_large_image","twitter_creator":"@dbiservices","twitter_site":"@dbiservices","twitter_misc":{"Written by":"Jo\u00ebl Cattin","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/pgbackrest-a-simple-privileges-related-issue\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/pgbackrest-a-simple-privileges-related-issue\/"},"author":{"name":"Jo\u00ebl Cattin","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/caeaf637485f295f1be42de07b3ac4cf"},"headline":"pgBackRest – a simple privileges-related issue","datePublished":"2020-05-29T10:07:07+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/pgbackrest-a-simple-privileges-related-issue\/"},"wordCount":172,"commentCount":0,"publisher":{"@id":"https:\/\/www.dbi-services.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/pgbackrest-a-simple-privileges-related-issue\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/MX4rk2b2_400x400.jpg","keywords":["Backup","pgbackrest"],"articleSection":["Database","PostgreSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/pgbackrest-a-simple-privileges-related-issue\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/pgbackrest-a-simple-privileges-related-issue\/","url":"https:\/\/www.dbi-services.com\/blog\/pgbackrest-a-simple-privileges-related-issue\/","name":"pgBackRest - a simple privileges-related issue - dbi services | Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/pgbackrest-a-simple-privileges-related-issue\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/pgbackrest-a-simple-privileges-related-issue\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/MX4rk2b2_400x400.jpg","datePublished":"2020-05-29T10:07:07+00:00","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/pgbackrest-a-simple-privileges-related-issue\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/pgbackrest-a-simple-privileges-related-issue\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/pgbackrest-a-simple-privileges-related-issue\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/MX4rk2b2_400x400.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/MX4rk2b2_400x400.jpg","width":256,"height":256},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/pgbackrest-a-simple-privileges-related-issue\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"pgBackRest – a simple privileges-related issue"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi services Blog","description":"#BeSharing","publisher":{"@id":"https:\/\/www.dbi-services.com\/blog\/#organization"},"alternateName":"dbi Blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.dbi-services.com\/blog\/#organization","name":"dbi services","alternateName":"dbi","url":"https:\/\/www.dbi-services.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","width":512,"height":512,"caption":"dbi services"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dbiservices\/","https:\/\/x.com\/dbiservices","https:\/\/www.linkedin.com\/company\/dbi-services\/","https:\/\/www.youtube.com\/user\/dbiservices"],"description":"Swiss IT consulting and services company specialised in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.","email":"info@dbi-services.com","telephone":"+41 32 422 96 00","legalName":"dbi services SA"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/caeaf637485f295f1be42de07b3ac4cf","name":"Jo\u00ebl Cattin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/JOC_web-scaled.jpg","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/JOC_web-scaled.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/JOC_web-scaled.jpg","caption":"Jo\u00ebl Cattin"},"description":"Jo\u00ebl Cattin has more than seven years of experience in database management, specializing in Oracle solutions including Data Guard, RMAN, Oracle Database Appliance (ODA), Real Application Clusters (RAC), and APEX development, alongside PostgreSQL and MySQL. He is also experienced with AWS cloud solutions and Ansible-based IT automation. He holds Oracle Database 12c Administrator Certified Professional, EDB Postgres Advanced Server Certified Professional, RedHat Certified System Administrator, and ITIL V3 Foundation certifications, and leads three InSite Workshops (Oracle Basics, Linux for DBAs, and Ansible). He holds a degree from ESIG Del\u00e9mont.","url":"https:\/\/www.dbi-services.com\/blog\/author\/joel-cattin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/14207","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/30"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=14207"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/14207\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/14208"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=14207"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=14207"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=14207"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}