Auditing

 
  • Can be very simple:
  • - when it happened
  • - what happened
  • - who did it
  • - IP address
  • - relations affected

Next


 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Auditing

 
  • Costs almost nothing, very nice thing to have
  • Application could do it too, but: close to the data
  • Everyone can see who made changes
  • Can also see all changes, whether it happens via psql, DBD::Pg, libpq, etc
  • Triggers, functions, automated script, PL language

Next


 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Database down

 
  • Q: What if the database goes down?
  • A: You have bigger things to worry about. Today's DBs are solid
      Last             TOC             Next