Re: [ADMIN] auditing in rds or triggers that write to pg_log

Поиск
Список
Период
Сортировка
От Cachique
Тема Re: [ADMIN] auditing in rds or triggers that write to pg_log
Дата
Msg-id CAEfeRhX25DY58TKA_3PrsEGsdJRoUscUtaNtBQgHez=Hkar8JQ@mail.gmail.com
обсуждение исходный текст
Ответ на [ADMIN] auditing in rds or triggers that write to pg_log  (Mike Broers <mbroers@gmail.com>)
Ответы Re: [ADMIN] auditing in rds or triggers that write to pg_log
Список pgsql-admin
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 по дате отправления:

Предыдущее
От: ghiureai
Дата:
Сообщение: Re: [ADMIN] cfg pg_stat_statements in PG 9.5 error
Следующее
От: Mike Broers
Дата:
Сообщение: Re: [ADMIN] auditing in rds or triggers that write to pg_log