Re: auditing in rds or triggers that write to pg_log

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

On Thu, Mar 9, 2017 at 11:49 AM, Cachique <cachique(at)gmail(dot)com> 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(at)gmail(dot)com> 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
>>
>>
>