Is there some tutorial on how to set up pg_audit? Maybe also something with an interface where the logs can be queried?
But I am very obsessed with building loggers using Postgres. There are some sneak peaks of my work on Twitter you can find in the above comment. But it's a lot of work to just setup pgAudit on AWS RDS. Like literally takes days. Basically you have to enable pgAudit, for that you need to edit the DBParameterGroup. Then enable cloudwatchlogs and query from cloudwatch console what logs you want to see. It's a mess. But here is a sneak peek of what's cooking at rocketgraph: https://twitter.com/RGraphql/status/1689631592321544192
It's so beautiful that I'm gonna name it "the sexy release".