Re: [HACKERS] Database Auditing

[Marco Serantoni]

I'm evaluating of use postgresql but for local law requirements is
needed for the access of some kind of data (sensitive) a log of the
accesses (Auditing) is a feature available in many databases but i've
seen that lacks in PostgreSQL, there are already plans to implement it
or patches already submitted ?
If not both could someone give me some hints on how do it

we can probably come up with something.  can you please give specific
requirements about what type of information you have to keep track of?

username, date and statement executed and optionally the IP.



---(end of broadcast)---
TIP 4: Have you searched our list archives?

  http://archives.postgresql.org

[HACKERS] Database Auditing

[Marco Serantoni]

I'm evaluating of use postgresql but for local law requirements is 
needed for the access of some kind of data (sensitive) a log of the 
accesses (Auditing) is a feature available in many databases but i've 
seen that lacks in PostgreSQL, there are already plans to implement it 
or patches already submitted ?
If not both could someone give me some hints on how do it and where 
"attach" the code like open the file in postmaster.c intercept the query 
in that function etc.


Thank you in advance :)



---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster