{"id":5471,"date":"2015-09-08T04:40:33","date_gmt":"2015-09-08T02:40:33","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/if-we-stop-the-goldengate-replication-will-transactions-running-at-that-time-on-the-source-will-be-replicated-before-replication-stops\/"},"modified":"2015-09-08T04:40:33","modified_gmt":"2015-09-08T02:40:33","slug":"if-we-stop-the-goldengate-replication-will-transactions-running-at-that-time-on-the-source-will-be-replicated-before-replication-stops","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/if-we-stop-the-goldengate-replication-will-transactions-running-at-that-time-on-the-source-will-be-replicated-before-replication-stops\/","title":{"rendered":"If we stop the GoldenGate replication: Will transactions running at that time on the source will be replicated before replication stops?"},"content":{"rendered":"<p>This is the next post on this GoldenGate series:<\/p>\n<ul>\n<li><a href=\"http:\/\/dbi-services.com\/blog\/installing-and-patching-oracle-goldengate-12c-to-the-latest-release\/\" target=\"_blank\" rel=\"noopener\">Installing and patching Oracle GoldenGate 12c to the latest release<\/a><\/li>\n<li><a href=\"http:\/\/dbi-services.com\/blog\/setting-up-a-sample-replication-with-goldengate\/\" target=\"_blank\" rel=\"noopener\">Setting up a sample replication with GoldenGate<\/a><\/li>\n<li><a href=\"http:\/\/dbi-services.com\/blog\/performing-an-initial-load-with-goldengate-1-file-to-replicat\/\" target=\"_blank\" rel=\"noopener\">Performing an initial load with GoldenGate (1) \u2013 file to replicat<\/a><\/li>\n<li><a href=\"http:\/\/dbi-services.com\/blog\/performing-an-initial-load-with-goldengate-2-expdpimpdp\/\" target=\"_blank\" rel=\"noopener\">Performing an initial load with GoldenGate (2) \u2013 expdp\/impdp<\/a><\/li>\n<li><a href=\"http:\/\/dbi-services.com\/blog\/using-goldengate-event-actions-to-suspend-replication-for-end-of-day-reporting\/\" target=\"_blank\" rel=\"noopener\">Using GoldenGate event actions to suspend replication for end of day reporting<\/a><\/li>\n<\/ul>\n<p>One question that pops up when stopping the replication by using an <a href=\"https:\/\/docs.oracle.com\/goldengate\/1212\/gg-winux\/GWUAD\/wu_customcode.htm#GWUAD622\" target=\"_blank\" rel=\"noopener\">event marker<\/a> is: What happens to the transactions that are running when the event occurs? Can we be sure that all transactions that are running when the event occurs are replicated to the target once they are committed? Or does the replication stop immediately?<\/p>\n<p>For the test setup I created a new table in the HR schema and added it to the GoldenGate replication the same way as the event table in the <a href=\"http:\/\/dbi-services.com\/blog\/using-goldengate-event-actions-to-suspend-replication-for-end-of-day-reporting\/\" target=\"_blank\" rel=\"noopener\">last post<\/a>. The definition of the table is:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\nSQL&gt; desc hr.dummy_insert\n Name\t\t\t\t\t   Null?    Type\n ----------------------------------------- -------- ----------------------------\n A\t\t\t\t\t\t    NUMBER(38)\n B\t\t\t\t\t\t    VARCHAR2(50)\n C\t\t\t\t\t\t    DATE\n<\/pre>\n<p>The script to populate the test table is:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\ndeclare\n  ln_count pls_integer := 1000000;\nbegin\n  for i in 1..ln_count\n  loop\n    insert into hr.dummy_insert (a,b,c)\n           values ( i, lpad(i,50,'A'), sysdate );\n  end loop;\nend;\n\/\ncommit;\n<\/pre>\n<p>On my test environment this will run long enough to insert the event into the event table in a separate session while the inserts are running. So in the first session I&#8217;ll start the data load and in the second session immediately afterwards I&#8217;ll send the event to stop the replicat on the target.<\/p>\n<p>Session 1 (on the source):<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\nSQL&gt; @do_inserts.sql\n<\/pre>\n<p>Session 2 (on the source, 1 one or two seconds later);<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\nSQL&gt; insert into hr.events values ( 'SUSPEND REPLICATION', sysdate );\n\n1 row created.\n\nSQL&gt; commit;\n\nCommit complete.\n<\/pre>\n<p>What is the status of the replicat on the target?<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\nGGSCI (oelgg2.it.dbi-services.com as ggadmin@DB2) 68&gt; info all\n\nProgram     Status      Group       Lag at Chkpt  Time Since Chkpt\n\nMANAGER     RUNNING                                           \nREPLICAT    STOPPED     REPLCDD     00:00:05      00:01:15    \n<\/pre>\n<p>This is as expected. How many rows do we have in the target table?<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\nSQL&gt; select count(*) from hr.dummy_insert;\n\n  COUNT(*)\n----------\n\t 0\n\nSQL&gt; \n<\/pre>\n<p>Hm. Not good. This means when we stop the replicat on the target and there are ongoing transactions on the source they will not be written to the database. They are written to the trail files though (check the Goldengate log file):<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\n2015-09-07 13:36:35  INFO    OGG-01670  Oracle GoldenGate Collector for Oracle:  Closing .\/dirdat\/jj000127.\n2015-09-07 13:36:35  INFO    OGG-01669  Oracle GoldenGate Collector for Oracle:  Opening .\/dirdat\/jj000128 (byte -1, current EOF 0).\n2015-09-07 13:36:35  INFO    OGG-01735  Oracle GoldenGate Collector for Oracle:  Synchronizing .\/dirdat\/jj000128 to disk.\n2015-09-07 13:36:35  INFO    OGG-01971  Oracle GoldenGate Collector for Oracle:  The previous message, 'INFO OGG-01735', repeated 1 times.\n2015-09-07 13:36:35  INFO    OGG-01670  Oracle GoldenGate Collector for Oracle:  Closing .\/dirdat\/jj000128.\n2015-09-07 13:36:35  INFO    OGG-01669  Oracle GoldenGate Collector for Oracle:  Opening .\/dirdat\/jj000129 (byte -1, current EOF 0).\n<\/pre>\n<p>Once you restart the replicat the transaction will be replayed:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\nGGSCI (oelgg2.it.dbi-services.com as ggadmin@DB2) 78&gt; start replicat REPLCDD\n\nSending START request to MANAGER ...\nREPLICAT REPLCDD starting\n<\/pre>\n<p>After some time the rows will be there on the target:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\nSQL&gt; select count(*) from hr.dummy_insert;\n\n  COUNT(*)\n----------\n   1000000\n\nSQL&gt; \n<\/pre>\n<p>But this is not sufficient if the end of day reporting depends on all transactions that are started (but not completed) when the event to stop replication is send. Currently I do not have a solution for this. According to Oracle support the only solution to automatically achieve this is to use <a href=\"http:\/\/www.oracle.com\/us\/products\/middleware\/data-integration\/goldengate\/veridata\/overview\/index.html\" target=\"_blank\" rel=\"noopener\">GoldenGate Veridata<\/a> which must be separately licensed. If anybody had the same issue and solved it somehow I&#8217;d be happy to hear about it.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This is the next post on this GoldenGate series: Installing and patching Oracle GoldenGate 12c to the latest release Setting up a sample replication with GoldenGate Performing an initial load with GoldenGate (1) \u2013 file to replicat Performing an initial load with GoldenGate (2) \u2013 expdp\/impdp Using GoldenGate event actions to suspend replication for end&hellip;&nbsp;<\/p>\n","protected":false},"author":28,"featured_media":0,"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],"tags":[],"class_list":["post-5471","post","type-post","status-publish","format-standard","hentry","category-database"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.8 (Yoast SEO v28.8) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>If we stop the GoldenGate replication: Will transactions running at that time on the source will be replicated before replication stops? - 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\/if-we-stop-the-goldengate-replication-will-transactions-running-at-that-time-on-the-source-will-be-replicated-before-replication-stops\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"If we stop the GoldenGate replication: Will transactions running at that time on the source will be replicated before replication stops?\" \/>\n<meta property=\"og:description\" content=\"This is the next post on this GoldenGate series: Installing and patching Oracle GoldenGate 12c to the latest release Setting up a sample replication with GoldenGate Performing an initial load with GoldenGate (1) \u2013 file to replicat Performing an initial load with GoldenGate (2) \u2013 expdp\/impdp Using GoldenGate event actions to suspend replication for end&hellip;&nbsp;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/if-we-stop-the-goldengate-replication-will-transactions-running-at-that-time-on-the-source-will-be-replicated-before-replication-stops\/\" \/>\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=\"2015-09-08T02:40:33+00:00\" \/>\n<meta name=\"author\" content=\"Open source Team\" \/>\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=\"Open source Team\" \/>\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:\\\/\\\/www.dbi-services.com\\\/blog\\\/if-we-stop-the-goldengate-replication-will-transactions-running-at-that-time-on-the-source-will-be-replicated-before-replication-stops\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/if-we-stop-the-goldengate-replication-will-transactions-running-at-that-time-on-the-source-will-be-replicated-before-replication-stops\\\/\"},\"author\":{\"name\":\"Open source Team\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/0b4548362cac3eeff8b3eaf329e3530a\"},\"headline\":\"If we stop the GoldenGate replication: Will transactions running at that time on the source will be replicated before replication stops?\",\"datePublished\":\"2015-09-08T02:40:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/if-we-stop-the-goldengate-replication-will-transactions-running-at-that-time-on-the-source-will-be-replicated-before-replication-stops\\\/\"},\"wordCount\":410,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\"},\"articleSection\":[\"Database\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/if-we-stop-the-goldengate-replication-will-transactions-running-at-that-time-on-the-source-will-be-replicated-before-replication-stops\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/if-we-stop-the-goldengate-replication-will-transactions-running-at-that-time-on-the-source-will-be-replicated-before-replication-stops\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/if-we-stop-the-goldengate-replication-will-transactions-running-at-that-time-on-the-source-will-be-replicated-before-replication-stops\\\/\",\"name\":\"If we stop the GoldenGate replication: Will transactions running at that time on the source will be replicated before replication stops? - dbi services | Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"datePublished\":\"2015-09-08T02:40:33+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/if-we-stop-the-goldengate-replication-will-transactions-running-at-that-time-on-the-source-will-be-replicated-before-replication-stops\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/if-we-stop-the-goldengate-replication-will-transactions-running-at-that-time-on-the-source-will-be-replicated-before-replication-stops\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/if-we-stop-the-goldengate-replication-will-transactions-running-at-that-time-on-the-source-will-be-replicated-before-replication-stops\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"If we stop the GoldenGate replication: Will transactions running at that time on the source will be replicated before replication stops?\"}]},{\"@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\\\/0b4548362cac3eeff8b3eaf329e3530a\",\"name\":\"Open source Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/open-source-author.png\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/open-source-author.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/open-source-author.png\",\"caption\":\"Open source Team\"},\"description\":\"Posts published under the Open source Team account are collective contributions by the dbi services open infrastructure consultants. The practice covers open-source databases and platforms, PostgreSQL first of all, along with MySQL, MariaDB, and Linux, from architecture, replication, and high availability to performance tuning and operations under service level agreements, and contributes actively to the PostgreSQL community.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/open-source-team\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"If we stop the GoldenGate replication: Will transactions running at that time on the source will be replicated before replication stops? - 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\/if-we-stop-the-goldengate-replication-will-transactions-running-at-that-time-on-the-source-will-be-replicated-before-replication-stops\/","og_locale":"en_US","og_type":"article","og_title":"If we stop the GoldenGate replication: Will transactions running at that time on the source will be replicated before replication stops?","og_description":"This is the next post on this GoldenGate series: Installing and patching Oracle GoldenGate 12c to the latest release Setting up a sample replication with GoldenGate Performing an initial load with GoldenGate (1) \u2013 file to replicat Performing an initial load with GoldenGate (2) \u2013 expdp\/impdp Using GoldenGate event actions to suspend replication for end&hellip;&nbsp;","og_url":"https:\/\/www.dbi-services.com\/blog\/if-we-stop-the-goldengate-replication-will-transactions-running-at-that-time-on-the-source-will-be-replicated-before-replication-stops\/","og_site_name":"dbi services | Blog","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","article_published_time":"2015-09-08T02:40:33+00:00","author":"Open source Team","twitter_card":"summary_large_image","twitter_creator":"@dbiservices","twitter_site":"@dbiservices","twitter_misc":{"Written by":"Open source Team","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/if-we-stop-the-goldengate-replication-will-transactions-running-at-that-time-on-the-source-will-be-replicated-before-replication-stops\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/if-we-stop-the-goldengate-replication-will-transactions-running-at-that-time-on-the-source-will-be-replicated-before-replication-stops\/"},"author":{"name":"Open source Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0b4548362cac3eeff8b3eaf329e3530a"},"headline":"If we stop the GoldenGate replication: Will transactions running at that time on the source will be replicated before replication stops?","datePublished":"2015-09-08T02:40:33+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/if-we-stop-the-goldengate-replication-will-transactions-running-at-that-time-on-the-source-will-be-replicated-before-replication-stops\/"},"wordCount":410,"commentCount":0,"publisher":{"@id":"https:\/\/www.dbi-services.com\/blog\/#organization"},"articleSection":["Database"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/if-we-stop-the-goldengate-replication-will-transactions-running-at-that-time-on-the-source-will-be-replicated-before-replication-stops\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/if-we-stop-the-goldengate-replication-will-transactions-running-at-that-time-on-the-source-will-be-replicated-before-replication-stops\/","url":"https:\/\/www.dbi-services.com\/blog\/if-we-stop-the-goldengate-replication-will-transactions-running-at-that-time-on-the-source-will-be-replicated-before-replication-stops\/","name":"If we stop the GoldenGate replication: Will transactions running at that time on the source will be replicated before replication stops? - dbi services | Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2015-09-08T02:40:33+00:00","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/if-we-stop-the-goldengate-replication-will-transactions-running-at-that-time-on-the-source-will-be-replicated-before-replication-stops\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/if-we-stop-the-goldengate-replication-will-transactions-running-at-that-time-on-the-source-will-be-replicated-before-replication-stops\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/if-we-stop-the-goldengate-replication-will-transactions-running-at-that-time-on-the-source-will-be-replicated-before-replication-stops\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"If we stop the GoldenGate replication: Will transactions running at that time on the source will be replicated before replication stops?"}]},{"@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\/0b4548362cac3eeff8b3eaf329e3530a","name":"Open source Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/05\/open-source-author.png","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/05\/open-source-author.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/05\/open-source-author.png","caption":"Open source Team"},"description":"Posts published under the Open source Team account are collective contributions by the dbi services open infrastructure consultants. The practice covers open-source databases and platforms, PostgreSQL first of all, along with MySQL, MariaDB, and Linux, from architecture, replication, and high availability to performance tuning and operations under service level agreements, and contributes actively to the PostgreSQL community.","url":"https:\/\/www.dbi-services.com\/blog\/author\/open-source-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/5471","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\/28"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=5471"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/5471\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=5471"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=5471"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=5471"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}