auditing in rds or triggers that write to pg_log

From: Mike Broers <mbroers(at)gmail(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: auditing in rds or triggers that write to pg_log
Date: 2017-03-09 17:37:17
Message-ID: CAB9893h8UtjocK+7EtvVEiYhW489oY7DN_ojKJppQniivKWjvQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I'm investigating ways to track all interactions with certain tables in
postgres. pgaudit seems like a great solution but it doesnt look like its
a supported extension in rds yet.

I've considered creating triggers that record interactions into the
standard postgresql log file but I cant find examples of this approach,
only examples that write to tables. Is it possible to do this?

Thanks
Mike

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message ghiureai 2017-03-09 17:49:04 Re: cfg pg_stat_statements in PG 9.5 error
Previous Message Tom Lane 2017-03-09 17:11:56 Re: cfg pg_stat_statements in PG 9.5 error