Обсуждение: what to log in csvlogs

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

what to log in csvlogs

От
Mary Johnson
Дата:
Hi, 

Can you please let me know if we can control what to log when log destination is 'csvlog'? 
Also, can we control when to log to display only select queries of a few specific tables? 

Thanks, 
mary

Re: what to log in csvlogs

От
Adrian Klaver
Дата:
On 5/10/20 11:27 AM, Mary Johnson wrote:
> Hi,
> 
> Can you please let me know if we can control what to log when log 
> destination is 'csvlog'?

No, it is set to the fields described here:

https://www.postgresql.org/docs/12/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-CSVLOG

What is in those fields is determined by the settings mentioned in the 
link above.

> Also, can we control when to log to display only select queries of a few 
> specific tables?

Not with the built in logger.
Other folks maybe able to point you at third party software that can do 
this.

> 
> Thanks,
> mary


-- 
Adrian Klaver
adrian.klaver@aklaver.com



SV: what to log in csvlogs

От
Niels Jespersen
Дата:

 

 

Fra: Mary Johnson <mary.johnson1812@gmail.com>
Sendt: 10. maj 2020 20:27
Til: pgsql-general@postgresql.org
Emne: what to log in csvlogs

 

Hi, 

 

Can you please let me know if we can control what to log when log destination is 'csvlog'? 

Also, can we control when to log to display only select queries of a few specific tables? 

 

Thanks, 

Mary

 

The Pgaudit extension will let you audit specific actions to specific tables.

 

Regard Niels Jespersen