Re: Separate log_destination, user specific

Поиск
Список
Период
Сортировка
От Paul Smith
Тема Re: Separate log_destination, user specific
Дата
Msg-id 066fa9a8-9e51-dd4d-83e6-4efcc8e36f53@pscs.co.uk
обсуждение исходный текст
Ответ на Separate log_destination, user specific  (Daulat <daulat.dba@gmail.com>)
Ответы Re: Separate log_destination, user specific  (Holger Jakobs <holger@jakobs.com>)
Список pgsql-admin
On 25/01/2022 10:48, Daulat wrote:
Is it possible to set a separate log_destination for some users  in Postgres? 
As I know all actions are recorded under the directory specified by log_destination. 

But I want to create a separate log file for DBA users to log their actions.
Is any third party or free ware tool available to accomplish this task ?


Could you set PostgreSQL to log to Syslog, and then set up filters in rsyslog?
(I've not done it, but it sounds like it may work)


-- 
Paul
Paul Smith Computer Services
support@pscs.co.uk - 01484 855800

--

Paul Smith Computer Services
Tel: 01484 855800
Vat No: GB 685 6987 53

В списке pgsql-admin по дате отправления:

Предыдущее
От: Holger Jakobs
Дата:
Сообщение: Re: Separate log_destination, user specific
Следующее
От: Holger Jakobs
Дата:
Сообщение: Re: Separate log_destination, user specific