Re: auditing in rds or triggers that write to pg_log

[Mike Broers <mbroers@xxxxxxxxx>]

I think this is exactly what i was looking for, thanks!!

On Thu, Mar 9, 2017 at 11:49 AM, Cachique <cachique@xxxxxxxxx> wrote:

Hi Mike.

In any of your plpgsql function you can use RAISE LOG 'Blah, Blah...' the same way you use RAISE NOTICE.

All this text go directly to your standard postgresql log file.

Regards,

Walter

On Thu, Mar 9, 2017 at 2:37 PM, Mike Broers <mbroers@xxxxxxxxx> wrote:

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