{"id":306,"date":"2016-02-08T11:11:50","date_gmt":"2016-02-08T11:11:50","guid":{"rendered":"https:\/\/the7.io\/marketing-agency\/?page_id=306"},"modified":"2016-02-08T11:11:50","modified_gmt":"2016-02-08T11:11:50","slug":"blog","status":"publish","type":"page","link":"https:\/\/divaind.com\/ie1\/blog\/","title":{"rendered":"Blog"},"content":{"rendered":"<div class=\"wpb-content-wrapper\">[vc_row][vc_column]<style type=\"text\/css\" data-type=\"the7_shortcodes-inline-css\">.blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1.content-bg-on.classic-layout-list article {\n  background: #f4f4f4;\n  box-shadow: none;\n}\n.blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1.dividers-on.classic-layout-list article {\n  margin-top: 50px;\n  padding-top: 0;\n}\n.blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1.dividers-on.classic-layout-list article:first-of-type {\n  margin-top: 0;\n  padding-top: 0;\n}\n.blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1.classic-layout-list.mode-list .post-thumbnail-wrap {\n  width: 30%;\n}\n.blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1.classic-layout-list.mode-list .post-entry-content {\n  width: calc(100% - 30%);\n}\n.blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1.classic-layout-list.mode-list .no-img .post-entry-content {\n  width: 100%;\n}\n.blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1 .filter-bg-decoration .filter-categories a.act {\n  color: #fff;\n}\n.blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1:not(.mode-masonry) article {\n  margin-top: 50px;\n}\n.blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1:not(.mode-masonry) article:first-of-type,\n.blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1:not(.mode-masonry) article.visible.first:not(.product) {\n  margin-top: 0;\n}\n.blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1.dividers-on:not(.mode-masonry) article {\n  margin-top: 0;\n  padding-top: 50px;\n}\n.blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1.dividers-on:not(.mode-masonry) article:first-of-type,\n.blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1.dividers-on:not(.mode-masonry) article.visible.first:not(.product) {\n  margin-top: 0;\n  padding-top: 0;\n}\n.blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1 .post-thumbnail-wrap {\n  padding: 0px 0px 0px 0px;\n}\n.blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1.enable-bg-rollover .post-thumbnail-rollover:after {\n  background: rgba(255,255,255,0.15);\n  box-shadow: none;\n  background: -webkit-linear-gradient();\n  background: linear-gradient();\n}\n.blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1 .gallery-zoom-ico {\n  width: 44px;\n  height: 44px;\n  line-height: 44px;\n  border-radius: 100px;\n  margin: -22px 0 0 -22px;\n  border-width: 0px;\n  color: #ffffff;\n}\n.bottom-overlap-layout-list.blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1 .gallery-zoom-ico {\n  margin-top: -22px;\n}\n.gradient-overlay-layout-list.blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1 .gallery-zoom-ico,\n.content-rollover-layout-list.blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1 .gallery-zoom-ico {\n  margin: 0 0 10px;\n}\n.content-align-center.gradient-overlay-layout-list.blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1 .gallery-zoom-ico,\n.content-align-center.content-rollover-layout-list.blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1 .gallery-zoom-ico {\n  margin: 0 auto 10px;\n}\n.dt-icon-bg-on.blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1 .gallery-zoom-ico {\n  background: rgba(255,255,255,0.3);\n  box-shadow: none;\n}\n.blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1 .gallery-zoom-ico > span,\n.blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1 .gallery-zoom-ico:before {\n  font-size: 32px;\n  line-height: 44px;\n}\n.blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1 .gallery-zoom-ico > span,\n.blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1 .gallery-zoom-ico:before {\n  color: #ffffff;\n}\n.blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1 .fancy-date a {\n  background: #ec7834;\n  box-shadow: none;\n}\n.blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1 .fancy-date a * {\n  color: #ffffff;\n}\n.blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1 .fancy-date a .entry-month:after,\n.blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1 .fancy-date a .entry-date:after {\n  background: rgba(255,255,255,0.5);\n  box-shadow: none;\n}\n.blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1 .entry-title,\n.blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1.owl-carousel .entry-title {\n  margin-bottom: 5px;\n  font-weight: bold;\n}\n.blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1 .entry-meta {\n  margin-bottom: 15px;\n}\n.blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1 .portfolio-categories {\n  margin-bottom: 15px;\n}\n.blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1 .entry-excerpt {\n  margin-bottom: 5px;\n}\n.blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1:not(.centered-layout-list) .post-entry-content {\n  padding: 25px 30px 30px 30px;\n}\n.blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1:not(.centered-layout-list):not(.content-bg-on):not(.mode-list) .no-img .post-entry-content {\n  padding: 0;\n}\n.blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1.content-bg-on:not(.classic-layout-list):not(.centered-layout-list) .post-entry-content {\n  background: #f4f4f4;\n  box-shadow: none;\n}\n@media screen and (max-width: 768px) {\n  .blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1 article {\n    -ms-flex-flow: column nowrap;\n    flex-flow: column nowrap;\n    margin-top: 20px;\n  }\n  .blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1.dividers-on article {\n    border: none;\n  }\n  .blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1.content-bg-on.centered-layout-list article {\n    padding: 0;\n  }\n  .blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1.blog-shortcode.dividers-on article,\n  .blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1.dividers-on.classic-layout-list article {\n    margin-top: 20px;\n    padding: 0;\n  }\n  .blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1.blog-shortcode.dividers-on article:first-of-type,\n  .blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1.dividers-on.classic-layout-list article:first-of-type {\n    padding: 0;\n  }\n  #page .blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1 .post-thumbnail-wrap,\n  #page .blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1 .post-entry-content {\n    width: 100%;\n    margin: 0;\n    top: 0;\n  }\n  #page .blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1 .post-thumbnail-wrap {\n    padding: 0;\n  }\n  #page .blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1 .post-entry-content:after {\n    display: none;\n  }\n  #page .blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1 .project-even .post-thumbnail-wrap,\n  #page .blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1.centered-layout-list .post-thumbnail-wrap {\n    -ms-flex-order: 0;\n    order: 0;\n  }\n  #page .blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1.centered-layout-list .post-entry-title-content {\n    -ms-flex-order: 1;\n    order: 1;\n    width: 100%;\n    padding: 20px 20px 0;\n  }\n  #page .blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1.centered-layout-list .post-entry-content {\n    -ms-flex-order: 2;\n    order: 2;\n    padding-top: 0;\n  }\n  #page .blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1 .fancy-categories {\n    top: 10px;\n    left: 10px;\n    bottom: auto;\n    right: auto;\n  }\n  #page .blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1 .fancy-date a {\n    top: 10px;\n    right: 10px;\n    left: auto;\n    bottom: auto;\n  }\n  #page .blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1 .post-entry-content {\n    padding: 20px;\n  }\n  #page .blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1 .entry-title {\n    margin: 3px 0 5px;\n    font-size: 20px;\n    line-height: 26px;\n  }\n  #page .blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1 .entry-meta {\n    margin: 5px 0 5px;\n  }\n  #page .blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1 .entry-excerpt {\n    margin: 15px 0 0;\n  }\n  #page .blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1 .post-details {\n    margin: 5px 0 10px;\n  }\n  #page .blog-shortcode.blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1 .post-details.details-type-link {\n    margin-bottom: 2px;\n  }\n}\n<\/style><div class=\"articles-list blog-shortcode mode-list blog-list-shortcode-id-a05aded18bf0de8a0058209c02ac7df1 classic-layout-list content-bg-on enable-bg-rollover jquery-filter scale-img dt-icon-bg-off vertical-fancy-style loading-effect-fade-in\" data-cur-page=\"1\" data-post-limit=\"6\" data-pagination-mode=\"load-more\" aria-live=\"assertive\"><article class=\"post project-odd visible post-3048 type-post status-publish format-standard has-post-thumbnail hentry category-aws tag-amazon-aurora-postgresql tag-aurora-postgresql tag-aurora-postgresql-vs-rds-postgresql tag-postgresql category-22 description-off\" data-name=\"How We Helped a Client Save $500,000 on Amazon Aurora PostgreSQL Costs\" data-date=\"2026-02-04T08:47:22+00:00\">\n\n<div class=\"post-thumbnail-wrap\">\n\t<div class=\"post-thumbnail\">\n\n\t\t\n\t\t\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2026\/02\/04\/how-we-helped-a-client-save-500000-on-amazon-aurora-postgresql-costs\/\" class=\"post-thumbnail-rollover layzr-bg layzr-bg\" ><img fetchpriority=\"high\" decoding=\"async\" class=\"blog-thumb-lazy-load preload-me lazy-load aspect\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D&#39;http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg&#39;%20viewBox%3D&#39;0%200%20768%20512&#39;%2F%3E\" data-src=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2026\/02\/ChatGPT-Image-Feb-4-2026-02_14_09-PM-768x512.png\" data-srcset=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2026\/02\/ChatGPT-Image-Feb-4-2026-02_14_09-PM-768x512.png 768w, https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2026\/02\/ChatGPT-Image-Feb-4-2026-02_14_09-PM-1306x870.png 1306w\" loading=\"eager\" style=\"--ratio: 768 \/ 512\" sizes=\"(max-width: 768px) 100vw, 768px\" alt=\"aurora postgresql cost optimization\" title=\"ChatGPT Image Feb 4, 2026, 02_14_09 PM\" width=\"768\" height=\"512\"  \/><\/a>\n\t<\/div>\n<\/div>\n\n\n<div class=\"post-entry-content\">\n\n\t<h3 class=\"entry-title\">\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2026\/02\/04\/how-we-helped-a-client-save-500000-on-amazon-aurora-postgresql-costs\/\" title=\"How We Helped a Client Save $500,000 on Amazon Aurora PostgreSQL Costs\" rel=\"bookmark\">How We Helped a Client Save $500,000 on Amazon Aurora PostgreSQL Costs<\/a>\n\t<\/h3>\n\n\t<div class=\"entry-meta\"><span class=\"category-link\"><a href=\"https:\/\/divaind.com\/ie1\/category\/aws\/\" >AWS<\/a><\/span><a href=\"https:\/\/divaind.com\/ie1\/2026\/02\/04\/\" title=\"8:47 am\" class=\"data-link\" rel=\"bookmark\"><time class=\"entry-date updated\" datetime=\"2026-02-04T08:47:22+00:00\">February 4, 2026<\/time><\/a><a href=\"https:\/\/divaind.com\/ie1\/2026\/02\/04\/how-we-helped-a-client-save-500000-on-amazon-aurora-postgresql-costs\/#respond\" class=\"comment-link\" >Leave a comment<\/a><\/div>\n\t<div class=\"entry-excerpt\"><p>Saved $500K on amazon aurora postgresql Costs Amazon Aurora PostgreSQL\u00a0cost optimization is essential for enterprises that rely on cloud databases but struggle with rising infrastructure&hellip;<\/p>\n<\/div>\n\t\n<a href=\"https:\/\/divaind.com\/ie1\/2026\/02\/04\/how-we-helped-a-client-save-500000-on-amazon-aurora-postgresql-costs\/\" class=\"dt-btn-s dt-btn post-details details-type-btn\" aria-label=\"Read more about How We Helped a Client Save $500,000 on Amazon Aurora PostgreSQL Costs\">Read article<i class=\"dt-icon-the7-arrow-03\" aria-hidden=\"true\"><\/i><\/a>\n\n<\/div><\/article><article class=\"post project-odd visible post-2955 type-post status-publish format-standard has-post-thumbnail hentry category-security tag-authentication tag-cybersecurity tag-dataencryption tag-digitaltrust tag-encryption tag-https tag-internetsecurity tag-openssl-commands tag-secureapps tag-secureconnection tag-secureweb tag-ssl tag-ssl-certificates tag-ssl-types tag-sslcertificate tag-sslfeatures tag-sslhandshake tag-ssltypes tag-sslvalidation tag-sslvstls tag-tls tag-tls-encryption tag-websecurity tag-website-security tag-websitesecurity category-30 description-off\" data-name=\"All about the SSL certificates\" data-date=\"2026-01-13T13:02:55+00:00\">\n\n<div class=\"post-thumbnail-wrap\">\n\t<div class=\"post-thumbnail\">\n\n\t\t\n\t\t\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2026\/01\/13\/all-about-the-ssl-certificates\/\" class=\"post-thumbnail-rollover layzr-bg layzr-bg\" ><img decoding=\"async\" class=\"blog-thumb-lazy-load preload-me lazy-load aspect\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D&#39;http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg&#39;%20viewBox%3D&#39;0%200%20768%20512&#39;%2F%3E\" data-src=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2026\/01\/Gemini_Generated_Image_a3b7dua3b7dua3b7-scaled-1-768x512.png\" data-srcset=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2026\/01\/Gemini_Generated_Image_a3b7dua3b7dua3b7-scaled-1-768x512.png 768w, https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2026\/01\/Gemini_Generated_Image_a3b7dua3b7dua3b7-scaled-1-1306x870.png 1306w\" loading=\"eager\" style=\"--ratio: 768 \/ 512\" sizes=\"(max-width: 768px) 100vw, 768px\" alt=\"\" title=\"Gemini_Generated_Image_a3b7dua3b7dua3b7\" width=\"768\" height=\"512\"  \/><\/a>\n\t<\/div>\n<\/div>\n\n\n<div class=\"post-entry-content\">\n\n\t<h3 class=\"entry-title\">\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2026\/01\/13\/all-about-the-ssl-certificates\/\" title=\"All about the SSL certificates\" rel=\"bookmark\">All about the SSL certificates<\/a>\n\t<\/h3>\n\n\t<div class=\"entry-meta\"><span class=\"category-link\"><a href=\"https:\/\/divaind.com\/ie1\/category\/security\/\" >security<\/a><\/span><a href=\"https:\/\/divaind.com\/ie1\/2026\/01\/13\/\" title=\"1:02 pm\" class=\"data-link\" rel=\"bookmark\"><time class=\"entry-date updated\" datetime=\"2026-01-13T13:02:55+00:00\">January 13, 2026<\/time><\/a><a href=\"https:\/\/divaind.com\/ie1\/2026\/01\/13\/all-about-the-ssl-certificates\/#respond\" class=\"comment-link\" >Leave a comment<\/a><\/div>\n\t<div class=\"entry-excerpt\"><p>What are SSL certificates:-\u00a0\u00a0 SSL (Secure Sockets Layer) is a cryptographic security protocol designed to provide data privacy, authentication, and integrity for internet communications. Over&hellip;<\/p>\n<\/div>\n\t\n<a href=\"https:\/\/divaind.com\/ie1\/2026\/01\/13\/all-about-the-ssl-certificates\/\" class=\"dt-btn-s dt-btn post-details details-type-btn\" aria-label=\"Read more about All about the SSL certificates\">Read article<i class=\"dt-icon-the7-arrow-03\" aria-hidden=\"true\"><\/i><\/a>\n\n<\/div><\/article><article class=\"post project-odd visible post-2938 type-post status-publish format-standard has-post-thumbnail hentry category-postgresql tag-sysadmin tag-centosstream tag-databasecluster tag-dba tag-devops tag-failover tag-highavailability tag-linuxadmin tag-opensource tag-postgresql tag-replication tag-repmgr category-28 description-off\" data-name=\"High Availability PostgreSQL 16.11 Cluster with repmgr 5.5 on CentOS Stream 10 (Coughlan)\" data-date=\"2026-01-07T10:57:52+00:00\">\n\n<div class=\"post-thumbnail-wrap\">\n\t<div class=\"post-thumbnail\">\n\n\t\t\n\t\t\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2026\/01\/07\/high-availability-postgresql-16-11-cluster-with-repmgr-5-5-on-centos-stream-10-coughlan\/\" class=\"post-thumbnail-rollover layzr-bg layzr-bg\" ><img decoding=\"async\" class=\"blog-thumb-lazy-load preload-me lazy-load aspect\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D&#39;http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg&#39;%20viewBox%3D&#39;0%200%20768%20512&#39;%2F%3E\" data-src=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2026\/01\/Gemini_Generated_Image_czx33eczx33eczx3-scaled-1-768x512.png\" data-srcset=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2026\/01\/Gemini_Generated_Image_czx33eczx33eczx3-scaled-1-768x512.png 768w, https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2026\/01\/Gemini_Generated_Image_czx33eczx33eczx3-scaled-1-1306x870.png 1306w\" loading=\"eager\" style=\"--ratio: 768 \/ 512\" sizes=\"(max-width: 768px) 100vw, 768px\" alt=\"\" title=\"Gemini_Generated_Image_czx33eczx33eczx3\" width=\"768\" height=\"512\"  \/><\/a>\n\t<\/div>\n<\/div>\n\n\n<div class=\"post-entry-content\">\n\n\t<h3 class=\"entry-title\">\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2026\/01\/07\/high-availability-postgresql-16-11-cluster-with-repmgr-5-5-on-centos-stream-10-coughlan\/\" title=\"High Availability PostgreSQL 16.11 Cluster with repmgr 5.5 on CentOS Stream 10 (Coughlan)\" rel=\"bookmark\">High Availability PostgreSQL 16.11 Cluster with repmgr 5.5 on CentOS Stream 10 (Coughlan)<\/a>\n\t<\/h3>\n\n\t<div class=\"entry-meta\"><span class=\"category-link\"><a href=\"https:\/\/divaind.com\/ie1\/category\/postgresql\/\" >Postgresql<\/a><\/span><a href=\"https:\/\/divaind.com\/ie1\/2026\/01\/07\/\" title=\"10:57 am\" class=\"data-link\" rel=\"bookmark\"><time class=\"entry-date updated\" datetime=\"2026-01-07T10:57:52+00:00\">January 7, 2026<\/time><\/a><a href=\"https:\/\/divaind.com\/ie1\/2026\/01\/07\/high-availability-postgresql-16-11-cluster-with-repmgr-5-5-on-centos-stream-10-coughlan\/#comments\" class=\"comment-link\" >1 Comment<\/a><\/div>\n\t<div class=\"entry-excerpt\"><p>Introduction High availability (HA) is a critical requirement for modern database infrastructures, ensuring minimal downtime and seamless failover in case of node failures. PostgreSQL, while&hellip;<\/p>\n<\/div>\n\t\n<a href=\"https:\/\/divaind.com\/ie1\/2026\/01\/07\/high-availability-postgresql-16-11-cluster-with-repmgr-5-5-on-centos-stream-10-coughlan\/\" class=\"dt-btn-s dt-btn post-details details-type-btn\" aria-label=\"Read more about High Availability PostgreSQL 16.11 Cluster with repmgr 5.5 on CentOS Stream 10 (Coughlan)\">Read article<i class=\"dt-icon-the7-arrow-03\" aria-hidden=\"true\"><\/i><\/a>\n\n<\/div><\/article><article class=\"post project-odd visible post-3324 type-post status-publish format-standard has-post-thumbnail hentry category-postgresql tag-asynchronous tag-bynatreedatasolutions tag-database tag-databaseinnovation tag-datadriven tag-dba-community tag-io-performance tag-json tag-parallel-gin-index tag-postgres-update tag-postgresql-18 tag-query-optimization tag-remote-dba tag-techupdate category-28 description-off\" data-name=\"New Features added in PostgreSQL 18\" data-date=\"2025-12-25T19:00:41+00:00\">\n\n<div class=\"post-thumbnail-wrap\">\n\t<div class=\"post-thumbnail\">\n\n\t\t\n\t\t\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2025\/12\/25\/new-features-added-in-postgresql-18\/\" class=\"post-thumbnail-rollover layzr-bg layzr-bg\" ><img decoding=\"async\" class=\"blog-thumb-lazy-load preload-me lazy-load aspect\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D&#39;http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg&#39;%20viewBox%3D&#39;0%200%20768%20512&#39;%2F%3E\" data-src=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2025\/12\/ChatGPT-Image-Dec-24-2025-11_30_30-AM-768x512.png\" data-srcset=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2025\/12\/ChatGPT-Image-Dec-24-2025-11_30_30-AM-768x512.png 768w, https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2025\/12\/ChatGPT-Image-Dec-24-2025-11_30_30-AM-1306x870.png 1306w\" loading=\"eager\" style=\"--ratio: 768 \/ 512\" sizes=\"(max-width: 768px) 100vw, 768px\" alt=\"\" title=\"ChatGPT Image Dec 24, 2025, 11_30_30 AM\" width=\"768\" height=\"512\"  \/><\/a>\n\t<\/div>\n<\/div>\n\n\n<div class=\"post-entry-content\">\n\n\t<h3 class=\"entry-title\">\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2025\/12\/25\/new-features-added-in-postgresql-18\/\" title=\"New Features added in PostgreSQL 18\" rel=\"bookmark\">New Features added in PostgreSQL 18<\/a>\n\t<\/h3>\n\n\t<div class=\"entry-meta\"><span class=\"category-link\"><a href=\"https:\/\/divaind.com\/ie1\/category\/postgresql\/\" >Postgresql<\/a><\/span><a href=\"https:\/\/divaind.com\/ie1\/2025\/12\/25\/\" title=\"7:00 pm\" class=\"data-link\" rel=\"bookmark\"><time class=\"entry-date updated\" datetime=\"2025-12-25T19:00:41+00:00\">December 25, 2025<\/time><\/a><a href=\"https:\/\/divaind.com\/ie1\/2025\/12\/25\/new-features-added-in-postgresql-18\/#comments\" class=\"comment-link\" >1 Comment<\/a><\/div>\n\t<div class=\"entry-excerpt\"><p>PostgreSQL 18: Revolutionary Changes in Database Performance and Functionality-\u00a0 PostgreSQL 18, released on September 25, 2025, is one of the most significant updates in years.&hellip;<\/p>\n<\/div>\n\t\n<a href=\"https:\/\/divaind.com\/ie1\/2025\/12\/25\/new-features-added-in-postgresql-18\/\" class=\"dt-btn-s dt-btn post-details details-type-btn\" aria-label=\"Read more about New Features added in PostgreSQL 18\">Read article<i class=\"dt-icon-the7-arrow-03\" aria-hidden=\"true\"><\/i><\/a>\n\n<\/div><\/article><article class=\"post project-odd visible post-2890 type-post status-publish format-standard has-post-thumbnail hentry category-postgresql tag-techblog tag-bynatreeinsights tag-databasearchitecture tag-infraengineering tag-logicalreplication tag-minimaldowntime tag-postgresqlpartitioning category-28 description-off\" data-name=\"Partitioning a Large PostgreSQL Table with Minimal Downtime Using Logical Replication\" data-date=\"2025-08-21T05:46:12+00:00\">\n\n<div class=\"post-thumbnail-wrap\">\n\t<div class=\"post-thumbnail\">\n\n\t\t\n\t\t\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2025\/08\/21\/partitioning-a-large-postgresql-table-with-minimal-downtime-using-logical-replication\/\" class=\"post-thumbnail-rollover layzr-bg layzr-bg\" ><img decoding=\"async\" class=\"blog-thumb-lazy-load preload-me lazy-load aspect\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D&#39;http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg&#39;%20viewBox%3D&#39;0%200%20768%20512&#39;%2F%3E\" data-src=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2025\/08\/ChatGPT-Image-Aug-21-2025-11_06_41-AM-768x512.png\" data-srcset=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2025\/08\/ChatGPT-Image-Aug-21-2025-11_06_41-AM-768x512.png 768w, https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2025\/08\/ChatGPT-Image-Aug-21-2025-11_06_41-AM-1306x870.png 1306w\" loading=\"eager\" style=\"--ratio: 768 \/ 512\" sizes=\"(max-width: 768px) 100vw, 768px\" alt=\"\" title=\"ChatGPT Image Aug 21, 2025, 11_06_41 AM\" width=\"768\" height=\"512\"  \/><\/a>\n\t<\/div>\n<\/div>\n\n\n<div class=\"post-entry-content\">\n\n\t<h3 class=\"entry-title\">\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2025\/08\/21\/partitioning-a-large-postgresql-table-with-minimal-downtime-using-logical-replication\/\" title=\"Partitioning a Large PostgreSQL Table with Minimal Downtime Using Logical Replication\" rel=\"bookmark\">Partitioning a Large PostgreSQL Table with Minimal Downtime Using Logical Replication<\/a>\n\t<\/h3>\n\n\t<div class=\"entry-meta\"><span class=\"category-link\"><a href=\"https:\/\/divaind.com\/ie1\/category\/postgresql\/\" >Postgresql<\/a><\/span><a href=\"https:\/\/divaind.com\/ie1\/2025\/08\/21\/\" title=\"5:46 am\" class=\"data-link\" rel=\"bookmark\"><time class=\"entry-date updated\" datetime=\"2025-08-21T05:46:12+00:00\">August 21, 2025<\/time><\/a><a href=\"https:\/\/divaind.com\/ie1\/2025\/08\/21\/partitioning-a-large-postgresql-table-with-minimal-downtime-using-logical-replication\/#respond\" class=\"comment-link\" >Leave a comment<\/a><\/div>\n\t<div class=\"entry-excerpt\"><p>Background (partition migration with logical replication) Large PostgreSQL tables eventually run into performance problems. As rows accumulate, queries slow down, indexes bloat, and retention policies&hellip;<\/p>\n<\/div>\n\t\n<a href=\"https:\/\/divaind.com\/ie1\/2025\/08\/21\/partitioning-a-large-postgresql-table-with-minimal-downtime-using-logical-replication\/\" class=\"dt-btn-s dt-btn post-details details-type-btn\" aria-label=\"Read more about Partitioning a Large PostgreSQL Table with Minimal Downtime Using Logical Replication\">Read article<i class=\"dt-icon-the7-arrow-03\" aria-hidden=\"true\"><\/i><\/a>\n\n<\/div><\/article><article class=\"post project-odd visible post-2886 type-post status-publish format-standard has-post-thumbnail hentry category-postgresql tag-database-optimization tag-database-performance tag-database-security tag-new-features tag-observability tag-open-source-database tag-postgresql-18 tag-postgresql-beta tag-postgresql-ga tag-replication category-28 description-off\" data-name=\"What\u2019s New in PostgreSQL 18 Beta: Performance, Insight and Control\" data-date=\"2025-06-24T05:55:12+00:00\">\n\n<div class=\"post-thumbnail-wrap\">\n\t<div class=\"post-thumbnail\">\n\n\t\t\n\t\t\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2025\/06\/24\/whats-new-in-postgresql-18-beta-performance-insight-and-control\/\" class=\"post-thumbnail-rollover layzr-bg layzr-bg\" ><img decoding=\"async\" class=\"blog-thumb-lazy-load preload-me lazy-load aspect\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D&#39;http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg&#39;%20viewBox%3D&#39;0%200%20768%20512&#39;%2F%3E\" data-src=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2025\/06\/create-feature-image-768x512.png\" data-srcset=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2025\/06\/create-feature-image-768x512.png 768w, https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2025\/06\/create-feature-image-1024x682.png 1024w\" loading=\"eager\" style=\"--ratio: 768 \/ 512\" sizes=\"(max-width: 768px) 100vw, 768px\" alt=\"\" title=\"create feature image\" width=\"768\" height=\"512\"  \/><\/a>\n\t<\/div>\n<\/div>\n\n\n<div class=\"post-entry-content\">\n\n\t<h3 class=\"entry-title\">\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2025\/06\/24\/whats-new-in-postgresql-18-beta-performance-insight-and-control\/\" title=\"What\u2019s New in PostgreSQL 18 Beta: Performance, Insight and Control\" rel=\"bookmark\">What\u2019s New in PostgreSQL 18 Beta: Performance, Insight and Control<\/a>\n\t<\/h3>\n\n\t<div class=\"entry-meta\"><span class=\"category-link\"><a href=\"https:\/\/divaind.com\/ie1\/category\/postgresql\/\" >Postgresql<\/a><\/span><a href=\"https:\/\/divaind.com\/ie1\/2025\/06\/24\/\" title=\"5:55 am\" class=\"data-link\" rel=\"bookmark\"><time class=\"entry-date updated\" datetime=\"2025-06-24T05:55:12+00:00\">June 24, 2025<\/time><\/a><a href=\"https:\/\/divaind.com\/ie1\/2025\/06\/24\/whats-new-in-postgresql-18-beta-performance-insight-and-control\/#comments\" class=\"comment-link\" >1 Comment<\/a><\/div>\n\t<div class=\"entry-excerpt\"><p>PostgreSQL 18 , which is presently in Beta, offers a robust feature set that enhances security, replication, performance, and observability(PostgreSQL 18 Beta). The main improvements&hellip;<\/p>\n<\/div>\n\t\n<a href=\"https:\/\/divaind.com\/ie1\/2025\/06\/24\/whats-new-in-postgresql-18-beta-performance-insight-and-control\/\" class=\"dt-btn-s dt-btn post-details details-type-btn\" aria-label=\"Read more about What\u2019s New in PostgreSQL 18 Beta: Performance, Insight and Control\">Read article<i class=\"dt-icon-the7-arrow-03\" aria-hidden=\"true\"><\/i><\/a>\n\n<\/div><\/article><article class=\"post project-odd hidden post-2857 type-post status-publish format-standard has-post-thumbnail hentry category-postgresql tag-scalability tag-backup-strategy tag-compression tag-data-recovery tag-database-backup tag-database-reliability tag-differential-backup tag-encryption tag-full-backup tag-high-performance-database tag-incremental-backup tag-parallel-processing tag-pgbackrest tag-pitr tag-point-in-time-recovery tag-postgresql tag-postgresql-archive-logs tag-production-environment category-28 description-off\" data-name=\"Efficient PostgreSQL Backup Strategies: Leveraging pgBackRest for Performance &#038; Recovery\" data-date=\"2025-05-15T14:43:24+00:00\">\n\n<div class=\"post-thumbnail-wrap\">\n\t<div class=\"post-thumbnail\">\n\n\t\t\n\t\t\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2025\/05\/15\/efficient-postgresql-backup-strategies-leveraging-pgbackrest-for-performance-recovery\/\" class=\"post-thumbnail-rollover layzr-bg layzr-bg\" ><img decoding=\"async\" class=\"blog-thumb-lazy-load preload-me lazy-load aspect\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D&#39;http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg&#39;%20viewBox%3D&#39;0%200%20768%20512&#39;%2F%3E\" data-src=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2025\/05\/feature-image-for-Ef-768x512.jpg\" data-srcset=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2025\/05\/feature-image-for-Ef-768x512.jpg 768w, https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2025\/05\/feature-image-for-Ef-1024x682.jpg 1024w\" loading=\"eager\" style=\"--ratio: 768 \/ 512\" sizes=\"(max-width: 768px) 100vw, 768px\" alt=\"\" title=\"feature image for Ef\" width=\"768\" height=\"512\"  \/><\/a>\n\t<\/div>\n<\/div>\n\n\n<div class=\"post-entry-content\">\n\n\t<h3 class=\"entry-title\">\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2025\/05\/15\/efficient-postgresql-backup-strategies-leveraging-pgbackrest-for-performance-recovery\/\" title=\"Efficient PostgreSQL Backup Strategies: Leveraging pgBackRest for Performance &#038; Recovery\" rel=\"bookmark\">Efficient PostgreSQL Backup Strategies: Leveraging pgBackRest for Performance &#038; Recovery<\/a>\n\t<\/h3>\n\n\t<div class=\"entry-meta\"><span class=\"category-link\"><a href=\"https:\/\/divaind.com\/ie1\/category\/postgresql\/\" >Postgresql<\/a><\/span><a href=\"https:\/\/divaind.com\/ie1\/2025\/05\/15\/\" title=\"2:43 pm\" class=\"data-link\" rel=\"bookmark\"><time class=\"entry-date updated\" datetime=\"2025-05-15T14:43:24+00:00\">May 15, 2025<\/time><\/a><a href=\"https:\/\/divaind.com\/ie1\/2025\/05\/15\/efficient-postgresql-backup-strategies-leveraging-pgbackrest-for-performance-recovery\/#respond\" class=\"comment-link\" >Leave a comment<\/a><\/div>\n\t<div class=\"entry-excerpt\"><p>In continuation of our blog series on effectively implementing backup strategies in a production environment, this article delves into the topic of Efficient PostgreSQL Backup&hellip;<\/p>\n<\/div>\n\t\n<a href=\"https:\/\/divaind.com\/ie1\/2025\/05\/15\/efficient-postgresql-backup-strategies-leveraging-pgbackrest-for-performance-recovery\/\" class=\"dt-btn-s dt-btn post-details details-type-btn\" aria-label=\"Read more about Efficient PostgreSQL Backup Strategies: Leveraging pgBackRest for Performance &#038; Recovery\">Read article<i class=\"dt-icon-the7-arrow-03\" aria-hidden=\"true\"><\/i><\/a>\n\n<\/div><\/article><article class=\"post project-odd hidden post-2853 type-post status-publish format-standard has-post-thumbnail hentry category-mysql tag-databaseperformance tag-itinfrastructure tag-scalability tag-techblog tag-centos8 tag-databasemanagement tag-databasetips tag-databaseupgrade tag-datasecurity tag-jsonfunctions tag-mysql tag-mysqlupgrade tag-performanceenhancement tag-replicationoptions tag-techsolutions category-24 description-off\" data-name=\"Enhance Performance: Upgrade MySQL 8.0.40 to 8.4.4 on CentOS 8\" data-date=\"2025-04-18T15:49:47+00:00\">\n\n<div class=\"post-thumbnail-wrap\">\n\t<div class=\"post-thumbnail\">\n\n\t\t\n\t\t\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2025\/04\/18\/enhance-performance-upgrade-mysql-8-0-40-to-8-4-4-on-centos-8\/\" class=\"post-thumbnail-rollover layzr-bg layzr-bg\" ><img decoding=\"async\" class=\"blog-thumb-lazy-load preload-me lazy-load aspect\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D&#39;http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg&#39;%20viewBox%3D&#39;0%200%20768%20512&#39;%2F%3E\" data-src=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2025\/04\/AFEATU2-768x512.jpg\" data-srcset=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2025\/04\/AFEATU2-768x512.jpg 768w, https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2025\/04\/AFEATU2-1024x682.jpg 1024w\" loading=\"eager\" style=\"--ratio: 768 \/ 512\" sizes=\"(max-width: 768px) 100vw, 768px\" alt=\"\" title=\"AFEATU~2\" width=\"768\" height=\"512\"  \/><\/a>\n\t<\/div>\n<\/div>\n\n\n<div class=\"post-entry-content\">\n\n\t<h3 class=\"entry-title\">\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2025\/04\/18\/enhance-performance-upgrade-mysql-8-0-40-to-8-4-4-on-centos-8\/\" title=\"Enhance Performance: Upgrade MySQL 8.0.40 to 8.4.4 on CentOS 8\" rel=\"bookmark\">Enhance Performance: Upgrade MySQL 8.0.40 to 8.4.4 on CentOS 8<\/a>\n\t<\/h3>\n\n\t<div class=\"entry-meta\"><span class=\"category-link\"><a href=\"https:\/\/divaind.com\/ie1\/category\/mysql\/\" >MYSQL<\/a><\/span><a href=\"https:\/\/divaind.com\/ie1\/2025\/04\/18\/\" title=\"3:49 pm\" class=\"data-link\" rel=\"bookmark\"><time class=\"entry-date updated\" datetime=\"2025-04-18T15:49:47+00:00\">April 18, 2025<\/time><\/a><a href=\"https:\/\/divaind.com\/ie1\/2025\/04\/18\/enhance-performance-upgrade-mysql-8-0-40-to-8-4-4-on-centos-8\/#respond\" class=\"comment-link\" >Leave a comment<\/a><\/div>\n\t<div class=\"entry-excerpt\"><p>Upgrading from MySQL 8.0.40 to 8.4.4 is critical for gaining increased performance, security, and new capabilities. This version includes expanded replication options, greater support for&hellip;<\/p>\n<\/div>\n\t\n<a href=\"https:\/\/divaind.com\/ie1\/2025\/04\/18\/enhance-performance-upgrade-mysql-8-0-40-to-8-4-4-on-centos-8\/\" class=\"dt-btn-s dt-btn post-details details-type-btn\" aria-label=\"Read more about Enhance Performance: Upgrade MySQL 8.0.40 to 8.4.4 on CentOS 8\">Read article<i class=\"dt-icon-the7-arrow-03\" aria-hidden=\"true\"><\/i><\/a>\n\n<\/div><\/article><article class=\"post project-odd hidden post-2850 type-post status-publish format-standard has-post-thumbnail hentry category-postgresql tag-data-protection tag-data-recovery tag-database-backup-strategies tag-database-cluster-backup tag-database-management tag-differential-backup tag-full-backup tag-incremental-backup tag-integrated-backup-solutions tag-logical-backups tag-pg_basebackup tag-pg_dump tag-pg_dumpall tag-physical-backups tag-point-in-time-recovery tag-postgresql-backup tag-postgresql-performance tag-postgresql-recovery tag-production-environment tag-wal-logging category-28 description-off\" data-name=\"Seamless Backup Strategies in PostgreSQL: Native Tools That Work\" data-date=\"2025-04-18T14:54:21+00:00\">\n\n<div class=\"post-thumbnail-wrap\">\n\t<div class=\"post-thumbnail\">\n\n\t\t\n\t\t\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2025\/04\/18\/seamless-backup-strategies-in-postgresql-native-tools-that-work\/\" class=\"post-thumbnail-rollover layzr-bg layzr-bg\" ><img decoding=\"async\" class=\"blog-thumb-lazy-load preload-me lazy-load aspect\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D&#39;http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg&#39;%20viewBox%3D&#39;0%200%20768%20512&#39;%2F%3E\" data-src=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2025\/04\/AFEATU1-768x512.jpg\" data-srcset=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2025\/04\/AFEATU1-768x512.jpg 768w, https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2025\/04\/AFEATU1-1024x682.jpg 1024w\" loading=\"eager\" style=\"--ratio: 768 \/ 512\" sizes=\"(max-width: 768px) 100vw, 768px\" alt=\"\" title=\"AFEATU~1\" width=\"768\" height=\"512\"  \/><\/a>\n\t<\/div>\n<\/div>\n\n\n<div class=\"post-entry-content\">\n\n\t<h3 class=\"entry-title\">\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2025\/04\/18\/seamless-backup-strategies-in-postgresql-native-tools-that-work\/\" title=\"Seamless Backup Strategies in PostgreSQL: Native Tools That Work\" rel=\"bookmark\">Seamless Backup Strategies in PostgreSQL: Native Tools That Work<\/a>\n\t<\/h3>\n\n\t<div class=\"entry-meta\"><span class=\"category-link\"><a href=\"https:\/\/divaind.com\/ie1\/category\/postgresql\/\" >Postgresql<\/a><\/span><a href=\"https:\/\/divaind.com\/ie1\/2025\/04\/18\/\" title=\"2:54 pm\" class=\"data-link\" rel=\"bookmark\"><time class=\"entry-date updated\" datetime=\"2025-04-18T14:54:21+00:00\">April 18, 2025<\/time><\/a><a href=\"https:\/\/divaind.com\/ie1\/2025\/04\/18\/seamless-backup-strategies-in-postgresql-native-tools-that-work\/#respond\" class=\"comment-link\" >Leave a comment<\/a><\/div>\n\t<div class=\"entry-excerpt\"><p>In continuation of our blog series on effectively implementing backup strategies in a production environment, this article delves into the topic of Seamless Backup Strategies&hellip;<\/p>\n<\/div>\n\t\n<a href=\"https:\/\/divaind.com\/ie1\/2025\/04\/18\/seamless-backup-strategies-in-postgresql-native-tools-that-work\/\" class=\"dt-btn-s dt-btn post-details details-type-btn\" aria-label=\"Read more about Seamless Backup Strategies in PostgreSQL: Native Tools That Work\">Read article<i class=\"dt-icon-the7-arrow-03\" aria-hidden=\"true\"><\/i><\/a>\n\n<\/div><\/article><article class=\"post project-odd hidden post-2845 type-post status-publish format-standard has-post-thumbnail hentry category-postgresql tag-databasebackup tag-databasemanagement tag-dataintegrity tag-datasecurity tag-disasterrecovery tag-highavailability tag-postgresqlbackupstrategy tag-postgresqlproduction tag-postgresqlsolutions tag-reliablebackups category-28 description-off\" data-name=\"Comprehensive Backup Strategies for PostgreSQL in Production\" data-date=\"2025-04-09T17:42:04+00:00\">\n\n<div class=\"post-thumbnail-wrap\">\n\t<div class=\"post-thumbnail\">\n\n\t\t\n\t\t\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2025\/04\/09\/comprehensive-backup-strategies-for-postgresql-in-production\/\" class=\"post-thumbnail-rollover layzr-bg layzr-bg\" ><img decoding=\"async\" class=\"blog-thumb-lazy-load preload-me lazy-load aspect\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D&#39;http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg&#39;%20viewBox%3D&#39;0%200%20768%20512&#39;%2F%3E\" data-src=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2025\/04\/Comprehensive-Backup-Strategy-for-PostgreSQL-in-Production-768x512.jpg\" data-srcset=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2025\/04\/Comprehensive-Backup-Strategy-for-PostgreSQL-in-Production-768x512.jpg 768w, https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2025\/04\/Comprehensive-Backup-Strategy-for-PostgreSQL-in-Production-1024x682.jpg 1024w\" loading=\"eager\" style=\"--ratio: 768 \/ 512\" sizes=\"(max-width: 768px) 100vw, 768px\" alt=\"\" title=\"Comprehensive Backup Strategy for PostgreSQL in Production\" width=\"768\" height=\"512\"  \/><\/a>\n\t<\/div>\n<\/div>\n\n\n<div class=\"post-entry-content\">\n\n\t<h3 class=\"entry-title\">\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2025\/04\/09\/comprehensive-backup-strategies-for-postgresql-in-production\/\" title=\"Comprehensive Backup Strategies for PostgreSQL in Production\" rel=\"bookmark\">Comprehensive Backup Strategies for PostgreSQL in Production<\/a>\n\t<\/h3>\n\n\t<div class=\"entry-meta\"><span class=\"category-link\"><a href=\"https:\/\/divaind.com\/ie1\/category\/postgresql\/\" >Postgresql<\/a><\/span><a href=\"https:\/\/divaind.com\/ie1\/2025\/04\/09\/\" title=\"5:42 pm\" class=\"data-link\" rel=\"bookmark\"><time class=\"entry-date updated\" datetime=\"2025-04-09T17:42:04+00:00\">April 9, 2025<\/time><\/a><a href=\"https:\/\/divaind.com\/ie1\/2025\/04\/09\/comprehensive-backup-strategies-for-postgresql-in-production\/#respond\" class=\"comment-link\" >Leave a comment<\/a><\/div>\n\t<div class=\"entry-excerpt\"><p>To safeguard the database in the production environment and ensure its availability in the case of failures or disasters, a comprehensive backup strategy for PostgreSQL&hellip;<\/p>\n<\/div>\n\t\n<a href=\"https:\/\/divaind.com\/ie1\/2025\/04\/09\/comprehensive-backup-strategies-for-postgresql-in-production\/\" class=\"dt-btn-s dt-btn post-details details-type-btn\" aria-label=\"Read more about Comprehensive Backup Strategies for PostgreSQL in Production\">Read article<i class=\"dt-icon-the7-arrow-03\" aria-hidden=\"true\"><\/i><\/a>\n\n<\/div><\/article><article class=\"post project-odd hidden post-2834 type-post status-publish format-standard has-post-thumbnail hentry category-postgresql tag-bigdata tag-cloudcomputing tag-dataintegration tag-datapipeline tag-datareplication tag-debezium tag-innovation tag-kafka tag-postgresql tag-realtimedata tag-scalablesystems tag-sqlserver tag-techsolutions category-28 description-off\" data-name=\"Real-Time Data Replication: PostgreSQL 16 \u2192 Kafka \u2192 SQL Server 2022 Express\" data-date=\"2025-03-13T15:44:30+00:00\">\n\n<div class=\"post-thumbnail-wrap\">\n\t<div class=\"post-thumbnail\">\n\n\t\t\n\t\t\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2025\/03\/13\/real-time-data-replication-postgresql-16-%e2%86%92-kafka-%e2%86%92-sql-server-2022-express\/\" class=\"post-thumbnail-rollover layzr-bg layzr-bg\" ><img decoding=\"async\" class=\"blog-thumb-lazy-load preload-me lazy-load aspect\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D&#39;http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg&#39;%20viewBox%3D&#39;0%200%20768%20512&#39;%2F%3E\" data-src=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2025\/03\/Real-Time-Data-Replication_-PostgreSQL-16-\u2192-Kafka-\u2192-SQL-Server-2022-Express-768x512.jpg\" data-srcset=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2025\/03\/Real-Time-Data-Replication_-PostgreSQL-16-\u2192-Kafka-\u2192-SQL-Server-2022-Express-768x512.jpg 768w, https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2025\/03\/Real-Time-Data-Replication_-PostgreSQL-16-\u2192-Kafka-\u2192-SQL-Server-2022-Express-1024x682.jpg 1024w\" loading=\"eager\" style=\"--ratio: 768 \/ 512\" sizes=\"(max-width: 768px) 100vw, 768px\" alt=\"\" title=\"Real-Time Data Replication_ PostgreSQL 16 \u2192 Kafka \u2192 SQL Server 2022 Express\" width=\"768\" height=\"512\"  \/><\/a>\n\t<\/div>\n<\/div>\n\n\n<div class=\"post-entry-content\">\n\n\t<h3 class=\"entry-title\">\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2025\/03\/13\/real-time-data-replication-postgresql-16-%e2%86%92-kafka-%e2%86%92-sql-server-2022-express\/\" title=\"Real-Time Data Replication: PostgreSQL 16 \u2192 Kafka \u2192 SQL Server 2022 Express\" rel=\"bookmark\">Real-Time Data Replication: PostgreSQL 16 \u2192 Kafka \u2192 SQL Server 2022 Express<\/a>\n\t<\/h3>\n\n\t<div class=\"entry-meta\"><span class=\"category-link\"><a href=\"https:\/\/divaind.com\/ie1\/category\/postgresql\/\" >Postgresql<\/a><\/span><a href=\"https:\/\/divaind.com\/ie1\/2025\/03\/13\/\" title=\"3:44 pm\" class=\"data-link\" rel=\"bookmark\"><time class=\"entry-date updated\" datetime=\"2025-03-13T15:44:30+00:00\">March 13, 2025<\/time><\/a><a href=\"https:\/\/divaind.com\/ie1\/2025\/03\/13\/real-time-data-replication-postgresql-16-%e2%86%92-kafka-%e2%86%92-sql-server-2022-express\/#respond\" class=\"comment-link\" >Leave a comment<\/a><\/div>\n\t<div class=\"entry-excerpt\"><p>A few days ago, we were approached by a client with a particular objective but a difficult barrier. Their goal? Real-Time Data Replication: PostgreSQL 16&hellip;<\/p>\n<\/div>\n\t\n<a href=\"https:\/\/divaind.com\/ie1\/2025\/03\/13\/real-time-data-replication-postgresql-16-%e2%86%92-kafka-%e2%86%92-sql-server-2022-express\/\" class=\"dt-btn-s dt-btn post-details details-type-btn\" aria-label=\"Read more about Real-Time Data Replication: PostgreSQL 16 \u2192 Kafka \u2192 SQL Server 2022 Express\">Read article<i class=\"dt-icon-the7-arrow-03\" aria-hidden=\"true\"><\/i><\/a>\n\n<\/div><\/article><article class=\"post project-odd hidden post-2813 type-post status-publish format-standard has-post-thumbnail hentry category-mysql tag-mysql8-4 tag-continuousimprovement tag-databasemanagement tag-dba tag-developers tag-gtids tag-hashtableoptimization tag-innodb tag-innovation tag-mysql tag-mysql8-0 tag-performance tag-replication tag-security category-24 description-off\" data-name=\"New Features in Mysql 8.4 from Mysql 8.0\" data-date=\"2025-02-10T17:59:17+00:00\">\n\n<div class=\"post-thumbnail-wrap\">\n\t<div class=\"post-thumbnail\">\n\n\t\t\n\t\t\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2025\/02\/10\/new-features-in-mysql-8-4-from-mysql-8-0\/\" class=\"post-thumbnail-rollover layzr-bg layzr-bg\" ><img decoding=\"async\" class=\"blog-thumb-lazy-load preload-me lazy-load aspect\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D&#39;http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg&#39;%20viewBox%3D&#39;0%200%20768%20512&#39;%2F%3E\" data-src=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2025\/02\/mysql-logo2-768x512.png\" data-srcset=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2025\/02\/mysql-logo2-768x512.png 768w, https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2025\/02\/mysql-logo2-1031x687.png 1031w\" loading=\"eager\" style=\"--ratio: 768 \/ 512\" sizes=\"(max-width: 768px) 100vw, 768px\" alt=\"\" title=\"mysql logo2\" width=\"768\" height=\"512\"  \/><\/a>\n\t<\/div>\n<\/div>\n\n\n<div class=\"post-entry-content\">\n\n\t<h3 class=\"entry-title\">\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2025\/02\/10\/new-features-in-mysql-8-4-from-mysql-8-0\/\" title=\"New Features in Mysql 8.4 from Mysql 8.0\" rel=\"bookmark\">New Features in Mysql 8.4 from Mysql 8.0<\/a>\n\t<\/h3>\n\n\t<div class=\"entry-meta\"><span class=\"category-link\"><a href=\"https:\/\/divaind.com\/ie1\/category\/mysql\/\" >MYSQL<\/a><\/span><a href=\"https:\/\/divaind.com\/ie1\/2025\/02\/10\/\" title=\"5:59 pm\" class=\"data-link\" rel=\"bookmark\"><time class=\"entry-date updated\" datetime=\"2025-02-10T17:59:17+00:00\">February 10, 2025<\/time><\/a><a href=\"https:\/\/divaind.com\/ie1\/2025\/02\/10\/new-features-in-mysql-8-4-from-mysql-8-0\/#respond\" class=\"comment-link\" >Leave a comment<\/a><\/div>\n\t<div class=\"entry-excerpt\"><p>MySQL 8.0, a reliable base in database management, has been continuously updated with new functionalities and enhancements. This blog explores the performance, security, user-friendly tools,&hellip;<\/p>\n<\/div>\n\t\n<a href=\"https:\/\/divaind.com\/ie1\/2025\/02\/10\/new-features-in-mysql-8-4-from-mysql-8-0\/\" class=\"dt-btn-s dt-btn post-details details-type-btn\" aria-label=\"Read more about New Features in Mysql 8.4 from Mysql 8.0\">Read article<i class=\"dt-icon-the7-arrow-03\" aria-hidden=\"true\"><\/i><\/a>\n\n<\/div><\/article><article class=\"post project-odd hidden post-2805 type-post status-publish format-standard has-post-thumbnail hentry category-postgresql tag-database-monitoring tag-enhancing-performance tag-monitoring-postgresql tag-pg_proctab tag-pg_stat_activity tag-postgres tag-postgresql-performance tag-postgresql-tools tag-sql-performance-tuning category-28 description-off\" data-name=\"Monitoring PostgreSQL: Enhancing Performance with pg_proctab and pg_stat_activity\" data-date=\"2025-01-29T15:10:26+00:00\">\n\n<div class=\"post-thumbnail-wrap\">\n\t<div class=\"post-thumbnail\">\n\n\t\t\n\t\t\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2025\/01\/29\/monitoring-postgresql-enhancing-performance-with-pg_proctab-and-pg_stat_activity\/\" class=\"post-thumbnail-rollover layzr-bg layzr-bg\" ><img decoding=\"async\" class=\"blog-thumb-lazy-load preload-me lazy-load aspect\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D&#39;http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg&#39;%20viewBox%3D&#39;0%200%20768%20512&#39;%2F%3E\" data-src=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2025\/01\/Monitoring-PostgreSQL_-Enhancing-Performance-with-pg_proctab-and-pg_stat_activity-768x512.jpg\" data-srcset=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2025\/01\/Monitoring-PostgreSQL_-Enhancing-Performance-with-pg_proctab-and-pg_stat_activity-768x512.jpg 768w, https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2025\/01\/Monitoring-PostgreSQL_-Enhancing-Performance-with-pg_proctab-and-pg_stat_activity-1024x682.jpg 1024w\" loading=\"eager\" style=\"--ratio: 768 \/ 512\" sizes=\"(max-width: 768px) 100vw, 768px\" alt=\"\" title=\"Monitoring PostgreSQL_ Enhancing Performance with pg_proctab and pg_stat_activity\" width=\"768\" height=\"512\"  \/><\/a>\n\t<\/div>\n<\/div>\n\n\n<div class=\"post-entry-content\">\n\n\t<h3 class=\"entry-title\">\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2025\/01\/29\/monitoring-postgresql-enhancing-performance-with-pg_proctab-and-pg_stat_activity\/\" title=\"Monitoring PostgreSQL: Enhancing Performance with pg_proctab and pg_stat_activity\" rel=\"bookmark\">Monitoring PostgreSQL: Enhancing Performance with pg_proctab and pg_stat_activity<\/a>\n\t<\/h3>\n\n\t<div class=\"entry-meta\"><span class=\"category-link\"><a href=\"https:\/\/divaind.com\/ie1\/category\/postgresql\/\" >Postgresql<\/a><\/span><a href=\"https:\/\/divaind.com\/ie1\/2025\/01\/29\/\" title=\"3:10 pm\" class=\"data-link\" rel=\"bookmark\"><time class=\"entry-date updated\" datetime=\"2025-01-29T15:10:26+00:00\">January 29, 2025<\/time><\/a><a href=\"https:\/\/divaind.com\/ie1\/2025\/01\/29\/monitoring-postgresql-enhancing-performance-with-pg_proctab-and-pg_stat_activity\/#respond\" class=\"comment-link\" >Leave a comment<\/a><\/div>\n\t<div class=\"entry-excerpt\"><p>In this blog, we will discuss using pg_proctab with pg_state_activity in critical situations. Monitoring system resources and PostgreSQL performance is essential particularly in critical situations,&hellip;<\/p>\n<\/div>\n\t\n<a href=\"https:\/\/divaind.com\/ie1\/2025\/01\/29\/monitoring-postgresql-enhancing-performance-with-pg_proctab-and-pg_stat_activity\/\" class=\"dt-btn-s dt-btn post-details details-type-btn\" aria-label=\"Read more about Monitoring PostgreSQL: Enhancing Performance with pg_proctab and pg_stat_activity\">Read article<i class=\"dt-icon-the7-arrow-03\" aria-hidden=\"true\"><\/i><\/a>\n\n<\/div><\/article><article class=\"post project-odd hidden post-2790 type-post status-publish format-standard has-post-thumbnail hentry category-postgresql tag-database-management tag-database-performance tag-open-source-database tag-performance-optimization tag-pg_prewarm tag-postgresql tag-postgresql-extensions tag-postgresql-tools tag-shared-buffers tag-sql-performance category-28 description-off\" data-name=\"Optimizing PostgreSQL Performance with pg_prewarm\" data-date=\"2025-01-22T16:47:23+00:00\">\n\n<div class=\"post-thumbnail-wrap\">\n\t<div class=\"post-thumbnail\">\n\n\t\t\n\t\t\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2025\/01\/22\/optimizing-postgresql-performance-with-pg_prewarm\/\" class=\"post-thumbnail-rollover layzr-bg layzr-bg\" ><img decoding=\"async\" class=\"blog-thumb-lazy-load preload-me lazy-load aspect\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D&#39;http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg&#39;%20viewBox%3D&#39;0%200%20768%20512&#39;%2F%3E\" data-src=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2025\/01\/Optimizing-PostgreSQL-Performance-with-pg_prewarm-768x512.jpg\" data-srcset=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2025\/01\/Optimizing-PostgreSQL-Performance-with-pg_prewarm-768x512.jpg 768w, https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2025\/01\/Optimizing-PostgreSQL-Performance-with-pg_prewarm-1024x682.jpg 1024w\" loading=\"eager\" style=\"--ratio: 768 \/ 512\" sizes=\"(max-width: 768px) 100vw, 768px\" alt=\"\" title=\"Optimizing PostgreSQL Performance with pg_prewarm\" width=\"768\" height=\"512\"  \/><\/a>\n\t<\/div>\n<\/div>\n\n\n<div class=\"post-entry-content\">\n\n\t<h3 class=\"entry-title\">\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2025\/01\/22\/optimizing-postgresql-performance-with-pg_prewarm\/\" title=\"Optimizing PostgreSQL Performance with pg_prewarm\" rel=\"bookmark\">Optimizing PostgreSQL Performance with pg_prewarm<\/a>\n\t<\/h3>\n\n\t<div class=\"entry-meta\"><span class=\"category-link\"><a href=\"https:\/\/divaind.com\/ie1\/category\/postgresql\/\" >Postgresql<\/a><\/span><a href=\"https:\/\/divaind.com\/ie1\/2025\/01\/22\/\" title=\"4:47 pm\" class=\"data-link\" rel=\"bookmark\"><time class=\"entry-date updated\" datetime=\"2025-01-22T16:47:23+00:00\">January 22, 2025<\/time><\/a><a href=\"https:\/\/divaind.com\/ie1\/2025\/01\/22\/optimizing-postgresql-performance-with-pg_prewarm\/#respond\" class=\"comment-link\" >Leave a comment<\/a><\/div>\n\t<div class=\"entry-excerpt\"><p>In this blog post, I will showcase a demonstration of PostgreSQL performance with pg_prewarm in PostgreSQL 16.1 PostgreSQL is a powerful open-source database that comes&hellip;<\/p>\n<\/div>\n\t\n<a href=\"https:\/\/divaind.com\/ie1\/2025\/01\/22\/optimizing-postgresql-performance-with-pg_prewarm\/\" class=\"dt-btn-s dt-btn post-details details-type-btn\" aria-label=\"Read more about Optimizing PostgreSQL Performance with pg_prewarm\">Read article<i class=\"dt-icon-the7-arrow-03\" aria-hidden=\"true\"><\/i><\/a>\n\n<\/div><\/article><article class=\"post project-odd hidden post-2779 type-post status-publish format-standard has-post-thumbnail hentry category-mysql tag-centos-8 tag-centos-performance tag-database-management tag-database-performance tag-innotop tag-it-operations tag-linux-tools tag-monitoring-tools tag-mysql-monitoring tag-mysql-performance tag-open-source-monitoring tag-performance-tuning tag-real-time-monitoring tag-server-monitoring tag-system-administration category-24 description-off\" data-name=\"Real-Time MySQL Performance Monitoring with Innotop on CentOS 8 &#8211; Monitoring Tools in MySQL\" data-date=\"2025-01-22T15:25:58+00:00\">\n\n<div class=\"post-thumbnail-wrap\">\n\t<div class=\"post-thumbnail\">\n\n\t\t\n\t\t\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2025\/01\/22\/real-time-mysql-performance-monitoring-with-innotop-on-centos-8-monitoring-tools-in-mysql\/\" class=\"post-thumbnail-rollover layzr-bg layzr-bg\" ><img decoding=\"async\" class=\"blog-thumb-lazy-load preload-me lazy-load aspect\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D&#39;http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg&#39;%20viewBox%3D&#39;0%200%20768%20512&#39;%2F%3E\" data-src=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2025\/01\/dolphin-in-the-middle-of-the-image-768x512.jpg\" data-srcset=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2025\/01\/dolphin-in-the-middle-of-the-image-768x512.jpg 768w, https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2025\/01\/dolphin-in-the-middle-of-the-image-1024x682.jpg 1024w\" loading=\"eager\" style=\"--ratio: 768 \/ 512\" sizes=\"(max-width: 768px) 100vw, 768px\" alt=\"\" title=\"dolphin in the middle of the image\" width=\"768\" height=\"512\"  \/><\/a>\n\t<\/div>\n<\/div>\n\n\n<div class=\"post-entry-content\">\n\n\t<h3 class=\"entry-title\">\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2025\/01\/22\/real-time-mysql-performance-monitoring-with-innotop-on-centos-8-monitoring-tools-in-mysql\/\" title=\"Real-Time MySQL Performance Monitoring with Innotop on CentOS 8 &#8211; Monitoring Tools in MySQL\" rel=\"bookmark\">Real-Time MySQL Performance Monitoring with Innotop on CentOS 8 &#8211; Monitoring Tools in MySQL<\/a>\n\t<\/h3>\n\n\t<div class=\"entry-meta\"><span class=\"category-link\"><a href=\"https:\/\/divaind.com\/ie1\/category\/mysql\/\" >MYSQL<\/a><\/span><a href=\"https:\/\/divaind.com\/ie1\/2025\/01\/22\/\" title=\"3:25 pm\" class=\"data-link\" rel=\"bookmark\"><time class=\"entry-date updated\" datetime=\"2025-01-22T15:25:58+00:00\">January 22, 2025<\/time><\/a><a href=\"https:\/\/divaind.com\/ie1\/2025\/01\/22\/real-time-mysql-performance-monitoring-with-innotop-on-centos-8-monitoring-tools-in-mysql\/#respond\" class=\"comment-link\" >Leave a comment<\/a><\/div>\n\t<div class=\"entry-excerpt\"><p>In this blog post, we&#8217;ll explore real-time MySQL performance monitoring with Innotop on CentOS 8. Using the best monitoring tools in MySQL, you can ensure&hellip;<\/p>\n<\/div>\n\t\n<a href=\"https:\/\/divaind.com\/ie1\/2025\/01\/22\/real-time-mysql-performance-monitoring-with-innotop-on-centos-8-monitoring-tools-in-mysql\/\" class=\"dt-btn-s dt-btn post-details details-type-btn\" aria-label=\"Read more about Real-Time MySQL Performance Monitoring with Innotop on CentOS 8 &#8211; Monitoring Tools in MySQL\">Read article<i class=\"dt-icon-the7-arrow-03\" aria-hidden=\"true\"><\/i><\/a>\n\n<\/div><\/article><article class=\"post project-odd hidden post-2775 type-post status-publish format-standard has-post-thumbnail hentry category-mysql tag-centos-database-migration tag-data-transfer-tools tag-database-migration tag-database-upgrade tag-efficient-database-transition tag-mysql-8-0-40-to-postgresql-16-1 tag-mysql-migration-guide tag-mysql-to-postgresql tag-mysql-to-postgresql-conversion tag-pgloader-on-centos-8 tag-pgloader-tutorial tag-postgresql-migration-steps tag-postgresql-performance tag-postgresql-tips-and-tricks tag-seamless-database-migration category-24 description-off\" data-name=\"Effortless Database Migration: Transition from MySQL 8.0.40 to PostgreSQL 16.1 Using pgloader on CentOS 8\" data-date=\"2025-01-13T16:24:06+00:00\">\n\n<div class=\"post-thumbnail-wrap\">\n\t<div class=\"post-thumbnail\">\n\n\t\t\n\t\t\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2025\/01\/13\/effortless-database-migration-transition-from-mysql-8-0-40-to-postgresql-16-1\/\" class=\"post-thumbnail-rollover layzr-bg layzr-bg\" ><img decoding=\"async\" class=\"blog-thumb-lazy-load preload-me lazy-load aspect\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D&#39;http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg&#39;%20viewBox%3D&#39;0%200%20768%20512&#39;%2F%3E\" data-src=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2025\/01\/Effortless-Database-Migration_-Transition-from-MySQL-8.0.40-to-PostgreSQL-16.1-Using-pgloader-on-CentOS-8-with-a-baby-elephant-1-768x512.jpg\" data-srcset=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2025\/01\/Effortless-Database-Migration_-Transition-from-MySQL-8.0.40-to-PostgreSQL-16.1-Using-pgloader-on-CentOS-8-with-a-baby-elephant-1-768x512.jpg 768w, https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2025\/01\/Effortless-Database-Migration_-Transition-from-MySQL-8.0.40-to-PostgreSQL-16.1-Using-pgloader-on-CentOS-8-with-a-baby-elephant-1-1024x682.jpg 1024w\" loading=\"eager\" style=\"--ratio: 768 \/ 512\" sizes=\"(max-width: 768px) 100vw, 768px\" alt=\"database migration\" title=\"Effortless Database Migration_ Transition from MySQL 8.0.40 to PostgreSQL 16.1 Using pgloader on CentOS 8 with a baby elephant (1)\" width=\"768\" height=\"512\"  \/><\/a>\n\t<\/div>\n<\/div>\n\n\n<div class=\"post-entry-content\">\n\n\t<h3 class=\"entry-title\">\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2025\/01\/13\/effortless-database-migration-transition-from-mysql-8-0-40-to-postgresql-16-1\/\" title=\"Effortless Database Migration: Transition from MySQL 8.0.40 to PostgreSQL 16.1 Using pgloader on CentOS 8\" rel=\"bookmark\">Effortless Database Migration: Transition from MySQL 8.0.40 to PostgreSQL 16.1 Using pgloader on CentOS 8<\/a>\n\t<\/h3>\n\n\t<div class=\"entry-meta\"><span class=\"category-link\"><a href=\"https:\/\/divaind.com\/ie1\/category\/mysql\/\" >MYSQL<\/a><\/span><a href=\"https:\/\/divaind.com\/ie1\/2025\/01\/13\/\" title=\"4:24 pm\" class=\"data-link\" rel=\"bookmark\"><time class=\"entry-date updated\" datetime=\"2025-01-13T16:24:06+00:00\">January 13, 2025<\/time><\/a><a href=\"https:\/\/divaind.com\/ie1\/2025\/01\/13\/effortless-database-migration-transition-from-mysql-8-0-40-to-postgresql-16-1\/#respond\" class=\"comment-link\" >Leave a comment<\/a><\/div>\n\t<div class=\"entry-excerpt\"><p>Introduction &nbsp; In today&#8217;s dynamic business environment, data migration across database migration systems is a purposeful action that corresponds to changing organizational demands. In this&hellip;<\/p>\n<\/div>\n\t\n<a href=\"https:\/\/divaind.com\/ie1\/2025\/01\/13\/effortless-database-migration-transition-from-mysql-8-0-40-to-postgresql-16-1\/\" class=\"dt-btn-s dt-btn post-details details-type-btn\" aria-label=\"Read more about Effortless Database Migration: Transition from MySQL 8.0.40 to PostgreSQL 16.1 Using pgloader on CentOS 8\">Read article<i class=\"dt-icon-the7-arrow-03\" aria-hidden=\"true\"><\/i><\/a>\n\n<\/div><\/article><article class=\"post project-odd hidden post-2769 type-post status-publish format-standard has-post-thumbnail hentry category-postgresql tag-advanced-postgresql tag-database-best-practices tag-database-optimization tag-efficient-json-handling tag-json-data-types tag-json-functions tag-json-indexing tag-json-querying tag-json-storage tag-jsonb-vs-json tag-postgresql-database tag-postgresql-json tag-postgresql-performance tag-postgresql-tips tag-postgresql-tutorials tag-query-performance category-28 description-off\" data-name=\"Efficiently Storing and Querying JSON Data in PostgreSQL\" data-date=\"2025-01-13T14:39:31+00:00\">\n\n<div class=\"post-thumbnail-wrap\">\n\t<div class=\"post-thumbnail\">\n\n\t\t\n\t\t\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2025\/01\/13\/efficiently-storing-and-querying-json-data-in-postgresql\/\" class=\"post-thumbnail-rollover layzr-bg layzr-bg\" ><img decoding=\"async\" class=\"blog-thumb-lazy-load preload-me lazy-load aspect\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D&#39;http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg&#39;%20viewBox%3D&#39;0%200%20768%20512&#39;%2F%3E\" data-src=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2025\/01\/Efficiently-Storing-and-Querying-JSON-Data-in-PostgreSQL-with-a-baby-elephant-768x512.jpg\" data-srcset=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2025\/01\/Efficiently-Storing-and-Querying-JSON-Data-in-PostgreSQL-with-a-baby-elephant-768x512.jpg 768w, https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2025\/01\/Efficiently-Storing-and-Querying-JSON-Data-in-PostgreSQL-with-a-baby-elephant-1024x682.jpg 1024w\" loading=\"eager\" style=\"--ratio: 768 \/ 512\" sizes=\"(max-width: 768px) 100vw, 768px\" alt=\"\" title=\"Efficiently Storing and Querying JSON Data in PostgreSQL with a baby elephant\" width=\"768\" height=\"512\"  \/><\/a>\n\t<\/div>\n<\/div>\n\n\n<div class=\"post-entry-content\">\n\n\t<h3 class=\"entry-title\">\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2025\/01\/13\/efficiently-storing-and-querying-json-data-in-postgresql\/\" title=\"Efficiently Storing and Querying JSON Data in PostgreSQL\" rel=\"bookmark\">Efficiently Storing and Querying JSON Data in PostgreSQL<\/a>\n\t<\/h3>\n\n\t<div class=\"entry-meta\"><span class=\"category-link\"><a href=\"https:\/\/divaind.com\/ie1\/category\/postgresql\/\" >Postgresql<\/a><\/span><a href=\"https:\/\/divaind.com\/ie1\/2025\/01\/13\/\" title=\"2:39 pm\" class=\"data-link\" rel=\"bookmark\"><time class=\"entry-date updated\" datetime=\"2025-01-13T14:39:31+00:00\">January 13, 2025<\/time><\/a><a href=\"https:\/\/divaind.com\/ie1\/2025\/01\/13\/efficiently-storing-and-querying-json-data-in-postgresql\/#respond\" class=\"comment-link\" >Leave a comment<\/a><\/div>\n\t<div class=\"entry-excerpt\"><p>JSON Data, short for JavaScript Object Notation, is an open standard format that structures data in key-value pairs and arrays. Widely used in web services,&hellip;<\/p>\n<\/div>\n\t\n<a href=\"https:\/\/divaind.com\/ie1\/2025\/01\/13\/efficiently-storing-and-querying-json-data-in-postgresql\/\" class=\"dt-btn-s dt-btn post-details details-type-btn\" aria-label=\"Read more about Efficiently Storing and Querying JSON Data in PostgreSQL\">Read article<i class=\"dt-icon-the7-arrow-03\" aria-hidden=\"true\"><\/i><\/a>\n\n<\/div><\/article><article class=\"post project-odd hidden post-2761 type-post status-publish format-standard has-post-thumbnail hentry category-mysql tag-cloud-database tag-data-transfer tag-database-conversion tag-database-migration tag-it-solutions tag-migration-tools tag-mysql tag-pg2mysql tag-postgresql tag-postgresql-to-mysql tag-sql-databases category-24 description-off\" data-name=\"Database Migration from postgres to mysql using pg2mysql tool\" data-date=\"2025-01-06T15:34:54+00:00\">\n\n<div class=\"post-thumbnail-wrap\">\n\t<div class=\"post-thumbnail\">\n\n\t\t\n\t\t\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2025\/01\/06\/database-migration-from-postgres-to-mysql-using-pg2mysql-tool\/\" class=\"post-thumbnail-rollover layzr-bg layzr-bg\" ><img decoding=\"async\" class=\"blog-thumb-lazy-load preload-me lazy-load aspect\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D&#39;http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg&#39;%20viewBox%3D&#39;0%200%20768%20512&#39;%2F%3E\" data-src=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2025\/01\/Database-Migration-from-PostgreSQL-to-MySQL-using-pg2mysql-tool-768x512.jpg\" data-srcset=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2025\/01\/Database-Migration-from-PostgreSQL-to-MySQL-using-pg2mysql-tool-768x512.jpg 768w, https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2025\/01\/Database-Migration-from-PostgreSQL-to-MySQL-using-pg2mysql-tool-1024x682.jpg 1024w\" loading=\"eager\" style=\"--ratio: 768 \/ 512\" sizes=\"(max-width: 768px) 100vw, 768px\" alt=\"\" title=\"Database Migration from PostgreSQL to MySQL using pg2mysql tool\" width=\"768\" height=\"512\"  \/><\/a>\n\t<\/div>\n<\/div>\n\n\n<div class=\"post-entry-content\">\n\n\t<h3 class=\"entry-title\">\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2025\/01\/06\/database-migration-from-postgres-to-mysql-using-pg2mysql-tool\/\" title=\"Database Migration from postgres to mysql using pg2mysql tool\" rel=\"bookmark\">Database Migration from postgres to mysql using pg2mysql tool<\/a>\n\t<\/h3>\n\n\t<div class=\"entry-meta\"><span class=\"category-link\"><a href=\"https:\/\/divaind.com\/ie1\/category\/mysql\/\" >MYSQL<\/a><\/span><a href=\"https:\/\/divaind.com\/ie1\/2025\/01\/06\/\" title=\"3:34 pm\" class=\"data-link\" rel=\"bookmark\"><time class=\"entry-date updated\" datetime=\"2025-01-06T15:34:54+00:00\">January 6, 2025<\/time><\/a><a href=\"https:\/\/divaind.com\/ie1\/2025\/01\/06\/database-migration-from-postgres-to-mysql-using-pg2mysql-tool\/#respond\" class=\"comment-link\" >Leave a comment<\/a><\/div>\n\t<div class=\"entry-excerpt\"><p>Introduction In today&#8217;s dynamic corporate climate, data migration between database systems is a deliberate move that coincides with changing organizational demands. This block describes the&hellip;<\/p>\n<\/div>\n\t\n<a href=\"https:\/\/divaind.com\/ie1\/2025\/01\/06\/database-migration-from-postgres-to-mysql-using-pg2mysql-tool\/\" class=\"dt-btn-s dt-btn post-details details-type-btn\" aria-label=\"Read more about Database Migration from postgres to mysql using pg2mysql tool\">Read article<i class=\"dt-icon-the7-arrow-03\" aria-hidden=\"true\"><\/i><\/a>\n\n<\/div><\/article><article class=\"post project-odd hidden post-2757 type-post status-publish format-standard has-post-thumbnail hentry category-postgresql tag-aurora tag-aurora-postgresql tag-aws tag-database tag-database-administration tag-io-issues tag-limits tag-network-throughput tag-postgresql tag-storage tag-troubleshooting tag-troubleshooting-io-issues-aurora-postgresql-storage-network-throughput-limits category-28 description-off\" data-name=\"Troubleshooting IO Issues in Aurora PostgreSQL: Understanding StorageNetworkThroughput Limits\" data-date=\"2025-01-06T14:21:21+00:00\">\n\n<div class=\"post-thumbnail-wrap\">\n\t<div class=\"post-thumbnail\">\n\n\t\t\n\t\t\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2025\/01\/06\/troubleshooting-io-issues-in-aurora-postgresql-understanding-storagenetworkthroughput-limits\/\" class=\"post-thumbnail-rollover layzr-bg layzr-bg\" ><img decoding=\"async\" class=\"blog-thumb-lazy-load preload-me lazy-load aspect\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D&#39;http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg&#39;%20viewBox%3D&#39;0%200%20768%20512&#39;%2F%3E\" data-src=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2025\/01\/Troubleshooting-IO-Issues-in-Aurora-PostgreSQL_-Understanding-StorageNetworkThroughput-Limits-768x512.jpg\" data-srcset=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2025\/01\/Troubleshooting-IO-Issues-in-Aurora-PostgreSQL_-Understanding-StorageNetworkThroughput-Limits-768x512.jpg 768w, https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2025\/01\/Troubleshooting-IO-Issues-in-Aurora-PostgreSQL_-Understanding-StorageNetworkThroughput-Limits-1024x682.jpg 1024w\" loading=\"eager\" style=\"--ratio: 768 \/ 512\" sizes=\"(max-width: 768px) 100vw, 768px\" alt=\"aurora postgresql\" title=\"Troubleshooting IO Issues in Aurora PostgreSQL_ Understanding StorageNetworkThroughput Limits\" width=\"768\" height=\"512\"  \/><\/a>\n\t<\/div>\n<\/div>\n\n\n<div class=\"post-entry-content\">\n\n\t<h3 class=\"entry-title\">\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2025\/01\/06\/troubleshooting-io-issues-in-aurora-postgresql-understanding-storagenetworkthroughput-limits\/\" title=\"Troubleshooting IO Issues in Aurora PostgreSQL: Understanding StorageNetworkThroughput Limits\" rel=\"bookmark\">Troubleshooting IO Issues in Aurora PostgreSQL: Understanding StorageNetworkThroughput Limits<\/a>\n\t<\/h3>\n\n\t<div class=\"entry-meta\"><span class=\"category-link\"><a href=\"https:\/\/divaind.com\/ie1\/category\/postgresql\/\" >Postgresql<\/a><\/span><a href=\"https:\/\/divaind.com\/ie1\/2025\/01\/06\/\" title=\"2:21 pm\" class=\"data-link\" rel=\"bookmark\"><time class=\"entry-date updated\" datetime=\"2025-01-06T14:21:21+00:00\">January 6, 2025<\/time><\/a><a href=\"https:\/\/divaind.com\/ie1\/2025\/01\/06\/troubleshooting-io-issues-in-aurora-postgresql-understanding-storagenetworkthroughput-limits\/#comments\" class=\"comment-link\" >1 Comment<\/a><\/div>\n\t<div class=\"entry-excerpt\"><p>Overview of Aurora PostgreSQL Storage and Throughput Aurora PostgreSQL is a robust, cloud-native database solution known for its scalability, high availability, and managed services. One&hellip;<\/p>\n<\/div>\n\t\n<a href=\"https:\/\/divaind.com\/ie1\/2025\/01\/06\/troubleshooting-io-issues-in-aurora-postgresql-understanding-storagenetworkthroughput-limits\/\" class=\"dt-btn-s dt-btn post-details details-type-btn\" aria-label=\"Read more about Troubleshooting IO Issues in Aurora PostgreSQL: Understanding StorageNetworkThroughput Limits\">Read article<i class=\"dt-icon-the7-arrow-03\" aria-hidden=\"true\"><\/i><\/a>\n\n<\/div><\/article><article class=\"post project-odd hidden post-2745 type-post status-publish format-standard has-post-thumbnail hentry category-mysql category-performance-tuning tag-databasereplication tag-mysql8 tag-sysadmin tag-techsetup tag-centos tag-databasemanagement tag-mysql category-24 category-26 description-off\" data-name=\"MySQL Replication System on CentOS 8 with MySQL 8.0\" data-date=\"2024-12-17T11:05:00+00:00\">\n\n<div class=\"post-thumbnail-wrap\">\n\t<div class=\"post-thumbnail\">\n\n\t\t\n\t\t\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2024\/12\/17\/mysql-replication-system-on-centos-8-with-mysql-8-0\/\" class=\"post-thumbnail-rollover layzr-bg layzr-bg\" ><img decoding=\"async\" class=\"blog-thumb-lazy-load preload-me lazy-load aspect\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D&#39;http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg&#39;%20viewBox%3D&#39;0%200%20768%20512&#39;%2F%3E\" data-src=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2024\/12\/MySQL-Replication-System-on-CentOS-8-with-MySQL-8.0-768x512.jpg\" data-srcset=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2024\/12\/MySQL-Replication-System-on-CentOS-8-with-MySQL-8.0-768x512.jpg 768w, https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2024\/12\/MySQL-Replication-System-on-CentOS-8-with-MySQL-8.0-1024x682.jpg 1024w\" loading=\"eager\" style=\"--ratio: 768 \/ 512\" sizes=\"(max-width: 768px) 100vw, 768px\" alt=\"\" title=\"MySQL Replication System on CentOS 8 with MySQL 8.0\" width=\"768\" height=\"512\"  \/><\/a>\n\t<\/div>\n<\/div>\n\n\n<div class=\"post-entry-content\">\n\n\t<h3 class=\"entry-title\">\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2024\/12\/17\/mysql-replication-system-on-centos-8-with-mysql-8-0\/\" title=\"MySQL Replication System on CentOS 8 with MySQL 8.0\" rel=\"bookmark\">MySQL Replication System on CentOS 8 with MySQL 8.0<\/a>\n\t<\/h3>\n\n\t<div class=\"entry-meta\"><span class=\"category-link\"><a href=\"https:\/\/divaind.com\/ie1\/category\/mysql\/\" >MYSQL<\/a>, <a href=\"https:\/\/divaind.com\/ie1\/category\/performance-tuning\/\" >Performance Tuning<\/a><\/span><a href=\"https:\/\/divaind.com\/ie1\/2024\/12\/17\/\" title=\"11:05 am\" class=\"data-link\" rel=\"bookmark\"><time class=\"entry-date updated\" datetime=\"2024-12-17T11:05:00+00:00\">December 17, 2024<\/time><\/a><a href=\"https:\/\/divaind.com\/ie1\/2024\/12\/17\/mysql-replication-system-on-centos-8-with-mysql-8-0\/#respond\" class=\"comment-link\" >Leave a comment<\/a><\/div>\n\t<div class=\"entry-excerpt\"><p>MySQL replication is a process of copying data changes from a primary server (master) to one or more secondary servers (slaves). This creates a redundant&hellip;<\/p>\n<\/div>\n\t\n<a href=\"https:\/\/divaind.com\/ie1\/2024\/12\/17\/mysql-replication-system-on-centos-8-with-mysql-8-0\/\" class=\"dt-btn-s dt-btn post-details details-type-btn\" aria-label=\"Read more about MySQL Replication System on CentOS 8 with MySQL 8.0\">Read article<i class=\"dt-icon-the7-arrow-03\" aria-hidden=\"true\"><\/i><\/a>\n\n<\/div><\/article><article class=\"post project-odd hidden post-2733 type-post status-publish format-standard has-post-thumbnail hentry category-mysql tag-databaseloadbalancing tag-databaseperformance tag-databasescaling tag-haproxy tag-itinfrastructure tag-loadbalancing tag-mysql8 tag-scalability tag-servermanagement tag-sqltips tag-techblog tag-techtips tag-highavailability tag-mysql tag-mysqlperformance category-24 description-off\" data-name=\"Load balancing in mysql 8.0 using HAPROXY\" data-date=\"2024-12-12T13:08:17+00:00\">\n\n<div class=\"post-thumbnail-wrap\">\n\t<div class=\"post-thumbnail\">\n\n\t\t\n\t\t\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2024\/12\/12\/load-balancing-in-mysql-8-0-using-haproxy\/\" class=\"post-thumbnail-rollover layzr-bg layzr-bg\" ><img decoding=\"async\" class=\"blog-thumb-lazy-load preload-me lazy-load aspect\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D&#39;http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg&#39;%20viewBox%3D&#39;0%200%20768%20512&#39;%2F%3E\" data-src=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2024\/12\/Load-balancing-in-MySQL-8.0-using-HAProxy-768x512.jpg\" data-srcset=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2024\/12\/Load-balancing-in-MySQL-8.0-using-HAProxy-768x512.jpg 768w, https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2024\/12\/Load-balancing-in-MySQL-8.0-using-HAProxy-1024x682.jpg 1024w\" loading=\"eager\" style=\"--ratio: 768 \/ 512\" sizes=\"(max-width: 768px) 100vw, 768px\" alt=\"\" title=\"Load balancing in MySQL 8.0 using HAProxy\" width=\"768\" height=\"512\"  \/><\/a>\n\t<\/div>\n<\/div>\n\n\n<div class=\"post-entry-content\">\n\n\t<h3 class=\"entry-title\">\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2024\/12\/12\/load-balancing-in-mysql-8-0-using-haproxy\/\" title=\"Load balancing in mysql 8.0 using HAPROXY\" rel=\"bookmark\">Load balancing in mysql 8.0 using HAPROXY<\/a>\n\t<\/h3>\n\n\t<div class=\"entry-meta\"><span class=\"category-link\"><a href=\"https:\/\/divaind.com\/ie1\/category\/mysql\/\" >MYSQL<\/a><\/span><a href=\"https:\/\/divaind.com\/ie1\/2024\/12\/12\/\" title=\"1:08 pm\" class=\"data-link\" rel=\"bookmark\"><time class=\"entry-date updated\" datetime=\"2024-12-12T13:08:17+00:00\">December 12, 2024<\/time><\/a><a href=\"https:\/\/divaind.com\/ie1\/2024\/12\/12\/load-balancing-in-mysql-8-0-using-haproxy\/#respond\" class=\"comment-link\" >Leave a comment<\/a><\/div>\n\t<div class=\"entry-excerpt\"><p>Introduction to HAPROXY: HAProxy, or High Availability Proxy, is an open-source load balancer and proxy server for TCP and HTTP applications. It&#8217;s well-known for its&hellip;<\/p>\n<\/div>\n\t\n<a href=\"https:\/\/divaind.com\/ie1\/2024\/12\/12\/load-balancing-in-mysql-8-0-using-haproxy\/\" class=\"dt-btn-s dt-btn post-details details-type-btn\" aria-label=\"Read more about Load balancing in mysql 8.0 using HAPROXY\">Read article<i class=\"dt-icon-the7-arrow-03\" aria-hidden=\"true\"><\/i><\/a>\n\n<\/div><\/article><article class=\"post project-odd hidden post-2723 type-post status-publish format-standard has-post-thumbnail hentry category-postgresql tag-databaseoptimization tag-dataoptimization tag-dbms tag-performanceimprovement tag-performancetuning tag-postgresqlperformance tag-postgresqltips tag-sqlperformance tag-techblog tag-temporarytables tag-unloggedtables tag-catalogbloat tag-database-administration tag-databasemanagement tag-postgresql category-28 description-off\" data-name=\"Stop Catalog Bloat: Boost PostgreSQL Performance by Replacing Temporary Tables\" data-date=\"2024-12-12T11:24:58+00:00\">\n\n<div class=\"post-thumbnail-wrap\">\n\t<div class=\"post-thumbnail\">\n\n\t\t\n\t\t\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2024\/12\/12\/stop-catalog-bloat-boost-postgresql-performance-by-replacing-temporary-tables\/\" class=\"post-thumbnail-rollover layzr-bg layzr-bg\" ><img decoding=\"async\" class=\"blog-thumb-lazy-load preload-me lazy-load aspect\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D&#39;http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg&#39;%20viewBox%3D&#39;0%200%20768%20512&#39;%2F%3E\" data-src=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2024\/12\/simple-PostgreSQL-database-image-for-Boost-PostgreSQL-Performance-by-Replacing-Temporary-Tables-768x512.jpg\" data-srcset=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2024\/12\/simple-PostgreSQL-database-image-for-Boost-PostgreSQL-Performance-by-Replacing-Temporary-Tables-768x512.jpg 768w, https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2024\/12\/simple-PostgreSQL-database-image-for-Boost-PostgreSQL-Performance-by-Replacing-Temporary-Tables-1024x682.jpg 1024w\" loading=\"eager\" style=\"--ratio: 768 \/ 512\" sizes=\"(max-width: 768px) 100vw, 768px\" alt=\"\" title=\"simple PostgreSQL database image for Boost PostgreSQL Performance by Replacing Temporary Tables\" width=\"768\" height=\"512\"  \/><\/a>\n\t<\/div>\n<\/div>\n\n\n<div class=\"post-entry-content\">\n\n\t<h3 class=\"entry-title\">\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2024\/12\/12\/stop-catalog-bloat-boost-postgresql-performance-by-replacing-temporary-tables\/\" title=\"Stop Catalog Bloat: Boost PostgreSQL Performance by Replacing Temporary Tables\" rel=\"bookmark\">Stop Catalog Bloat: Boost PostgreSQL Performance by Replacing Temporary Tables<\/a>\n\t<\/h3>\n\n\t<div class=\"entry-meta\"><span class=\"category-link\"><a href=\"https:\/\/divaind.com\/ie1\/category\/postgresql\/\" >Postgresql<\/a><\/span><a href=\"https:\/\/divaind.com\/ie1\/2024\/12\/12\/\" title=\"11:24 am\" class=\"data-link\" rel=\"bookmark\"><time class=\"entry-date updated\" datetime=\"2024-12-12T11:24:58+00:00\">December 12, 2024<\/time><\/a><a href=\"https:\/\/divaind.com\/ie1\/2024\/12\/12\/stop-catalog-bloat-boost-postgresql-performance-by-replacing-temporary-tables\/#respond\" class=\"comment-link\" >Leave a comment<\/a><\/div>\n\t<div class=\"entry-excerpt\"><p>Recently, we encountered an issue where catalog queries executed by the drivers during session creation were taking significantly longer than expected. These queries, managed by&hellip;<\/p>\n<\/div>\n\t\n<a href=\"https:\/\/divaind.com\/ie1\/2024\/12\/12\/stop-catalog-bloat-boost-postgresql-performance-by-replacing-temporary-tables\/\" class=\"dt-btn-s dt-btn post-details details-type-btn\" aria-label=\"Read more about Stop Catalog Bloat: Boost PostgreSQL Performance by Replacing Temporary Tables\">Read article<i class=\"dt-icon-the7-arrow-03\" aria-hidden=\"true\"><\/i><\/a>\n\n<\/div><\/article><article class=\"post project-odd hidden post-2711 type-post status-publish format-standard has-post-thumbnail hentry category-mysql tag-automaticfailover tag-centos8 tag-databaseclustering tag-databasemanagement tag-databasereliability tag-dataintegrity tag-highavailability tag-innodbcluster tag-mysql8-0 tag-mysqlconfiguration tag-mysqlperformance tag-mysqlreplication tag-mysqlsetup tag-scalabledatabases tag-serverclustering category-24 description-off\" data-name=\"High Availability in MySQL 8.0 using INNODB Cluster in CentOS-08\" data-date=\"2024-11-11T05:14:53+00:00\">\n\n<div class=\"post-thumbnail-wrap\">\n\t<div class=\"post-thumbnail\">\n\n\t\t\n\t\t\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2024\/11\/11\/high-availability-in-mysql-8-0-using-innodb-cluster-in-centos-08\/\" class=\"post-thumbnail-rollover layzr-bg layzr-bg\" ><img decoding=\"async\" class=\"blog-thumb-lazy-load preload-me lazy-load aspect\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D&#39;http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg&#39;%20viewBox%3D&#39;0%200%20768%20512&#39;%2F%3E\" data-src=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2024\/11\/th-1-768x512.jpg\" data-srcset=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2024\/11\/th-1-768x512.jpg 768w, https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2024\/11\/th-1-1024x682.jpg 1024w\" loading=\"eager\" style=\"--ratio: 768 \/ 512\" sizes=\"(max-width: 768px) 100vw, 768px\" alt=\"\" title=\"th (1)\" width=\"768\" height=\"512\"  \/><\/a>\n\t<\/div>\n<\/div>\n\n\n<div class=\"post-entry-content\">\n\n\t<h3 class=\"entry-title\">\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2024\/11\/11\/high-availability-in-mysql-8-0-using-innodb-cluster-in-centos-08\/\" title=\"High Availability in MySQL 8.0 using INNODB Cluster in CentOS-08\" rel=\"bookmark\">High Availability in MySQL 8.0 using INNODB Cluster in CentOS-08<\/a>\n\t<\/h3>\n\n\t<div class=\"entry-meta\"><span class=\"category-link\"><a href=\"https:\/\/divaind.com\/ie1\/category\/mysql\/\" >MYSQL<\/a><\/span><a href=\"https:\/\/divaind.com\/ie1\/2024\/11\/11\/\" title=\"5:14 am\" class=\"data-link\" rel=\"bookmark\"><time class=\"entry-date updated\" datetime=\"2024-11-11T05:14:53+00:00\">November 11, 2024<\/time><\/a><a href=\"https:\/\/divaind.com\/ie1\/2024\/11\/11\/high-availability-in-mysql-8-0-using-innodb-cluster-in-centos-08\/#respond\" class=\"comment-link\" >Leave a comment<\/a><\/div>\n\t<div class=\"entry-excerpt\"><p>High Availability (HA) in MySQL refers to a collection of options and solutions meant to keep the MySQL database system operational even during times of&hellip;<\/p>\n<\/div>\n\t\n<a href=\"https:\/\/divaind.com\/ie1\/2024\/11\/11\/high-availability-in-mysql-8-0-using-innodb-cluster-in-centos-08\/\" class=\"dt-btn-s dt-btn post-details details-type-btn\" aria-label=\"Read more about High Availability in MySQL 8.0 using INNODB Cluster in CentOS-08\">Read article<i class=\"dt-icon-the7-arrow-03\" aria-hidden=\"true\"><\/i><\/a>\n\n<\/div><\/article><article class=\"post project-odd hidden post-2697 type-post status-publish format-standard has-post-thumbnail hentry category-postgresql tag-incremental-backups tag-postgresql category-28 description-off\" data-name=\"PostgreSQL 17&#8217;s New Backup Feature: Incremental Backups\" data-date=\"2024-11-05T02:41:36+00:00\">\n\n<div class=\"post-thumbnail-wrap\">\n\t<div class=\"post-thumbnail\">\n\n\t\t\n\t\t\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2024\/11\/05\/postgresql-17s-new-backup-feature-incremental-backups\/\" class=\"post-thumbnail-rollover layzr-bg layzr-bg\" ><img decoding=\"async\" class=\"blog-thumb-lazy-load preload-me lazy-load aspect\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D&#39;http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg&#39;%20viewBox%3D&#39;0%200%20768%20512&#39;%2F%3E\" data-src=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2024\/11\/Leonardo_Phoenix_Create_an_image_featuring_an_elephant_symboli_0-768x512.jpg\" data-srcset=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2024\/11\/Leonardo_Phoenix_Create_an_image_featuring_an_elephant_symboli_0-768x512.jpg 768w, https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2024\/11\/Leonardo_Phoenix_Create_an_image_featuring_an_elephant_symboli_0-1120x746.jpg 1120w\" loading=\"eager\" style=\"--ratio: 768 \/ 512\" sizes=\"(max-width: 768px) 100vw, 768px\" alt=\"\" title=\"Leonardo_Phoenix_Create_an_image_featuring_an_elephant_symboli_0.jpg\" width=\"768\" height=\"512\"  \/><\/a>\n\t<\/div>\n<\/div>\n\n\n<div class=\"post-entry-content\">\n\n\t<h3 class=\"entry-title\">\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2024\/11\/05\/postgresql-17s-new-backup-feature-incremental-backups\/\" title=\"PostgreSQL 17&#8217;s New Backup Feature: Incremental Backups\" rel=\"bookmark\">PostgreSQL 17&#8217;s New Backup Feature: Incremental Backups<\/a>\n\t<\/h3>\n\n\t<div class=\"entry-meta\"><span class=\"category-link\"><a href=\"https:\/\/divaind.com\/ie1\/category\/postgresql\/\" >Postgresql<\/a><\/span><a href=\"https:\/\/divaind.com\/ie1\/2024\/11\/05\/\" title=\"2:41 am\" class=\"data-link\" rel=\"bookmark\"><time class=\"entry-date updated\" datetime=\"2024-11-05T02:41:36+00:00\">November 5, 2024<\/time><\/a><a href=\"https:\/\/divaind.com\/ie1\/2024\/11\/05\/postgresql-17s-new-backup-feature-incremental-backups\/#respond\" class=\"comment-link\" >Leave a comment<\/a><\/div>\n\t<div class=\"entry-excerpt\"><p>Introduction With the release of PostgreSQL 17, a game-changing feature has arrived: incremental backups. In prior versions, such as PostgreSQL 16 and earlier, users could&hellip;<\/p>\n<\/div>\n\t\n<a href=\"https:\/\/divaind.com\/ie1\/2024\/11\/05\/postgresql-17s-new-backup-feature-incremental-backups\/\" class=\"dt-btn-s dt-btn post-details details-type-btn\" aria-label=\"Read more about PostgreSQL 17&#8217;s New Backup Feature: Incremental Backups\">Read article<i class=\"dt-icon-the7-arrow-03\" aria-hidden=\"true\"><\/i><\/a>\n\n<\/div><\/article><article class=\"post project-odd hidden post-2690 type-post status-publish format-standard has-post-thumbnail hentry category-mysql tag-database-pitr-techniques tag-database-recovery-mysql tag-mysql-pitr-guide tag-mysql-pitr-tutorial tag-point-in-time-recovery-mysql category-24 description-off\" data-name=\"Protect Your Data with Point-In-Time Recovery (PITR) in MySQL\" data-date=\"2024-11-04T04:02:36+00:00\">\n\n<div class=\"post-thumbnail-wrap\">\n\t<div class=\"post-thumbnail\">\n\n\t\t\n\t\t\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2024\/11\/04\/protect-your-data-with-point-in-time-recovery-pitr-in-mysql\/\" class=\"post-thumbnail-rollover layzr-bg layzr-bg\" ><img decoding=\"async\" class=\"blog-thumb-lazy-load preload-me lazy-load aspect\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D&#39;http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg&#39;%20viewBox%3D&#39;0%200%20768%20512&#39;%2F%3E\" data-src=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2024\/11\/th-768x512.jpg\" data-srcset=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2024\/11\/th-768x512.jpg 768w, https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2024\/11\/th-1024x682.jpg 1024w\" loading=\"eager\" style=\"--ratio: 768 \/ 512\" sizes=\"(max-width: 768px) 100vw, 768px\" alt=\"\" title=\"th.jpg\" width=\"768\" height=\"512\"  \/><\/a>\n\t<\/div>\n<\/div>\n\n\n<div class=\"post-entry-content\">\n\n\t<h3 class=\"entry-title\">\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2024\/11\/04\/protect-your-data-with-point-in-time-recovery-pitr-in-mysql\/\" title=\"Protect Your Data with Point-In-Time Recovery (PITR) in MySQL\" rel=\"bookmark\">Protect Your Data with Point-In-Time Recovery (PITR) in MySQL<\/a>\n\t<\/h3>\n\n\t<div class=\"entry-meta\"><span class=\"category-link\"><a href=\"https:\/\/divaind.com\/ie1\/category\/mysql\/\" >MYSQL<\/a><\/span><a href=\"https:\/\/divaind.com\/ie1\/2024\/11\/04\/\" title=\"4:02 am\" class=\"data-link\" rel=\"bookmark\"><time class=\"entry-date updated\" datetime=\"2024-11-04T04:02:36+00:00\">November 4, 2024<\/time><\/a><a href=\"https:\/\/divaind.com\/ie1\/2024\/11\/04\/protect-your-data-with-point-in-time-recovery-pitr-in-mysql\/#respond\" class=\"comment-link\" >Leave a comment<\/a><\/div>\n\t<div class=\"entry-excerpt\"><p>Point-in-time recovery (PITR) helps to recover data from unintentional deletions and modifications. Ways to recover the data Recover the complete database, backup or export it&hellip;<\/p>\n<\/div>\n\t\n<a href=\"https:\/\/divaind.com\/ie1\/2024\/11\/04\/protect-your-data-with-point-in-time-recovery-pitr-in-mysql\/\" class=\"dt-btn-s dt-btn post-details details-type-btn\" aria-label=\"Read more about Protect Your Data with Point-In-Time Recovery (PITR) in MySQL\">Read article<i class=\"dt-icon-the7-arrow-03\" aria-hidden=\"true\"><\/i><\/a>\n\n<\/div><\/article><article class=\"post project-odd hidden post-2685 type-post status-publish format-standard has-post-thumbnail hentry category-mysql tag-centos-mysql-upgrade tag-database-migration tag-mysql-5-7-to-8-0 tag-mysql-8-0-installation tag-mysql-best-practices tag-mysql-performance-tuning tag-mysql-upgrade tag-mysql-version-upgrade tag-tech-blog category-24 description-off\" data-name=\"Mysql Major Version upgrade from 5.7.44 to 8.0.40 in Centos08\" data-date=\"2024-10-31T06:27:26+00:00\">\n\n<div class=\"post-thumbnail-wrap\">\n\t<div class=\"post-thumbnail\">\n\n\t\t\n\t\t\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2024\/10\/31\/mysql-major-version-upgrade-from-5-7-44-to-8-0-40-in-centos08\/\" class=\"post-thumbnail-rollover layzr-bg layzr-bg\" ><img decoding=\"async\" class=\"blog-thumb-lazy-load preload-me lazy-load aspect\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D&#39;http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg&#39;%20viewBox%3D&#39;0%200%20400%20266&#39;%2F%3E\" data-src=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2024\/10\/mysql-image-wULQAenZzGYR-400x266.png\" data-srcset=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2024\/10\/mysql-image-wULQAenZzGYR-400x266.png 400w\" loading=\"eager\" style=\"--ratio: 400 \/ 266\" sizes=\"(max-width: 400px) 100vw, 400px\" alt=\"\" title=\"mysql-image.png\" width=\"400\" height=\"266\"  \/><\/a>\n\t<\/div>\n<\/div>\n\n\n<div class=\"post-entry-content\">\n\n\t<h3 class=\"entry-title\">\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2024\/10\/31\/mysql-major-version-upgrade-from-5-7-44-to-8-0-40-in-centos08\/\" title=\"Mysql Major Version upgrade from 5.7.44 to 8.0.40 in Centos08\" rel=\"bookmark\">Mysql Major Version upgrade from 5.7.44 to 8.0.40 in Centos08<\/a>\n\t<\/h3>\n\n\t<div class=\"entry-meta\"><span class=\"category-link\"><a href=\"https:\/\/divaind.com\/ie1\/category\/mysql\/\" >MYSQL<\/a><\/span><a href=\"https:\/\/divaind.com\/ie1\/2024\/10\/31\/\" title=\"6:27 am\" class=\"data-link\" rel=\"bookmark\"><time class=\"entry-date updated\" datetime=\"2024-10-31T06:27:26+00:00\">October 31, 2024<\/time><\/a><a href=\"https:\/\/divaind.com\/ie1\/2024\/10\/31\/mysql-major-version-upgrade-from-5-7-44-to-8-0-40-in-centos08\/#respond\" class=\"comment-link\" >Leave a comment<\/a><\/div>\n\t<div class=\"entry-excerpt\"><p>Overview of Changes from MySQL 5.7.44 to 8.0.39 Version The upgrade from MySQL 5.7.44 to 8.0.39 includes major additions and changes which affect safety, performance,&hellip;<\/p>\n<\/div>\n\t\n<a href=\"https:\/\/divaind.com\/ie1\/2024\/10\/31\/mysql-major-version-upgrade-from-5-7-44-to-8-0-40-in-centos08\/\" class=\"dt-btn-s dt-btn post-details details-type-btn\" aria-label=\"Read more about Mysql Major Version upgrade from 5.7.44 to 8.0.40 in Centos08\">Read article<i class=\"dt-icon-the7-arrow-03\" aria-hidden=\"true\"><\/i><\/a>\n\n<\/div><\/article><article class=\"post project-odd hidden post-2677 type-post status-publish format-standard has-post-thumbnail hentry category-mysql tag-8-0-26 tag-8-0-39 tag-aurora tag-aws tag-database-performance tag-information_schema-innodb_locks-removed-mysql-8-0 tag-minor-version-upgrade tag-mysql tag-mysql-8-0-26-to-8-0-39 tag-mysql-upgrade-on-centos08 tag-online-mysql category-24 description-off\" data-name=\"MySQL Minor Version upgrade from 8.0.26 to 8.0.39\" data-date=\"2024-10-07T13:37:35+00:00\">\n\n<div class=\"post-thumbnail-wrap\">\n\t<div class=\"post-thumbnail\">\n\n\t\t\n\t\t\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2024\/10\/07\/mysql-minor-version-upgrade-from-8-0-26-to-8-0-39\/\" class=\"post-thumbnail-rollover layzr-bg layzr-bg\" ><img decoding=\"async\" class=\"blog-thumb-lazy-load preload-me lazy-load aspect\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D&#39;http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg&#39;%20viewBox%3D&#39;0%200%20400%20266&#39;%2F%3E\" data-src=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2024\/10\/mysql-image-400x266.png\" data-srcset=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2024\/10\/mysql-image-400x266.png 400w\" loading=\"eager\" style=\"--ratio: 400 \/ 266\" sizes=\"(max-width: 400px) 100vw, 400px\" alt=\"\" title=\"mysql-image.png\" width=\"400\" height=\"266\"  \/><\/a>\n\t<\/div>\n<\/div>\n\n\n<div class=\"post-entry-content\">\n\n\t<h3 class=\"entry-title\">\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2024\/10\/07\/mysql-minor-version-upgrade-from-8-0-26-to-8-0-39\/\" title=\"MySQL Minor Version upgrade from 8.0.26 to 8.0.39\" rel=\"bookmark\">MySQL Minor Version upgrade from 8.0.26 to 8.0.39<\/a>\n\t<\/h3>\n\n\t<div class=\"entry-meta\"><span class=\"category-link\"><a href=\"https:\/\/divaind.com\/ie1\/category\/mysql\/\" >MYSQL<\/a><\/span><a href=\"https:\/\/divaind.com\/ie1\/2024\/10\/07\/\" title=\"1:37 pm\" class=\"data-link\" rel=\"bookmark\"><time class=\"entry-date updated\" datetime=\"2024-10-07T13:37:35+00:00\">October 7, 2024<\/time><\/a><a href=\"https:\/\/divaind.com\/ie1\/2024\/10\/07\/mysql-minor-version-upgrade-from-8-0-26-to-8-0-39\/#respond\" class=\"comment-link\" >Leave a comment<\/a><\/div>\n\t<div class=\"entry-excerpt\"><p>Comparison of mysql versions 8.0.26 to 8.0.39 for Minor Version Upgrade Learn how to perform a MySQL Minor Version Upgrade from 8.0.26 to 8.0.39 to&hellip;<\/p>\n<\/div>\n\t\n<a href=\"https:\/\/divaind.com\/ie1\/2024\/10\/07\/mysql-minor-version-upgrade-from-8-0-26-to-8-0-39\/\" class=\"dt-btn-s dt-btn post-details details-type-btn\" aria-label=\"Read more about MySQL Minor Version upgrade from 8.0.26 to 8.0.39\">Read article<i class=\"dt-icon-the7-arrow-03\" aria-hidden=\"true\"><\/i><\/a>\n\n<\/div><\/article><article class=\"post project-odd hidden post-2668 type-post status-publish format-standard has-post-thumbnail hentry category-postgresql tag-postgresql-postgres17-pg17-postgres-database category-28 description-off\" data-name=\"What\u2019s New in PostgreSQL 17: Essential Updates for DBAs and Developers\" data-date=\"2024-09-09T11:47:22+00:00\">\n\n<div class=\"post-thumbnail-wrap\">\n\t<div class=\"post-thumbnail\">\n\n\t\t\n\t\t\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2024\/09\/09\/whats-new-in-postgresql-17-essential-updates-for-dbas-and-developers\/\" class=\"post-thumbnail-rollover layzr-bg layzr-bg\" ><img decoding=\"async\" class=\"blog-thumb-lazy-load preload-me lazy-load aspect\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D&#39;http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg&#39;%20viewBox%3D&#39;0%200%20256%20170&#39;%2F%3E\" data-src=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2023\/01\/osdb-3-256x170.webp\" data-srcset=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2023\/01\/osdb-3-256x170.webp 256w\" loading=\"eager\" style=\"--ratio: 256 \/ 170\" sizes=\"(max-width: 256px) 100vw, 256px\" alt=\"\" title=\"osdb-3\" width=\"256\" height=\"170\"  \/><\/a>\n\t<\/div>\n<\/div>\n\n\n<div class=\"post-entry-content\">\n\n\t<h3 class=\"entry-title\">\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2024\/09\/09\/whats-new-in-postgresql-17-essential-updates-for-dbas-and-developers\/\" title=\"What\u2019s New in PostgreSQL 17: Essential Updates for DBAs and Developers\" rel=\"bookmark\">What\u2019s New in PostgreSQL 17: Essential Updates for DBAs and Developers<\/a>\n\t<\/h3>\n\n\t<div class=\"entry-meta\"><span class=\"category-link\"><a href=\"https:\/\/divaind.com\/ie1\/category\/postgresql\/\" >Postgresql<\/a><\/span><a href=\"https:\/\/divaind.com\/ie1\/2024\/09\/09\/\" title=\"11:47 am\" class=\"data-link\" rel=\"bookmark\"><time class=\"entry-date updated\" datetime=\"2024-09-09T11:47:22+00:00\">September 9, 2024<\/time><\/a><a href=\"https:\/\/divaind.com\/ie1\/2024\/09\/09\/whats-new-in-postgresql-17-essential-updates-for-dbas-and-developers\/#respond\" class=\"comment-link\" >Leave a comment<\/a><\/div>\n\t<div class=\"entry-excerpt\"><p>The PostgreSQL Global Community team released the PostgreSQL 17 RC1. We\u2019re excited to share a glimpse of some of the key features coming in PostgreSQL&hellip;<\/p>\n<\/div>\n\t\n<a href=\"https:\/\/divaind.com\/ie1\/2024\/09\/09\/whats-new-in-postgresql-17-essential-updates-for-dbas-and-developers\/\" class=\"dt-btn-s dt-btn post-details details-type-btn\" aria-label=\"Read more about What\u2019s New in PostgreSQL 17: Essential Updates for DBAs and Developers\">Read article<i class=\"dt-icon-the7-arrow-03\" aria-hidden=\"true\"><\/i><\/a>\n\n<\/div><\/article><article class=\"post project-odd hidden no-img post-2663 type-post status-publish format-standard hentry category-mysql category-performance-tuning category-24 category-26 description-off\" data-name=\"Optimizing MySQL: Essential Parameters You Need to Know\" data-date=\"2024-09-09T04:05:24+00:00\">\n\n<div class=\"post-entry-content\">\n\n\t<h3 class=\"entry-title\">\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2024\/09\/09\/optimizing-mysql-essential-parameters-you-need-to-know\/\" title=\"Optimizing MySQL: Essential Parameters You Need to Know\" rel=\"bookmark\">Optimizing MySQL: Essential Parameters You Need to Know<\/a>\n\t<\/h3>\n\n\t<div class=\"entry-meta\"><span class=\"category-link\"><a href=\"https:\/\/divaind.com\/ie1\/category\/mysql\/\" >MYSQL<\/a>, <a href=\"https:\/\/divaind.com\/ie1\/category\/performance-tuning\/\" >Performance Tuning<\/a><\/span><a href=\"https:\/\/divaind.com\/ie1\/2024\/09\/09\/\" title=\"4:05 am\" class=\"data-link\" rel=\"bookmark\"><time class=\"entry-date updated\" datetime=\"2024-09-09T04:05:24+00:00\">September 9, 2024<\/time><\/a><a href=\"https:\/\/divaind.com\/ie1\/2024\/09\/09\/optimizing-mysql-essential-parameters-you-need-to-know\/#respond\" class=\"comment-link\" >Leave a comment<\/a><\/div>\n\t<div class=\"entry-excerpt\"><p>It is essential to optimize MySQL parameters to make sure your database operates effectively, particularly when it is under a lot of stress. A few&hellip;<\/p>\n<\/div>\n\t\n<a href=\"https:\/\/divaind.com\/ie1\/2024\/09\/09\/optimizing-mysql-essential-parameters-you-need-to-know\/\" class=\"dt-btn-s dt-btn post-details details-type-btn\" aria-label=\"Read more about Optimizing MySQL: Essential Parameters You Need to Know\">Read article<i class=\"dt-icon-the7-arrow-03\" aria-hidden=\"true\"><\/i><\/a>\n\n<\/div><\/article><article class=\"post project-odd hidden post-2652 type-post status-publish format-standard has-post-thumbnail hentry category-mysql tag-apache tag-it-sectors tag-linux tag-mysql tag-mysql-architecture tag-perl tag-php tag-python category-24 description-off\" data-name=\"Layers of MySQL Architecture\" data-date=\"2024-09-02T15:02:21+00:00\">\n\n<div class=\"post-thumbnail-wrap\">\n\t<div class=\"post-thumbnail\">\n\n\t\t\n\t\t\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2024\/09\/02\/layers-of-mysql-architecture\/\" class=\"post-thumbnail-rollover layzr-bg layzr-bg\" ><img decoding=\"async\" class=\"blog-thumb-lazy-load preload-me lazy-load aspect\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D&#39;http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg&#39;%20viewBox%3D&#39;0%200%20484%20322&#39;%2F%3E\" data-src=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2024\/09\/WhatsApp-Image-2024-09-02-at-09.59.39_97dc86df-z679uni0abC1-484x322.jpg\" data-srcset=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2024\/09\/WhatsApp-Image-2024-09-02-at-09.59.39_97dc86df-z679uni0abC1-484x322.jpg 484w\" loading=\"eager\" style=\"--ratio: 484 \/ 322\" sizes=\"(max-width: 484px) 100vw, 484px\" alt=\"mysql\" title=\"WhatsApp-Image-2024-09-02-at-09.59.39_97dc86df.jpg\" width=\"484\" height=\"322\"  \/><\/a>\n\t<\/div>\n<\/div>\n\n\n<div class=\"post-entry-content\">\n\n\t<h3 class=\"entry-title\">\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2024\/09\/02\/layers-of-mysql-architecture\/\" title=\"Layers of MySQL Architecture\" rel=\"bookmark\">Layers of MySQL Architecture<\/a>\n\t<\/h3>\n\n\t<div class=\"entry-meta\"><span class=\"category-link\"><a href=\"https:\/\/divaind.com\/ie1\/category\/mysql\/\" >MYSQL<\/a><\/span><a href=\"https:\/\/divaind.com\/ie1\/2024\/09\/02\/\" title=\"3:02 pm\" class=\"data-link\" rel=\"bookmark\"><time class=\"entry-date updated\" datetime=\"2024-09-02T15:02:21+00:00\">September 2, 2024<\/time><\/a><a href=\"https:\/\/divaind.com\/ie1\/2024\/09\/02\/layers-of-mysql-architecture\/#respond\" class=\"comment-link\" >Leave a comment<\/a><\/div>\n\t<div class=\"entry-excerpt\"><p>MySQL Architecture Explained: A Technical Overview for Database Engineers MySQL architecture is central to understanding how this relational database management system powers modern applications. MySQL&hellip;<\/p>\n<\/div>\n\t\n<a href=\"https:\/\/divaind.com\/ie1\/2024\/09\/02\/layers-of-mysql-architecture\/\" class=\"dt-btn-s dt-btn post-details details-type-btn\" aria-label=\"Read more about Layers of MySQL Architecture\">Read article<i class=\"dt-icon-the7-arrow-03\" aria-hidden=\"true\"><\/i><\/a>\n\n<\/div><\/article><article class=\"post project-odd hidden post-2644 type-post status-publish format-standard has-post-thumbnail hentry category-postgresql tag-pgsql tag-postgis tag-postgis-1-5 tag-postgresql tag-postgresql-12 tag-postgresql-9-1 tag-postgresql12 category-28 description-off\" data-name=\"Upgrading PostgreSQL and PostGIS from 9.1 to 12.20 with Legacy Extension Support\" data-date=\"2024-09-02T05:27:03+00:00\">\n\n<div class=\"post-thumbnail-wrap\">\n\t<div class=\"post-thumbnail\">\n\n\t\t\n\t\t\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2024\/09\/02\/upgrading-postgresql-and-postgis-from-9-1-to-12-20-with-legacy-extension-support\/\" class=\"post-thumbnail-rollover layzr-bg layzr-bg\" ><img decoding=\"async\" class=\"blog-thumb-lazy-load preload-me lazy-load aspect\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D&#39;http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg&#39;%20viewBox%3D&#39;0%200%20768%20512&#39;%2F%3E\" data-src=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2024\/09\/Conceptual-illustrat-768x512.png\" data-srcset=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2024\/09\/Conceptual-illustrat-768x512.png 768w, https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2024\/09\/Conceptual-illustrat-1024x682.png 1024w\" loading=\"eager\" style=\"--ratio: 768 \/ 512\" sizes=\"(max-width: 768px) 100vw, 768px\" alt=\"PostgreSQL\" title=\"Conceptual illustrat\" width=\"768\" height=\"512\"  \/><\/a>\n\t<\/div>\n<\/div>\n\n\n<div class=\"post-entry-content\">\n\n\t<h3 class=\"entry-title\">\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2024\/09\/02\/upgrading-postgresql-and-postgis-from-9-1-to-12-20-with-legacy-extension-support\/\" title=\"Upgrading PostgreSQL and PostGIS from 9.1 to 12.20 with Legacy Extension Support\" rel=\"bookmark\">Upgrading PostgreSQL and PostGIS from 9.1 to 12.20 with Legacy Extension Support<\/a>\n\t<\/h3>\n\n\t<div class=\"entry-meta\"><span class=\"category-link\"><a href=\"https:\/\/divaind.com\/ie1\/category\/postgresql\/\" >Postgresql<\/a><\/span><a href=\"https:\/\/divaind.com\/ie1\/2024\/09\/02\/\" title=\"5:27 am\" class=\"data-link\" rel=\"bookmark\"><time class=\"entry-date updated\" datetime=\"2024-09-02T05:27:03+00:00\">September 2, 2024<\/time><\/a><a href=\"https:\/\/divaind.com\/ie1\/2024\/09\/02\/upgrading-postgresql-and-postgis-from-9-1-to-12-20-with-legacy-extension-support\/#respond\" class=\"comment-link\" >Leave a comment<\/a><\/div>\n\t<div class=\"entry-excerpt\"><p>Upgrading PostgreSQL and PostGIS Recently we did an upgrade of the legacy PostgreSQL 9.1 database of 1 TB size with PostGIS 1.5 version to PostgreSQL&hellip;<\/p>\n<\/div>\n\t\n<a href=\"https:\/\/divaind.com\/ie1\/2024\/09\/02\/upgrading-postgresql-and-postgis-from-9-1-to-12-20-with-legacy-extension-support\/\" class=\"dt-btn-s dt-btn post-details details-type-btn\" aria-label=\"Read more about Upgrading PostgreSQL and PostGIS from 9.1 to 12.20 with Legacy Extension Support\">Read article<i class=\"dt-icon-the7-arrow-03\" aria-hidden=\"true\"><\/i><\/a>\n\n<\/div><\/article><article class=\"post project-odd hidden post-2633 type-post status-publish format-standard has-post-thumbnail hentry category-aws tag-aws-aurora tag-aws-cost-saving tag-aws-rds tag-rds-performance category-22 description-off\" data-name=\"Smart Ways to Slash AWS RDS\/Aurora Costs without Compromising Performance\" data-date=\"2024-08-26T15:27:30+00:00\">\n\n<div class=\"post-thumbnail-wrap\">\n\t<div class=\"post-thumbnail\">\n\n\t\t\n\t\t\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2024\/08\/26\/smart-ways-to-slash-aws-rds-aurora-costs-without-compromising-performance\/\" class=\"post-thumbnail-rollover layzr-bg layzr-bg\" ><img decoding=\"async\" class=\"blog-thumb-lazy-load preload-me lazy-load aspect\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D&#39;http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg&#39;%20viewBox%3D&#39;0%200%20768%20512&#39;%2F%3E\" data-src=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2024\/08\/DALL\u00b7E-2024-08-26-19.40.41-A-smaller-cartoon-style-AI-generated-image-illustrating-Smart-Ways-to-Slash-AWS-RDS_Aurora-Costs-without-Compromising-Performance.-The-image-should-768x512.webp\" data-srcset=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2024\/08\/DALL\u00b7E-2024-08-26-19.40.41-A-smaller-cartoon-style-AI-generated-image-illustrating-Smart-Ways-to-Slash-AWS-RDS_Aurora-Costs-without-Compromising-Performance.-The-image-should-768x512.webp 768w, https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2024\/08\/DALL\u00b7E-2024-08-26-19.40.41-A-smaller-cartoon-style-AI-generated-image-illustrating-Smart-Ways-to-Slash-AWS-RDS_Aurora-Costs-without-Compromising-Performance.-The-image-should-1024x682.webp 1024w\" loading=\"eager\" style=\"--ratio: 768 \/ 512\" sizes=\"(max-width: 768px) 100vw, 768px\" alt=\"\" title=\"DALL\u00b7E-2024-08-26-19.40.41-A-smaller-cartoon-style-AI-generated-image-illustrating-Smart-Ways-to-Slash-AWS-RDS_Aurora-Costs-without-Compromising-Performance.-The-image-should.webp\" width=\"768\" height=\"512\"  \/><\/a>\n\t<\/div>\n<\/div>\n\n\n<div class=\"post-entry-content\">\n\n\t<h3 class=\"entry-title\">\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2024\/08\/26\/smart-ways-to-slash-aws-rds-aurora-costs-without-compromising-performance\/\" title=\"Smart Ways to Slash AWS RDS\/Aurora Costs without Compromising Performance\" rel=\"bookmark\">Smart Ways to Slash AWS RDS\/Aurora Costs without Compromising Performance<\/a>\n\t<\/h3>\n\n\t<div class=\"entry-meta\"><span class=\"category-link\"><a href=\"https:\/\/divaind.com\/ie1\/category\/aws\/\" >AWS<\/a><\/span><a href=\"https:\/\/divaind.com\/ie1\/2024\/08\/26\/\" title=\"3:27 pm\" class=\"data-link\" rel=\"bookmark\"><time class=\"entry-date updated\" datetime=\"2024-08-26T15:27:30+00:00\">August 26, 2024<\/time><\/a><a href=\"https:\/\/divaind.com\/ie1\/2024\/08\/26\/smart-ways-to-slash-aws-rds-aurora-costs-without-compromising-performance\/#respond\" class=\"comment-link\" >Leave a comment<\/a><\/div>\n\t<div class=\"entry-excerpt\"><p>Amazon Relational Database Service (RDS) is a fully managed cloud-based service by AWS (Amazon Web Services) that simplifies the setup, operation, and scaling of relational&hellip;<\/p>\n<\/div>\n\t\n<a href=\"https:\/\/divaind.com\/ie1\/2024\/08\/26\/smart-ways-to-slash-aws-rds-aurora-costs-without-compromising-performance\/\" class=\"dt-btn-s dt-btn post-details details-type-btn\" aria-label=\"Read more about Smart Ways to Slash AWS RDS\/Aurora Costs without Compromising Performance\">Read article<i class=\"dt-icon-the7-arrow-03\" aria-hidden=\"true\"><\/i><\/a>\n\n<\/div><\/article><article class=\"post project-odd hidden no-img post-2619 type-post status-publish format-standard hentry category-postgresql tag-hypopg tag-performance tag-postgresql category-28 description-off\" data-name=\"Hypothetical Indexes in PostgreSQL: Enhancing Performance Without the Overhead\" data-date=\"2024-08-16T06:35:09+00:00\">\n\n<div class=\"post-entry-content\">\n\n\t<h3 class=\"entry-title\">\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2024\/08\/16\/hypothetical-indexes-in-postgresql-enhancing-performance-without-the-overhead\/\" title=\"Hypothetical Indexes in PostgreSQL: Enhancing Performance Without the Overhead\" rel=\"bookmark\">Hypothetical Indexes in PostgreSQL: Enhancing Performance Without the Overhead<\/a>\n\t<\/h3>\n\n\t<div class=\"entry-meta\"><span class=\"category-link\"><a href=\"https:\/\/divaind.com\/ie1\/category\/postgresql\/\" >Postgresql<\/a><\/span><a href=\"https:\/\/divaind.com\/ie1\/2024\/08\/16\/\" title=\"6:35 am\" class=\"data-link\" rel=\"bookmark\"><time class=\"entry-date updated\" datetime=\"2024-08-16T06:35:09+00:00\">August 16, 2024<\/time><\/a><a href=\"https:\/\/divaind.com\/ie1\/2024\/08\/16\/hypothetical-indexes-in-postgresql-enhancing-performance-without-the-overhead\/#respond\" class=\"comment-link\" >Leave a comment<\/a><\/div>\n\t<div class=\"entry-excerpt\"><p>Introduction Indexes are essential for speeding up query execution in PostgreSQL, but determining whether an index will be utilized in the execution plan can be&hellip;<\/p>\n<\/div>\n\t\n<a href=\"https:\/\/divaind.com\/ie1\/2024\/08\/16\/hypothetical-indexes-in-postgresql-enhancing-performance-without-the-overhead\/\" class=\"dt-btn-s dt-btn post-details details-type-btn\" aria-label=\"Read more about Hypothetical Indexes in PostgreSQL: Enhancing Performance Without the Overhead\">Read article<i class=\"dt-icon-the7-arrow-03\" aria-hidden=\"true\"><\/i><\/a>\n\n<\/div><\/article><article class=\"post project-odd hidden post-2581 type-post status-publish format-standard has-post-thumbnail hentry category-postgresql tag-postgresql16 tag-logical tag-postgres tag-postgres16 tag-postgresql tag-replication category-28 description-off\" data-name=\"A Glimpse into the Future: Series of What&#8217;s New in PostgreSQL16 ?\" data-date=\"2023-10-01T14:59:48+00:00\">\n\n<div class=\"post-thumbnail-wrap\">\n\t<div class=\"post-thumbnail\">\n\n\t\t\n\t\t\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2023\/10\/01\/a-glimpse-into-the-future-series-of-whats-new-in-postgresql16\/\" class=\"post-thumbnail-rollover layzr-bg layzr-bg\" ><img decoding=\"async\" class=\"blog-thumb-lazy-load preload-me lazy-load aspect\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D&#39;http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg&#39;%20viewBox%3D&#39;0%200%20768%20512&#39;%2F%3E\" data-src=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2023\/10\/Futuristic-digital-a-768x512.png\" data-srcset=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2023\/10\/Futuristic-digital-a-768x512.png 768w, https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2023\/10\/Futuristic-digital-a-1306x870.png 1306w\" loading=\"eager\" style=\"--ratio: 768 \/ 512\" sizes=\"(max-width: 768px) 100vw, 768px\" alt=\"postgresql16\" title=\"postgresql16\" width=\"768\" height=\"512\"  \/><\/a>\n\t<\/div>\n<\/div>\n\n\n<div class=\"post-entry-content\">\n\n\t<h3 class=\"entry-title\">\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2023\/10\/01\/a-glimpse-into-the-future-series-of-whats-new-in-postgresql16\/\" title=\"A Glimpse into the Future: Series of What&#8217;s New in PostgreSQL16 ?\" rel=\"bookmark\">A Glimpse into the Future: Series of What&#8217;s New in PostgreSQL16 ?<\/a>\n\t<\/h3>\n\n\t<div class=\"entry-meta\"><span class=\"category-link\"><a href=\"https:\/\/divaind.com\/ie1\/category\/postgresql\/\" >Postgresql<\/a><\/span><a href=\"https:\/\/divaind.com\/ie1\/2023\/10\/01\/\" title=\"2:59 pm\" class=\"data-link\" rel=\"bookmark\"><time class=\"entry-date updated\" datetime=\"2023-10-01T14:59:48+00:00\">October 1, 2023<\/time><\/a><a href=\"https:\/\/divaind.com\/ie1\/2023\/10\/01\/a-glimpse-into-the-future-series-of-whats-new-in-postgresql16\/#respond\" class=\"comment-link\" >Leave a comment<\/a><\/div>\n\t<div class=\"entry-excerpt\"><p>A Glimpse into the Future: Series of What&#8217;s New in PostgreSQL16 ? On September 14, 2023, the PostgreSQL Global Development Group introduced PostgreSQL16, marking the&hellip;<\/p>\n<\/div>\n\t\n<a href=\"https:\/\/divaind.com\/ie1\/2023\/10\/01\/a-glimpse-into-the-future-series-of-whats-new-in-postgresql16\/\" class=\"dt-btn-s dt-btn post-details details-type-btn\" aria-label=\"Read more about A Glimpse into the Future: Series of What&#8217;s New in PostgreSQL16 ?\">Read article<i class=\"dt-icon-the7-arrow-03\" aria-hidden=\"true\"><\/i><\/a>\n\n<\/div><\/article><article class=\"post project-odd hidden post-2558 type-post status-publish format-standard has-post-thumbnail hentry category-postgresql tag-inital-sync tag-logical-replication tag-pg_dump tag-postgres tag-postgresql tag-rds-to-community-postgres tag-replication category-28 description-off\" data-name=\"Optimizing Initial Sync for Large Databases in RDS PostgreSQL using pg_dump in Logical Replication\" data-date=\"2023-05-10T04:58:46+00:00\">\n\n<div class=\"post-thumbnail-wrap\">\n\t<div class=\"post-thumbnail\">\n\n\t\t\n\t\t\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2023\/05\/10\/setting-up-logical_replication-using-pg_dump\/\" class=\"post-thumbnail-rollover layzr-bg layzr-bg\" ><img decoding=\"async\" class=\"blog-thumb-lazy-load preload-me lazy-load aspect\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D&#39;http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg&#39;%20viewBox%3D&#39;0%200%20747%20498&#39;%2F%3E\" data-src=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2023\/02\/default-featured-747x498.jpg\" data-srcset=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2023\/02\/default-featured-747x498.jpg 747w, https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2023\/02\/default-featured-747x497.jpg 747w\" loading=\"eager\" style=\"--ratio: 747 \/ 498\" sizes=\"(max-width: 747px) 100vw, 747px\" alt=\"postgresql16\" title=\"default-featured\" width=\"747\" height=\"498\"  \/><\/a>\n\t<\/div>\n<\/div>\n\n\n<div class=\"post-entry-content\">\n\n\t<h3 class=\"entry-title\">\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2023\/05\/10\/setting-up-logical_replication-using-pg_dump\/\" title=\"Optimizing Initial Sync for Large Databases in RDS PostgreSQL using pg_dump in Logical Replication\" rel=\"bookmark\">Optimizing Initial Sync for Large Databases in RDS PostgreSQL using pg_dump in Logical Replication<\/a>\n\t<\/h3>\n\n\t<div class=\"entry-meta\"><span class=\"category-link\"><a href=\"https:\/\/divaind.com\/ie1\/category\/postgresql\/\" >Postgresql<\/a><\/span><a href=\"https:\/\/divaind.com\/ie1\/2023\/05\/10\/\" title=\"4:58 am\" class=\"data-link\" rel=\"bookmark\"><time class=\"entry-date updated\" datetime=\"2023-05-10T04:58:46+00:00\">May 10, 2023<\/time><\/a><a href=\"https:\/\/divaind.com\/ie1\/2023\/05\/10\/setting-up-logical_replication-using-pg_dump\/#respond\" class=\"comment-link\" >Leave a comment<\/a><\/div>\n\t<div class=\"entry-excerpt\"><p>PostgreSQL provides a built-in logical replication system based on the publish\/subscribe model, where a publisher publishes data changes to a publication, and a subscriber subscribes&hellip;<\/p>\n<\/div>\n\t\n<a href=\"https:\/\/divaind.com\/ie1\/2023\/05\/10\/setting-up-logical_replication-using-pg_dump\/\" class=\"dt-btn-s dt-btn post-details details-type-btn\" aria-label=\"Read more about Optimizing Initial Sync for Large Databases in RDS PostgreSQL using pg_dump in Logical Replication\">Read article<i class=\"dt-icon-the7-arrow-03\" aria-hidden=\"true\"><\/i><\/a>\n\n<\/div><\/article><article class=\"post project-odd hidden post-2536 type-post status-publish format-standard has-post-thumbnail hentry category-postgresql tag-postgresql-health-check category-28 description-off\" data-name=\"Essential Queries for PostgreSQL Health Assessment\" data-date=\"2023-03-29T17:27:05+00:00\">\n\n<div class=\"post-thumbnail-wrap\">\n\t<div class=\"post-thumbnail\">\n\n\t\t\n\t\t\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2023\/03\/29\/essential-queries-for-postgresql-health-assessment\/\" class=\"post-thumbnail-rollover layzr-bg layzr-bg\" ><img decoding=\"async\" class=\"blog-thumb-lazy-load preload-me lazy-load aspect\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D&#39;http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg&#39;%20viewBox%3D&#39;0%200%20768%20512&#39;%2F%3E\" data-src=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2023\/03\/doctor-checking-database-digital-art-art-station-detailed-intricate-sci-fi_bKA8r-1e_upscaled-768x512.jpg\" data-srcset=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2023\/03\/doctor-checking-database-digital-art-art-station-detailed-intricate-sci-fi_bKA8r-1e_upscaled-768x512.jpg 768w, https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2023\/03\/doctor-checking-database-digital-art-art-station-detailed-intricate-sci-fi_bKA8r-1e_upscaled-1306x870.jpg 1306w\" loading=\"eager\" style=\"--ratio: 768 \/ 512\" sizes=\"(max-width: 768px) 100vw, 768px\" alt=\"\" title=\"doctor-checking-database-digital-art-art-station-detailed-intricate-sci-fi_bKA8r-1e_upscaled\" width=\"768\" height=\"512\"  \/><\/a>\n\t<\/div>\n<\/div>\n\n\n<div class=\"post-entry-content\">\n\n\t<h3 class=\"entry-title\">\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2023\/03\/29\/essential-queries-for-postgresql-health-assessment\/\" title=\"Essential Queries for PostgreSQL Health Assessment\" rel=\"bookmark\">Essential Queries for PostgreSQL Health Assessment<\/a>\n\t<\/h3>\n\n\t<div class=\"entry-meta\"><span class=\"category-link\"><a href=\"https:\/\/divaind.com\/ie1\/category\/postgresql\/\" >Postgresql<\/a><\/span><a href=\"https:\/\/divaind.com\/ie1\/2023\/03\/29\/\" title=\"5:27 pm\" class=\"data-link\" rel=\"bookmark\"><time class=\"entry-date updated\" datetime=\"2023-03-29T17:27:05+00:00\">March 29, 2023<\/time><\/a><a href=\"https:\/\/divaind.com\/ie1\/2023\/03\/29\/essential-queries-for-postgresql-health-assessment\/#respond\" class=\"comment-link\" >Leave a comment<\/a><\/div>\n\t<div class=\"entry-excerpt\"><p>In this post, we&#8217;ll look at a few crucial queries that are helpful for exploring into PostgreSQL problems and evaluating the health of an existing&hellip;<\/p>\n<\/div>\n\t\n<a href=\"https:\/\/divaind.com\/ie1\/2023\/03\/29\/essential-queries-for-postgresql-health-assessment\/\" class=\"dt-btn-s dt-btn post-details details-type-btn\" aria-label=\"Read more about Essential Queries for PostgreSQL Health Assessment\">Read article<i class=\"dt-icon-the7-arrow-03\" aria-hidden=\"true\"><\/i><\/a>\n\n<\/div><\/article><article class=\"post project-odd hidden post-2523 type-post status-publish format-standard has-post-thumbnail hentry category-postgresql tag-permission category-28 description-off\" data-name=\"IDENTIFY A ROLE HAS EXECUTE PERMISSION ON FUNCTION IN\u00a0POSTGRESQL\" data-date=\"2023-02-14T14:15:56+00:00\">\n\n<div class=\"post-thumbnail-wrap\">\n\t<div class=\"post-thumbnail\">\n\n\t\t\n\t\t\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2023\/02\/14\/identify-a-role-has-execute-permission-on-function-in-postgresql\/\" class=\"post-thumbnail-rollover layzr-bg layzr-bg\" ><img decoding=\"async\" class=\"blog-thumb-lazy-load preload-me lazy-load aspect\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D&#39;http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg&#39;%20viewBox%3D&#39;0%200%20747%20498&#39;%2F%3E\" data-src=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2023\/02\/default-featured-747x498.jpg\" data-srcset=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2023\/02\/default-featured-747x498.jpg 747w, https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2023\/02\/default-featured-747x497.jpg 747w\" loading=\"eager\" style=\"--ratio: 747 \/ 498\" sizes=\"(max-width: 747px) 100vw, 747px\" alt=\"postgresql16\" title=\"default-featured\" width=\"747\" height=\"498\"  \/><\/a>\n\t<\/div>\n<\/div>\n\n\n<div class=\"post-entry-content\">\n\n\t<h3 class=\"entry-title\">\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2023\/02\/14\/identify-a-role-has-execute-permission-on-function-in-postgresql\/\" title=\"IDENTIFY A ROLE HAS EXECUTE PERMISSION ON FUNCTION IN\u00a0POSTGRESQL\" rel=\"bookmark\">IDENTIFY A ROLE HAS EXECUTE PERMISSION ON FUNCTION IN\u00a0POSTGRESQL<\/a>\n\t<\/h3>\n\n\t<div class=\"entry-meta\"><span class=\"category-link\"><a href=\"https:\/\/divaind.com\/ie1\/category\/postgresql\/\" >Postgresql<\/a><\/span><a href=\"https:\/\/divaind.com\/ie1\/2023\/02\/14\/\" title=\"2:15 pm\" class=\"data-link\" rel=\"bookmark\"><time class=\"entry-date updated\" datetime=\"2023-02-14T14:15:56+00:00\">February 14, 2023<\/time><\/a><a href=\"https:\/\/divaind.com\/ie1\/2023\/02\/14\/identify-a-role-has-execute-permission-on-function-in-postgresql\/#respond\" class=\"comment-link\" >Leave a comment<\/a><\/div>\n\t<div class=\"entry-excerpt\"><p>IDENTIFY A ROLE HAS EXECUTE PERMISSION ON FUNCTION IN\u00a0POSTGRESQL To identify a role has execute permission on function, PostgreSQL has a catalog function(has_function_privilege) which makes&hellip;<\/p>\n<\/div>\n\t\n<a href=\"https:\/\/divaind.com\/ie1\/2023\/02\/14\/identify-a-role-has-execute-permission-on-function-in-postgresql\/\" class=\"dt-btn-s dt-btn post-details details-type-btn\" aria-label=\"Read more about IDENTIFY A ROLE HAS EXECUTE PERMISSION ON FUNCTION IN\u00a0POSTGRESQL\">Read article<i class=\"dt-icon-the7-arrow-03\" aria-hidden=\"true\"><\/i><\/a>\n\n<\/div><\/article><article class=\"post project-odd hidden post-2498 type-post status-publish format-standard has-post-thumbnail hentry category-linux tag-linux tag-postgresql category-23 description-off\" data-name=\"REMAP_SCHEMA IN POSTGRESQL\" data-date=\"2023-02-14T08:00:21+00:00\">\n\n<div class=\"post-thumbnail-wrap\">\n\t<div class=\"post-thumbnail\">\n\n\t\t\n\t\t\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2023\/02\/14\/remap_schema-in-postgresql\/\" class=\"post-thumbnail-rollover layzr-bg layzr-bg\" ><img decoding=\"async\" class=\"blog-thumb-lazy-load preload-me lazy-load aspect\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D&#39;http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg&#39;%20viewBox%3D&#39;0%200%20747%20498&#39;%2F%3E\" data-src=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2023\/02\/default-featured-747x498.jpg\" data-srcset=\"https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2023\/02\/default-featured-747x498.jpg 747w, https:\/\/divaind.com\/ie1\/wp-content\/uploads\/2023\/02\/default-featured-747x497.jpg 747w\" loading=\"eager\" style=\"--ratio: 747 \/ 498\" sizes=\"(max-width: 747px) 100vw, 747px\" alt=\"postgresql16\" title=\"default-featured\" width=\"747\" height=\"498\"  \/><\/a>\n\t<\/div>\n<\/div>\n\n\n<div class=\"post-entry-content\">\n\n\t<h3 class=\"entry-title\">\n\t\t<a href=\"https:\/\/divaind.com\/ie1\/2023\/02\/14\/remap_schema-in-postgresql\/\" title=\"REMAP_SCHEMA IN POSTGRESQL\" rel=\"bookmark\">REMAP_SCHEMA IN POSTGRESQL<\/a>\n\t<\/h3>\n\n\t<div class=\"entry-meta\"><span class=\"category-link\"><a href=\"https:\/\/divaind.com\/ie1\/category\/linux\/\" >Linux<\/a><\/span><a href=\"https:\/\/divaind.com\/ie1\/2023\/02\/14\/\" title=\"8:00 am\" class=\"data-link\" rel=\"bookmark\"><time class=\"entry-date updated\" datetime=\"2023-02-14T08:00:21+00:00\">February 14, 2023<\/time><\/a><a href=\"https:\/\/divaind.com\/ie1\/2023\/02\/14\/remap_schema-in-postgresql\/#respond\" class=\"comment-link\" >Leave a comment<\/a><\/div>\n\t<div class=\"entry-excerpt\"><p>This is very typical requirement we get in DBA world where we need to copy tables from one schema to another schema. In Oracle we&hellip;<\/p>\n<\/div>\n\t\n<a href=\"https:\/\/divaind.com\/ie1\/2023\/02\/14\/remap_schema-in-postgresql\/\" class=\"dt-btn-s dt-btn post-details details-type-btn\" aria-label=\"Read more about REMAP_SCHEMA IN POSTGRESQL\">Read article<i class=\"dt-icon-the7-arrow-03\" aria-hidden=\"true\"><\/i><\/a>\n\n<\/div><\/article><div class=\"paginator paginator-more-button\">\n\t\t\t\t<a class=\"button-load-more \" href=\"javascript:void(0);\" data-dt-page=\"1\" ><span class=\"stick\"><\/span><span class=\"stick\"><\/span><span class=\"stick\"><\/span><span class=\"button-caption\">Load more<\/span><\/a>\n\t\t\t<\/div><\/div>[\/vc_column][\/vc_row]\n<\/div>","protected":false},"excerpt":{"rendered":"<p>[vc_row][vc_column][\/vc_column][\/vc_row]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":45,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-306","page","type-page","status-publish","hentry","description-off"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/divaind.com\/ie1\/wp-json\/wp\/v2\/pages\/306","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/divaind.com\/ie1\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/divaind.com\/ie1\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/divaind.com\/ie1\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/divaind.com\/ie1\/wp-json\/wp\/v2\/comments?post=306"}],"version-history":[{"count":0,"href":"https:\/\/divaind.com\/ie1\/wp-json\/wp\/v2\/pages\/306\/revisions"}],"wp:attachment":[{"href":"https:\/\/divaind.com\/ie1\/wp-json\/wp\/v2\/media?parent=306"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}