Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

How to enable Audit Trail on PostgreSQL

Tags:

postgresql

postgresql-9.1

database-administration

I am currently using PostgreSQL 9.1. I want to enable pg Audit Trail.

Can someone please help me with that as I am totally new on this thing.

like image 544
Anurag Anand Avatar asked Oct 29 '22 03:10

Anurag Anand

1 Answers

There is no audit functionality available by default in the opensource postgresql database. You can check out edb_audit from Enterprisedb postgres for creating audit logs.

Or check out the pgAudit extension for the opensource version.

like image 196
Lohit Gupta Avatar answered Nov 09 '22 10:11

Lohit Gupta
Sign in to Comment

Related questions

Pairing Sequential Events on Postgresql
Postgis syntax PARALLEL error
org.postgresql.util.PSQLException: The server does not support SSL
PhpStorm saying PostgreSQL database does not exist?
Why are Postgres lookups on jsonb columns so slow?
Pyspark: Remove UTF null character from pyspark dataframe
PostgreSQL aggregate nodes recursively
Golang gorm time data type conversion
Postgres - Run same query on all databases (same schemas)
Importing CSV data into Rails app, using something other then the association "id"
How to set up a website with a PostgreSQL database?
Entity Framework Core, error Postgres violates foreign key constraint
Knex with Postgres storing timestamp in unintended ways
Pgbouncer log shows only 0 req/s
Smart logic queries performance inside functions for PostgreSQL
Slow indexing of 300GB Postgis table
How to import PostgreSQL database dump via node and pg
Error spatially subsetting and PostGIS database
Why actual time in EXPLAIN result is different with every execution in PostgreSQL?
Check for value with current_setting()

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!