Postgres Pro
Downloads
Home   >   mailing lists

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

From Cachique
Subject Re: [ADMIN] auditing in rds or triggers that write to pg_log
Date
Msg-id CAEfeRhX25DY58TKA_3PrsEGsdJRoUscUtaNtBQgHez=Hkar8JQ@mail.gmail.com
Whole thread Raw
In response to [ADMIN] auditing in rds or triggers that write to pg_log  (Mike Broers <mbroers@gmail.com>)
Responses Re: [ADMIN] auditing in rds or triggers that write to pg_log  (Mike Broers <mbroers@gmail.com>)
List pgsql-admin
Tree view
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: ghiureai
Date:
Subject: Re: [ADMIN] cfg pg_stat_statements in PG 9.5 error
Next
From: Mike Broers
Date:
Subject: Re: [ADMIN] auditing in rds or triggers that write to pg_log