Postgres Pro
Downloads
Home   >   mailing lists

[ADMIN] auditing in rds or triggers that write to pg_log - Mailing list pgsql-admin

From Mike Broers
Subject [ADMIN] auditing in rds or triggers that write to pg_log
Date
Msg-id CAB9893h8UtjocK+7EtvVEiYhW489oY7DN_ojKJppQniivKWjvQ@mail.gmail.com
Whole thread Raw
Responses Re: [ADMIN] auditing in rds or triggers that write to pg_log  (Cachique <cachique@gmail.com>)
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: [ADMIN] cfg pg_stat_statements in PG 9.5 error
Next
From: ghiureai
Date:
Subject: Re: [ADMIN] cfg pg_stat_statements in PG 9.5 error