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

From Mike Broers
Subject Re: [ADMIN] auditing in rds or triggers that write to pg_log
Date
Msg-id CAB9893h3hAf7DUi=mTMXXqHZLjbe35DKcveZAVSMv19UKjFW=Q@mail.gmail.com
Whole thread Raw
In response to Re: [ADMIN] auditing in rds or triggers that write to pg_log  (Cachique <cachique@gmail.com>)
Responses Re: [ADMIN] auditing in rds or triggers that write to pg_log  (Cachique <cachique@gmail.com>)
List pgsql-admin
I think this is exactly what i was looking for, thanks!!

On Thu, Mar 9, 2017 at 11:49 AM, Cachique <cachique@gmail.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@gmail.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



pgsql-admin by date:

Previous
From: Cachique
Date:
Subject: Re: [ADMIN] auditing in rds or triggers that write to pg_log
Next
From: Tom Lane
Date:
Subject: Re: [ADMIN] cfg pg_stat_statements in PG 9.5 error