{"id":5833,"date":"2024-07-24T10:49:02","date_gmt":"2024-07-24T10:49:02","guid":{"rendered":"https:\/\/test.opensource-db.in\/wp1\/?p=5833"},"modified":"2024-07-30T11:56:47","modified_gmt":"2024-07-30T11:56:47","slug":"setting-up-pgbadger-in-the-postgresql","status":"publish","type":"post","link":"https:\/\/test.opensource-db.in\/wp1\/setting-up-pgbadger-in-the-postgresql\/","title":{"rendered":"Setting up pgBadger in the PostgreSQL"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Introduction<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">PostgreSQL, as a  widely adopted relational database management system, powers applications ranging from small-scale projects to enterprise-level solutions. Monitoring and analyzing PostgreSQL performance and operational logs are essential tasks for ensuring database reliability, optimizing performance, and troubleshooting issues effectively. <strong>pgBadger<\/strong> is an open-source PostgreSQL log analyzer that provides fast, detailed, and user-friendly log analysis reports. Written in Perl, pgBadger processes log output from a running PostgreSQL instance and transforms it into comprehensive HTML reports. These reports offer valuable insights into various aspects of PostgreSQL performance and operations, including error occurrences, checkpoint behavior, vacuum operations, and more.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Key Features of pgBadger<\/strong><\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Performance Analysis<\/strong>: pgBadger helps you analyze the performance of your PostgreSQL instance by highlighting slow queries and providing details on query execution times.<\/li>\n\n\n\n<li><strong>Error Reporting<\/strong>: The tool efficiently logs and reports errors, making it easier to identify and troubleshoot issues within your PostgreSQL system.<\/li>\n\n\n\n<li><strong>Checkpoint and Vacuum Behavior<\/strong>: pgBadger provides insights into checkpoint and vacuum operations, which are crucial for database maintenance and performance.<\/li>\n\n\n\n<li><strong>Detailed Reports<\/strong>: The HTML reports generated by pgBadger are easy to read and navigate, with interactive charts and graphs that provide a visual representation of the data.<\/li>\n\n\n\n<li><strong>Customization<\/strong>: The tool offers various options to customize the report output, including filtering logs by date range, log level, and more.<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Installation Prerequisites<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">pgBadger is written in pure Perl, a highly versatile programming language known for its text processing capabilities. To use pgBadger, you need to have a modern Perl distribution installed on your system. Additionally, the generated HTML reports utilize a JavaScript library for rendering interactive charts and graphs, but no additional software is required for this as your web browser will handle the rendering.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Perl Installation<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Perl needs to be installed on your system, you can install it using the following command:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code> yum install -y perl perl-devel<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">This command installs both the Perl interpreter and the Perl development libraries, ensuring that you have everything needed to run pgBadger effectively.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>PgBadger Installation<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Step 1: Install pgBadger<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To install pgBadger along with its dependencies, follow these steps:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Install pgBadger and Dependencies<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">You can install pgBadger and its necessary dependencies, such as <code>perl-Text-CSV_XS<\/code> and <code>perl-UNIVERSAL-isa<\/code>, using the following command:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo dnf install pgbadger<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">This command installs the latest version of pgBadger from the community repository.<span id=\"docs-internal-guid-69d7b6fb-7fff-b52a-cd0c-b76bd21fd365\"><\/span><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To verify that pgBadger is installed correctly, you can check the version:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&#91;postgres@localhost ~]$ pgbadger --version\npgBadger version 12.4<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 2:<\/strong> PostgreSQL Configuration<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">To ensure pgBadger can effectively analyze your PostgreSQL logs, you need to modify the configuration in the postgresql.conf file. Here are the parameters you should set:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>log_autovacuum_min_duration = 0 \nlog_checkpoints = on\nlog_connections = on\nlog_disconnections = on\nlog_duration = on\nlog_lock_waits = on\nlog_temp_files = 0 \nlog_statement = 'all'\nlog_min_duration_statement = 0 \nlog_line_prefix = '%t &#91;%p]: &#91;%l-1] user=%u,db=%d,app=%a,client=%h ' <\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">After making these changes, restart your PostgreSQL server to apply the new configuration:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo systemctl restart postgresql<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 3: Generate pgBadger Report<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">After restarting PostgreSQL, you can generate the pgBadger report using the following command:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&#91;postgres@localhost ~]$  pgbadger -f stderr  -o file_name \/var\/lib\/pgsql\/16\/data\/log\/postgresql-*.log\n&#91;========================&gt;] Parsed 29915 bytes of 29915 (100.00%), queries: 42, events: 13\nLOG: Ok, generating txt report...<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"> This command will process the log file and generate an HTML report that you can view in your web browser.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Best Practices for Using pgBadger<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Following best practices ensures you get the most out of pgBadger and maintain an optimized PostgreSQL environment:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Regularly Rotating and Archiving Log Files:<\/strong><br>Log Rotation: Configure PostgreSQL to rotate logs daily or when they reach a certain size to prevent large files from becoming unmanageable.<br>Archiving: Archive old log files to a separate directory or storage system to save space and maintain log history.<br>Choosing the Right Log Format:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Standard Error (stderr): The default and most commonly used format.<br>CSV Logs: Use CSV format for easier parsing and integration with other tools, if needed.<br>Keeping pgBadger Updated:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Latest Version: Regularly check for updates and upgrade to the latest version of pgBadger to benefit from new features and bug fixes.<br>Release Notes: Review release notes for any changes that might affect your setup.<br>Integrating pgBadger with Other Monitoring Tools:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Comprehensive Monitoring<\/strong><br>Combine pgBadger with other tools like Nagios, Prometheus, or Grafana for a complete monitoring solution.<br>Alerting: Set up alerts for specific performance metrics to proactively address issues.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Conclusion<\/strong>:<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><code>pgbadger<\/code> is a powerful tool for PostgreSQL DBA&#8217;s and developers to utilize PostgreSQL log file for monitoring and take required actions. It&#8217;s fast processing capabilities, comprehensive reports, and customization options make it invaluable for optimizing database performance, troubleshooting issues, and ensuring reliable database operations.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">With pgBadger installed, you can now use it to analyze your PostgreSQL logs and generate detailed HTML reports. This tool will help you gain insights into database performance, errors, and other critical operational metrics, ultimately aiding in maintaining a healthy and efficient PostgreSQL environment. Stay tuned for more info<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction PostgreSQL, as a widely adopted relational database management system, powers applications ranging from small-scale projects to enterprise-level solutions. Monitoring [&hellip;]<\/p>\n","protected":false},"author":13,"featured_media":5847,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[23,42,89],"tags":[],"class_list":["post-5833","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-postgresql-14","category-postgresql-15","category-postgresql-16"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Setting up pgBadger in the PostgreSQL - OpenSource DB<\/title>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Setting up pgBadger in the PostgreSQL - OpenSource DB\" \/>\n<meta property=\"og:description\" content=\"Introduction PostgreSQL, as a widely adopted relational database management system, powers applications ranging from small-scale projects to enterprise-level solutions. Monitoring [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/test.opensource-db.in\/wp1\/setting-up-pgbadger-in-the-postgresql\/\" \/>\n<meta property=\"og:site_name\" content=\"OpenSource DB\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/people\/OpenSource-DB\/100072970755470\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-07-24T10:49:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-07-30T11:56:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/07\/Blog1-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"512\" \/>\n\t<meta property=\"og:image:height\" content=\"269\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Shameer Bhupathi\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@opensource_db\" \/>\n<meta name=\"twitter:site\" content=\"@opensource_db\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Shameer Bhupathi\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/setting-up-pgbadger-in-the-postgresql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/setting-up-pgbadger-in-the-postgresql\/\"},\"author\":{\"name\":\"Shameer Bhupathi\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/422480fbefed0b2cee82aeab232110f5\"},\"headline\":\"Setting up pgBadger in the PostgreSQL\",\"datePublished\":\"2024-07-24T10:49:02+00:00\",\"dateModified\":\"2024-07-30T11:56:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/setting-up-pgbadger-in-the-postgresql\/\"},\"wordCount\":729,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#organization\"},\"image\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/setting-up-pgbadger-in-the-postgresql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/07\/Blog1-1.png\",\"articleSection\":[\"PostgreSQL 14\",\"PostgreSQL 15\",\"PostgreSQL 16\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/test.opensource-db.in\/wp1\/setting-up-pgbadger-in-the-postgresql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/setting-up-pgbadger-in-the-postgresql\/\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/setting-up-pgbadger-in-the-postgresql\/\",\"name\":\"Setting up pgBadger in the PostgreSQL - OpenSource DB\",\"isPartOf\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/setting-up-pgbadger-in-the-postgresql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/setting-up-pgbadger-in-the-postgresql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/07\/Blog1-1.png\",\"datePublished\":\"2024-07-24T10:49:02+00:00\",\"dateModified\":\"2024-07-30T11:56:47+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/setting-up-pgbadger-in-the-postgresql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/test.opensource-db.in\/wp1\/setting-up-pgbadger-in-the-postgresql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/setting-up-pgbadger-in-the-postgresql\/#primaryimage\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/07\/Blog1-1.png\",\"contentUrl\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/07\/Blog1-1.png\",\"width\":512,\"height\":269},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/setting-up-pgbadger-in-the-postgresql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/test.opensource-db.in\/wp1\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Setting up pgBadger in the PostgreSQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#website\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/\",\"name\":\"OpenSource DB\",\"description\":\"Your Trusted OpenSource Databases partner\",\"publisher\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/test.opensource-db.in\/wp1\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#organization\",\"name\":\"OPENSOURCE DB PRIVATE LIMITED\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/osdb-logo-tm-2.png\",\"contentUrl\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/osdb-logo-tm-2.png\",\"width\":368,\"height\":120,\"caption\":\"OPENSOURCE DB PRIVATE LIMITED\"},\"image\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/people\/OpenSource-DB\/100072970755470\/\",\"https:\/\/x.com\/opensource_db\",\"https:\/\/www.youtube.com\/channel\/UCmTI5h\",\"https:\/\/www.linkedin.com\/company\/opensource-db\",\"https:\/\/www.instagram.com\/opensource_db\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/422480fbefed0b2cee82aeab232110f5\",\"name\":\"Shameer Bhupathi\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/2cfa95999202132ded07acd24f6faf25dca145a6c3efe47919204f115ffbf625?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/2cfa95999202132ded07acd24f6faf25dca145a6c3efe47919204f115ffbf625?s=96&d=mm&r=g\",\"caption\":\"Shameer Bhupathi\"},\"url\":\"https:\/\/test.opensource-db.in\/wp1\/author\/shameer-bhupathi\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Setting up pgBadger in the PostgreSQL - OpenSource DB","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_US","og_type":"article","og_title":"Setting up pgBadger in the PostgreSQL - OpenSource DB","og_description":"Introduction PostgreSQL, as a widely adopted relational database management system, powers applications ranging from small-scale projects to enterprise-level solutions. Monitoring [&hellip;]","og_url":"https:\/\/test.opensource-db.in\/wp1\/setting-up-pgbadger-in-the-postgresql\/","og_site_name":"OpenSource DB","article_publisher":"https:\/\/www.facebook.com\/people\/OpenSource-DB\/100072970755470\/","article_published_time":"2024-07-24T10:49:02+00:00","article_modified_time":"2024-07-30T11:56:47+00:00","og_image":[{"width":512,"height":269,"url":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/07\/Blog1-1.png","type":"image\/png"}],"author":"Shameer Bhupathi","twitter_card":"summary_large_image","twitter_creator":"@opensource_db","twitter_site":"@opensource_db","twitter_misc":{"Written by":"Shameer Bhupathi","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/test.opensource-db.in\/wp1\/setting-up-pgbadger-in-the-postgresql\/#article","isPartOf":{"@id":"https:\/\/test.opensource-db.in\/wp1\/setting-up-pgbadger-in-the-postgresql\/"},"author":{"name":"Shameer Bhupathi","@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/422480fbefed0b2cee82aeab232110f5"},"headline":"Setting up pgBadger in the PostgreSQL","datePublished":"2024-07-24T10:49:02+00:00","dateModified":"2024-07-30T11:56:47+00:00","mainEntityOfPage":{"@id":"https:\/\/test.opensource-db.in\/wp1\/setting-up-pgbadger-in-the-postgresql\/"},"wordCount":729,"commentCount":0,"publisher":{"@id":"https:\/\/test.opensource-db.in\/wp1\/#organization"},"image":{"@id":"https:\/\/test.opensource-db.in\/wp1\/setting-up-pgbadger-in-the-postgresql\/#primaryimage"},"thumbnailUrl":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/07\/Blog1-1.png","articleSection":["PostgreSQL 14","PostgreSQL 15","PostgreSQL 16"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/test.opensource-db.in\/wp1\/setting-up-pgbadger-in-the-postgresql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/test.opensource-db.in\/wp1\/setting-up-pgbadger-in-the-postgresql\/","url":"https:\/\/test.opensource-db.in\/wp1\/setting-up-pgbadger-in-the-postgresql\/","name":"Setting up pgBadger in the PostgreSQL - OpenSource DB","isPartOf":{"@id":"https:\/\/test.opensource-db.in\/wp1\/#website"},"primaryImageOfPage":{"@id":"https:\/\/test.opensource-db.in\/wp1\/setting-up-pgbadger-in-the-postgresql\/#primaryimage"},"image":{"@id":"https:\/\/test.opensource-db.in\/wp1\/setting-up-pgbadger-in-the-postgresql\/#primaryimage"},"thumbnailUrl":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/07\/Blog1-1.png","datePublished":"2024-07-24T10:49:02+00:00","dateModified":"2024-07-30T11:56:47+00:00","breadcrumb":{"@id":"https:\/\/test.opensource-db.in\/wp1\/setting-up-pgbadger-in-the-postgresql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/test.opensource-db.in\/wp1\/setting-up-pgbadger-in-the-postgresql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/test.opensource-db.in\/wp1\/setting-up-pgbadger-in-the-postgresql\/#primaryimage","url":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/07\/Blog1-1.png","contentUrl":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/07\/Blog1-1.png","width":512,"height":269},{"@type":"BreadcrumbList","@id":"https:\/\/test.opensource-db.in\/wp1\/setting-up-pgbadger-in-the-postgresql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/test.opensource-db.in\/wp1\/"},{"@type":"ListItem","position":2,"name":"Setting up pgBadger in the PostgreSQL"}]},{"@type":"WebSite","@id":"https:\/\/test.opensource-db.in\/wp1\/#website","url":"https:\/\/test.opensource-db.in\/wp1\/","name":"OpenSource DB","description":"Your Trusted OpenSource Databases partner","publisher":{"@id":"https:\/\/test.opensource-db.in\/wp1\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/test.opensource-db.in\/wp1\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/test.opensource-db.in\/wp1\/#organization","name":"OPENSOURCE DB PRIVATE LIMITED","url":"https:\/\/test.opensource-db.in\/wp1\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/logo\/image\/","url":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/osdb-logo-tm-2.png","contentUrl":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/osdb-logo-tm-2.png","width":368,"height":120,"caption":"OPENSOURCE DB PRIVATE LIMITED"},"image":{"@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/people\/OpenSource-DB\/100072970755470\/","https:\/\/x.com\/opensource_db","https:\/\/www.youtube.com\/channel\/UCmTI5h","https:\/\/www.linkedin.com\/company\/opensource-db","https:\/\/www.instagram.com\/opensource_db\/"]},{"@type":"Person","@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/422480fbefed0b2cee82aeab232110f5","name":"Shameer Bhupathi","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/2cfa95999202132ded07acd24f6faf25dca145a6c3efe47919204f115ffbf625?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/2cfa95999202132ded07acd24f6faf25dca145a6c3efe47919204f115ffbf625?s=96&d=mm&r=g","caption":"Shameer Bhupathi"},"url":"https:\/\/test.opensource-db.in\/wp1\/author\/shameer-bhupathi\/"}]}},"rttpg_featured_image_url":{"full":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/07\/Blog1-1.png",512,269,false],"landscape":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/07\/Blog1-1.png",512,269,false],"portraits":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/07\/Blog1-1.png",512,269,false],"thumbnail":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/07\/Blog1-1-150x150.png",150,150,true],"medium":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/07\/Blog1-1-300x158.png",300,158,true],"large":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/07\/Blog1-1.png",512,269,false],"1536x1536":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/07\/Blog1-1.png",512,269,false],"2048x2048":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/07\/Blog1-1.png",512,269,false],"ultp_layout_landscape_large":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/07\/Blog1-1.png",512,269,false],"ultp_layout_landscape":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/07\/Blog1-1.png",512,269,false],"ultp_layout_portrait":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/07\/Blog1-1.png",512,269,false],"ultp_layout_square":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/07\/Blog1-1.png",512,269,false]},"rttpg_author":{"display_name":"Shameer Bhupathi","author_link":"https:\/\/test.opensource-db.in\/wp1\/author\/shameer-bhupathi\/"},"rttpg_comment":0,"rttpg_category":"<a href=\"https:\/\/test.opensource-db.in\/wp1\/category\/postgres\/postgresql-14\/\" rel=\"category tag\">PostgreSQL 14<\/a> <a href=\"https:\/\/test.opensource-db.in\/wp1\/category\/postgres\/postgresql-15\/\" rel=\"category tag\">PostgreSQL 15<\/a> <a href=\"https:\/\/test.opensource-db.in\/wp1\/category\/postgres\/postgresql-16\/\" rel=\"category tag\">PostgreSQL 16<\/a>","rttpg_excerpt":"Introduction PostgreSQL, as a widely adopted relational database management system, powers applications ranging from small-scale projects to enterprise-level solutions. Monitoring [&hellip;]","_links":{"self":[{"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/posts\/5833","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/comments?post=5833"}],"version-history":[{"count":6,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/posts\/5833\/revisions"}],"predecessor-version":[{"id":5844,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/posts\/5833\/revisions\/5844"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/media\/5847"}],"wp:attachment":[{"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/media?parent=5833"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/categories?post=5833"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/tags?post=5833"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}