Questions tagged [pgaudit]
6 questions
1
vote
0 answers
Avoid big data in audit logs with sqlalchemy
I need to store some big binary data in a Postgresql database. I also need to have an audit log for this database. But I do not need, and not want, the binary data in the audit logs.
I am accessing the database with python via sqlalchemy.
Is there a…
Hans
- 101
- 4
1
vote
1 answer
pgAudit not logging anything in GCP Cloud SQL
I'm hoping for some insight into a problem I'm having with using pgAudit for a PostgreSQL 12 managed instance in GCP Cloud SQL.
Thus far, I've done the following to set this up:
Database…
David Sigman
- 46
- 5
1
vote
0 answers
PostgreSQL 13 capture audit logs of actual IP address
I am working on configuring PgAudit on my PostgreSQL database so when my clients access my PostgreSQL, it will capture a log of the action they perform.
My Client PC have got their actual IP address and a VPN connection address, the VPN connects to…
xxestter
- 441
- 7
- 19
0
votes
0 answers
Limit Session Audit logging to certain relations pgAudit extension for RDS PostgreSQL
I have a use case to log queries executed by certain users only on certain relations.
By using pgaudit extension, certain users can be excluded or included in the logs via session audit logging:
ALTER USER myuser SET pgaudit.log TO 'NONE';
Using…
huehue
- 50
- 5
0
votes
0 answers
PgAudit on AlmaLinux9
I'm trying to install PgAudit on a virtual machine with Alma Linux 9, i already installed postgresql 15.2, i followed the steps provided at github but at the last step, when i try to execute this:
[root@localhost pgaudit]# make install USE_PGXS=1…
DmonKGg
- 1
- 1
0
votes
1 answer
Postgres Audit - How to get information on who is performing the DDL operation?
I'm trying to enable pgaudit in an Azure Postgres Single Server. I have followed the instructions provided by Microsoft and also the documentation of Postgres.
These are my settings ( the 2 Selected in the picture below are DDL and ROLE )
Log…
Roberto Hernandez
- 8,231
- 3
- 14
- 43