Обсуждение: logging proxy

Поиск
Список
Период
Сортировка

logging proxy

От
Олег Самойлов
Дата:
Does anyone know PostgresQL proxy which can log queries with username, ip and affected rows for security reason.
PostgresQLitself can log almost all, except affected rows. 


Re: logging proxy

От
Bruce Momjian
Дата:
On Fri, Nov 1, 2019 at 01:58:10AM +0300, Олег Самойлов
wrote:
> Does anyone know PostgresQL proxy which can log queries with username,
> ip and affected rows for security reason. PostgresQL itself can log
> almost all, except affected rows.

You can use the server logs to get the non-row information, then use
streaming replication with logical decoding to get the rows for each
transaction started by the user.

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+                      Ancient Roman grave inscription +