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