
{"id":6581,"date":"2024-11-27T12:43:58","date_gmt":"2024-11-27T12:43:58","guid":{"rendered":"https:\/\/test.opensource-db.in\/wp1\/?p=6581"},"modified":"2024-11-27T12:48:54","modified_gmt":"2024-11-27T12:48:54","slug":"understanding-pgaudit-postgresql-auditing-made-easy","status":"publish","type":"post","link":"https:\/\/test.opensource-db.in\/wp1\/understanding-pgaudit-postgresql-auditing-made-easy\/","title":{"rendered":"Understanding pgAudit: PostgreSQL Auditing Made Easy"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">PostgreSQL is one of the most robust and flexible relational database management systems available today, offering a wide array of features for database administrators (DBAs) and developers alike. However, like any database, security and auditing are critical concerns when managing sensitive data. <code>pgaudit<\/code> is an extension for PostgreSQL that helps with auditing database activity, providing a clear and comprehensive audit trail of database operations.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In this blog post, we&#8217;ll dive into what <code>pgaudit<\/code> is, how to install and configure it, and explore some uses that make it essential for security and compliance.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">What is pgAudit?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">pgaudit is an open-source PostgreSQL extension that enhances PostgreSQL&#8217;s logging functionality by adding detailed audit logging capabilities. It logs all the database activity that is required to track and monitor user interactions, including queries, user sessions, and system-level events. By default, PostgreSQL provides basic logging, which includes information such as the start and end times of queries. However, for many compliance frameworks (e.g., ISO), it is often necessary to capture more granular data. This is where pgAudit can play a major role, by providing detailed activity logs, including:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>SQL queries executed (including the values of parameters).<\/li>\n\n\n\n<li>Successful or failed login attempts.<\/li>\n\n\n\n<li>Changes to database objects (e.g., table creation or dropping).<\/li>\n\n\n\n<li>DML operations (INSERT, UPDATE, DELETE).<\/li>\n\n\n\n<li>SELECT queries with detailed information, such as the user issuing them.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Why pgAudit?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The need for robust auditing is more important than ever. Organizations dealing with sensitive information (such as financial or health data) need to comply with various regulations. pgaudit offers several key benefits:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Compliance with Regulatory Standards like GDPR ,ISO etc<\/li>\n\n\n\n<li>Enhanced Security<\/li>\n\n\n\n<li>Transparency and Monitoring<\/li>\n\n\n\n<li>Simplified Troubleshooting<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Installation and Configuration<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">To begin using <code>pgaudit<\/code>, you must first install the PostgreSQL development tools. Here , I have setup of Ubuntu 24.04 with PostgreSQL 17.2 .<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><span style=\"font-family: ui-sans-serif, system-ui, -apple-system, BlinkMacSystemFont, &quot;Segoe UI&quot;, Roboto, &quot;Helvetica Neue&quot;, Arial, &quot;Noto Sans&quot;, sans-serif, &quot;Apple Color Emoji&quot;, &quot;Segoe UI Emoji&quot;, &quot;Segoe UI Symbol&quot;, &quot;Noto Color Emoji&quot;; font-size: medium; text-wrap-mode: nowrap;\">sudo apt-get update\nsudo apt-get install postgresql-contrib postgresql-server-dev-all<\/span><\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Once , we have the required tools installed, let&#8217;s install <code>pgaudit<\/code><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo apt-get install postgresql-17-pgaudit  \n# Replace 17 with your PostgreSQL version<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">To complete the setup, we need to change a parameter in the <code>postgresql.conf<\/code> file<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>#In postgresql.conf file\nshared_preload_libraries='pgaudit'\n#It requires the restart of the postgresql services<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Login to psql for creating and configuring the extension <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>postgres@ip-172-31-23-19:~$ psql\npsql (17.2 (Ubuntu 17.2-1.pgdg24.04+1))\nType \"help\" for help.\n\npostgres=# create extension pgaudit;\nCREATE EXTENSION\npostgres=# \\dx\n                   List of installed extensions\n  Name   | Version |   Schema   |           Description\n---------+---------+------------+---------------------------------\n pgaudit | 17.0    | public     | provides auditing functionality\n plpgsql | 1.0     | pg_catalog | PL\/pgSQL procedural language\n(2 rows)\n#Configuring the pgaudit.log to'read'\npostgres=# alter system set pgaudit.log to 'READ';\nALTER SYSTEM\npostgres=# select pg_reload_conf();\n pg_reload_conf\n----------------\n t\n(1 row)<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Let\u2018s look at some commonly used&nbsp;<code>pgaudit.log<\/code>&nbsp;settings:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>WRITE<\/code>&nbsp;\u2013 Log all SQL writes like INSERT, UPDATE, DELETE, TRUNCATE<\/li>\n\n\n\n<li><code>FUNCTION<\/code>&nbsp;\u2013 Log calls to functions and stored procedures<\/li>\n\n\n\n<li><code>ROLE<\/code>&nbsp;\u2013 Log user creation, role grants etc.<\/li>\n\n\n\n<li><code>DDL<\/code>&nbsp;\u2013 Log all DDL statements like CREATE TABLE<\/li>\n\n\n\n<li><code>DML<\/code>&nbsp;\u2013 Enable logging for all DML statements<\/li>\n\n\n\n<li><code>MISC<\/code>&nbsp;\u2013 Log miscellaneous commands like VACUUM, EXPLAIN<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Verifying the log file<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Let&#8217;s verify in our log file<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>2024-11-27 11:37:01.857 UTC &#91;10329] LOG:  parameter \"pgaudit.log\" changed to \"READ\"\n2024-11-27 11:38:00.473 UTC &#91;10495] postgres@postgres LOG:  AUDIT: SESSION,1,1,READ,SELECT,,,\"SELECT pg_catalog.lower(name) FROM pg_catalog.pg_settings  WHERE pg_catalog.lower(name) LIKE pg_catalog.lower('log\\_dire%')<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Here , we can see that <code>pgaudit<\/code> extension captures the <code>select<\/code> query as we set the <code>pgaudit.log<\/code>  to <code>'read'<\/code>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusion<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><code>pgaudit<\/code> is a powerful extension for PostgreSQL that provides the necessary auditing capabilities for businesses to comply with regulations, enhance security, and track database activities. Its ability to log detailed information about SQL queries, user actions, and changes to database objects makes it an invaluable tool for DBAs, security teams, and compliance officers.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">With <code>pgaudit<\/code> in place, you can ensure that your PostgreSQL databases are fully auditable, which is crucial for regulatory compliance and maintaining a secure database environment. Implementing it correctly in your PostgreSQL system can go a long way toward improving your organization&#8217;s security posture and reducing the risk of unauthorized data access or manipulation.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>PostgreSQL is one of the most robust and flexible relational database management systems available today, offering a wide array of [&hellip;]<\/p>\n","protected":false},"author":9,"featured_media":6585,"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":[1,23,42,89],"tags":[],"class_list":["post-6581","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-others","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>Understanding pgAudit: PostgreSQL Auditing Made Easy - 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=\"Understanding pgAudit: PostgreSQL Auditing Made Easy - OpenSource DB\" \/>\n<meta property=\"og:description\" content=\"PostgreSQL is one of the most robust and flexible relational database management systems available today, offering a wide array of [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/test.opensource-db.in\/wp1\/understanding-pgaudit-postgresql-auditing-made-easy\/\" \/>\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-11-27T12:43:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-11-27T12:48:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/11\/pgAudit.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1800\" \/>\n\t<meta property=\"og:image:height\" content=\"945\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Venkat Akhil\" \/>\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=\"Venkat Akhil\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/understanding-pgaudit-postgresql-auditing-made-easy\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/understanding-pgaudit-postgresql-auditing-made-easy\/\"},\"author\":{\"name\":\"Venkat Akhil\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/a37b142ecbf953189a4f9209b0b8d328\"},\"headline\":\"Understanding pgAudit: PostgreSQL Auditing Made Easy\",\"datePublished\":\"2024-11-27T12:43:58+00:00\",\"dateModified\":\"2024-11-27T12:48:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/understanding-pgaudit-postgresql-auditing-made-easy\/\"},\"wordCount\":521,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#organization\"},\"image\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/understanding-pgaudit-postgresql-auditing-made-easy\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/11\/pgAudit.png\",\"articleSection\":[\"Others\",\"PostgreSQL 14\",\"PostgreSQL 15\",\"PostgreSQL 16\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/test.opensource-db.in\/wp1\/understanding-pgaudit-postgresql-auditing-made-easy\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/understanding-pgaudit-postgresql-auditing-made-easy\/\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/understanding-pgaudit-postgresql-auditing-made-easy\/\",\"name\":\"Understanding pgAudit: PostgreSQL Auditing Made Easy - OpenSource DB\",\"isPartOf\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/understanding-pgaudit-postgresql-auditing-made-easy\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/understanding-pgaudit-postgresql-auditing-made-easy\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/11\/pgAudit.png\",\"datePublished\":\"2024-11-27T12:43:58+00:00\",\"dateModified\":\"2024-11-27T12:48:54+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/understanding-pgaudit-postgresql-auditing-made-easy\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/test.opensource-db.in\/wp1\/understanding-pgaudit-postgresql-auditing-made-easy\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/understanding-pgaudit-postgresql-auditing-made-easy\/#primaryimage\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/11\/pgAudit.png\",\"contentUrl\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/11\/pgAudit.png\",\"width\":1800,\"height\":945},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/understanding-pgaudit-postgresql-auditing-made-easy\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/test.opensource-db.in\/wp1\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Understanding pgAudit: PostgreSQL Auditing Made Easy\"}]},{\"@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\/a37b142ecbf953189a4f9209b0b8d328\",\"name\":\"Venkat Akhil\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/522c0947d21b2c2c89f10698fd9131f9db4110f65c8d02b53d9b4559c7650865?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/522c0947d21b2c2c89f10698fd9131f9db4110f65c8d02b53d9b4559c7650865?s=96&d=mm&r=g\",\"caption\":\"Venkat Akhil\"},\"url\":\"https:\/\/test.opensource-db.in\/wp1\/author\/sudheer-sopensource-db-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Understanding pgAudit: PostgreSQL Auditing Made Easy - 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":"Understanding pgAudit: PostgreSQL Auditing Made Easy - OpenSource DB","og_description":"PostgreSQL is one of the most robust and flexible relational database management systems available today, offering a wide array of [&hellip;]","og_url":"https:\/\/test.opensource-db.in\/wp1\/understanding-pgaudit-postgresql-auditing-made-easy\/","og_site_name":"OpenSource DB","article_publisher":"https:\/\/www.facebook.com\/people\/OpenSource-DB\/100072970755470\/","article_published_time":"2024-11-27T12:43:58+00:00","article_modified_time":"2024-11-27T12:48:54+00:00","og_image":[{"width":1800,"height":945,"url":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/11\/pgAudit.png","type":"image\/png"}],"author":"Venkat Akhil","twitter_card":"summary_large_image","twitter_creator":"@opensource_db","twitter_site":"@opensource_db","twitter_misc":{"Written by":"Venkat Akhil","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/test.opensource-db.in\/wp1\/understanding-pgaudit-postgresql-auditing-made-easy\/#article","isPartOf":{"@id":"https:\/\/test.opensource-db.in\/wp1\/understanding-pgaudit-postgresql-auditing-made-easy\/"},"author":{"name":"Venkat Akhil","@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/a37b142ecbf953189a4f9209b0b8d328"},"headline":"Understanding pgAudit: PostgreSQL Auditing Made Easy","datePublished":"2024-11-27T12:43:58+00:00","dateModified":"2024-11-27T12:48:54+00:00","mainEntityOfPage":{"@id":"https:\/\/test.opensource-db.in\/wp1\/understanding-pgaudit-postgresql-auditing-made-easy\/"},"wordCount":521,"commentCount":0,"publisher":{"@id":"https:\/\/test.opensource-db.in\/wp1\/#organization"},"image":{"@id":"https:\/\/test.opensource-db.in\/wp1\/understanding-pgaudit-postgresql-auditing-made-easy\/#primaryimage"},"thumbnailUrl":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/11\/pgAudit.png","articleSection":["Others","PostgreSQL 14","PostgreSQL 15","PostgreSQL 16"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/test.opensource-db.in\/wp1\/understanding-pgaudit-postgresql-auditing-made-easy\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/test.opensource-db.in\/wp1\/understanding-pgaudit-postgresql-auditing-made-easy\/","url":"https:\/\/test.opensource-db.in\/wp1\/understanding-pgaudit-postgresql-auditing-made-easy\/","name":"Understanding pgAudit: PostgreSQL Auditing Made Easy - OpenSource DB","isPartOf":{"@id":"https:\/\/test.opensource-db.in\/wp1\/#website"},"primaryImageOfPage":{"@id":"https:\/\/test.opensource-db.in\/wp1\/understanding-pgaudit-postgresql-auditing-made-easy\/#primaryimage"},"image":{"@id":"https:\/\/test.opensource-db.in\/wp1\/understanding-pgaudit-postgresql-auditing-made-easy\/#primaryimage"},"thumbnailUrl":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/11\/pgAudit.png","datePublished":"2024-11-27T12:43:58+00:00","dateModified":"2024-11-27T12:48:54+00:00","breadcrumb":{"@id":"https:\/\/test.opensource-db.in\/wp1\/understanding-pgaudit-postgresql-auditing-made-easy\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/test.opensource-db.in\/wp1\/understanding-pgaudit-postgresql-auditing-made-easy\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/test.opensource-db.in\/wp1\/understanding-pgaudit-postgresql-auditing-made-easy\/#primaryimage","url":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/11\/pgAudit.png","contentUrl":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/11\/pgAudit.png","width":1800,"height":945},{"@type":"BreadcrumbList","@id":"https:\/\/test.opensource-db.in\/wp1\/understanding-pgaudit-postgresql-auditing-made-easy\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/test.opensource-db.in\/wp1\/"},{"@type":"ListItem","position":2,"name":"Understanding pgAudit: PostgreSQL Auditing Made Easy"}]},{"@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\/a37b142ecbf953189a4f9209b0b8d328","name":"Venkat Akhil","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/522c0947d21b2c2c89f10698fd9131f9db4110f65c8d02b53d9b4559c7650865?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/522c0947d21b2c2c89f10698fd9131f9db4110f65c8d02b53d9b4559c7650865?s=96&d=mm&r=g","caption":"Venkat Akhil"},"url":"https:\/\/test.opensource-db.in\/wp1\/author\/sudheer-sopensource-db-com\/"}]}},"rttpg_featured_image_url":{"full":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/11\/pgAudit.png",1800,945,false],"landscape":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/11\/pgAudit.png",1800,945,false],"portraits":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/11\/pgAudit.png",1800,945,false],"thumbnail":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/11\/pgAudit-150x150.png",150,150,true],"medium":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/11\/pgAudit-300x158.png",300,158,true],"large":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/11\/pgAudit-1024x538.png",1024,538,true],"1536x1536":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/11\/pgAudit-1536x806.png",1536,806,true],"2048x2048":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/11\/pgAudit.png",1800,945,false],"ultp_layout_landscape_large":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/11\/pgAudit.png",1200,630,false],"ultp_layout_landscape":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/11\/pgAudit.png",870,457,false],"ultp_layout_portrait":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/11\/pgAudit.png",600,315,false],"ultp_layout_square":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/11\/pgAudit.png",600,315,false]},"rttpg_author":{"display_name":"Venkat Akhil","author_link":"https:\/\/test.opensource-db.in\/wp1\/author\/sudheer-sopensource-db-com\/"},"rttpg_comment":0,"rttpg_category":"<a href=\"https:\/\/test.opensource-db.in\/wp1\/category\/business\/others\/\" rel=\"category tag\">Others<\/a> <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":"PostgreSQL is one of the most robust and flexible relational database management systems available today, offering a wide array of [&hellip;]","_links":{"self":[{"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/posts\/6581","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\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/comments?post=6581"}],"version-history":[{"count":2,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/posts\/6581\/revisions"}],"predecessor-version":[{"id":6587,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/posts\/6581\/revisions\/6587"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/media\/6585"}],"wp:attachment":[{"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/media?parent=6581"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/categories?post=6581"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/tags?post=6581"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}