Monitoring & auditing

Log suspicious activity:

Failed logins, unusual query patterns (e.g., bulk SELECTs).

Example (PostgreSQL):

ALTER SYSTEM SET log_statement = 'all';  
ALTER SYSTEM SET log_connections = 'on';  

Tools

  • PostgreSQL Audit Extension (pgAudit)

  • MySQL Enterprise Audit


Last update: 2025-05-12 14:39