{"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":{"_acf_changed":false,"footnotes":""},"categories":[229,198,83],"tags":[202,1293,570,77,1966,1967],"type_dbi":[],"class_list":["post-14207","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","category-database-management","category-postgresql","tag-backup","tag-pgbackrest","tag-postgres","tag-postgresql","tag-privilege","tag-stanza"],"acf":[],"yoast_head":"\npgBackRest - a simple privileges-related issue - dbi 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 Blog\" \/>\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\/sites\/2\/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: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\/2c774f00321ee734515f0c2f6a96b780\"},\"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,\"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\/sites\/2\/2022\/04\/MX4rk2b2_400x400.jpg\",\"keywords\":[\"Backup\",\"pgbackrest\",\"postgres\",\"PostgreSQL\",\"privilege\",\"stanza\"],\"articleSection\":[\"Database Administration & Monitoring\",\"Database management\",\"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 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\/sites\/2\/2022\/04\/MX4rk2b2_400x400.jpg\",\"datePublished\":\"2020-05-29T10:07:07+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/2c774f00321ee734515f0c2f6a96b780\"},\"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\/sites\/2\/2022\/04\/MX4rk2b2_400x400.jpg\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/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 Blog\",\"description\":\"\",\"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\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/2c774f00321ee734515f0c2f6a96b780\",\"name\":\"Jo\u00ebl Cattin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/a4271811924694263d4de5a469f8bd4a90b14d3d90e6ad819b9e2e5ac035a2dc?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a4271811924694263d4de5a469f8bd4a90b14d3d90e6ad819b9e2e5ac035a2dc?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a4271811924694263d4de5a469f8bd4a90b14d3d90e6ad819b9e2e5ac035a2dc?s=96&d=mm&r=g\",\"caption\":\"Jo\u00ebl Cattin\"},\"description\":\"Jo\u00ebl Cattin has more than three years of experience in databases management. He is specialized in Oracle solutions such as Data Guard and RMAN and has a good background knowledge of Oracle Database Appliance (ODA), Real Application Cluster (RAC) and applications development on APEX. Jo\u00ebl Cattin\u2019s experience includes other RDBMS, such as PostgreSQL and MySQL. He is Oracle Database 12c Administrator Certified Professional, EDB Postgres Advanced Server 9.5 Certified Professional, RedHat Certified System Administrator and ITILv3 Foundation for Service Management Certified. Jo\u00ebl Cattin holds a degree from the \u00c9cole Sup\u00e9rieure d\u2019Informatique de Gestion (ESIG) in Del\u00e9mont and a Federal Certificate of Proficiency in Computer Science (Certificat f\u00e9d\u00e9ral de Capacit\u00e9 \u2013 CFC).\",\"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 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 Blog","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\/sites\/2\/2022\/04\/MX4rk2b2_400x400.jpg","type":"image\/jpeg"}],"author":"Jo\u00ebl Cattin","twitter_card":"summary_large_image","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\/2c774f00321ee734515f0c2f6a96b780"},"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,"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\/sites\/2\/2022\/04\/MX4rk2b2_400x400.jpg","keywords":["Backup","pgbackrest","postgres","PostgreSQL","privilege","stanza"],"articleSection":["Database Administration & Monitoring","Database management","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 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\/sites\/2\/2022\/04\/MX4rk2b2_400x400.jpg","datePublished":"2020-05-29T10:07:07+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/2c774f00321ee734515f0c2f6a96b780"},"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\/sites\/2\/2022\/04\/MX4rk2b2_400x400.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/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 Blog","description":"","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":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/2c774f00321ee734515f0c2f6a96b780","name":"Jo\u00ebl Cattin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/a4271811924694263d4de5a469f8bd4a90b14d3d90e6ad819b9e2e5ac035a2dc?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/a4271811924694263d4de5a469f8bd4a90b14d3d90e6ad819b9e2e5ac035a2dc?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a4271811924694263d4de5a469f8bd4a90b14d3d90e6ad819b9e2e5ac035a2dc?s=96&d=mm&r=g","caption":"Jo\u00ebl Cattin"},"description":"Jo\u00ebl Cattin has more than three years of experience in databases management. He is specialized in Oracle solutions such as Data Guard and RMAN and has a good background knowledge of Oracle Database Appliance (ODA), Real Application Cluster (RAC) and applications development on APEX. Jo\u00ebl Cattin\u2019s experience includes other RDBMS, such as PostgreSQL and MySQL. He is Oracle Database 12c Administrator Certified Professional, EDB Postgres Advanced Server 9.5 Certified Professional, RedHat Certified System Administrator and ITILv3 Foundation for Service Management Certified. Jo\u00ebl Cattin holds a degree from the \u00c9cole Sup\u00e9rieure d\u2019Informatique de Gestion (ESIG) in Del\u00e9mont and a Federal Certificate of Proficiency in Computer Science (Certificat f\u00e9d\u00e9ral de Capacit\u00e9 \u2013 CFC).","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"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=14207"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}