Sample Header Ad - 728x90

Log every time users access a certain table in Postgres

2 votes
1 answer
332 views
Recently we changed our production database log_statement from 'all' to 'mod', because the resulting log file was too large for our available storage. Unfortunately, we still need to log every SELECT made by users to a specific table N for audit purposes. Is there any solution for that? I have tried using pgaudit and pg_stat_statements without any success. We have set pgaudit.log to read, but it logs every SELECT query instead of just selects to table N.
Asked by Ilham Syamsuddin (35 rep)
Dec 10, 2024, 05:24 AM
Last activity: Dec 10, 2024, 10:22 AM