how can enable audit trail on postgres to audit users and queries that run on database
i have enable log_statment to all and install pg_audit
but how can i select this data from table like audit trail on oracle database
i need help for this urgent
Hello,
You’ll need to set the auditing parameters according to your requirement in the postgresql.conf file.
Refer to the Settings section of this https://github.com/pgaudit/pgaudit page for more details about the pgaudit parameter settings.
Next, You will see the pgaudit auditing logs in the Postgres default log directory.
Thanks.