Postgres Pro
Downloads
Home   >   mailing lists

Re: Separate log_destination, user specific - Mailing list pgsql-admin

From Paul Smith
Subject Re: Separate log_destination, user specific
Date
Msg-id 066fa9a8-9e51-dd4d-83e6-4efcc8e36f53@pscs.co.uk
Whole thread Raw
In response to Separate log_destination, user specific  (Daulat <daulat.dba@gmail.com>)
Responses Re: Separate log_destination, user specific  (Holger Jakobs <holger@jakobs.com>)
List pgsql-admin
Tree view
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 by date:

Previous
From: Holger Jakobs
Date:
Subject: Re: Separate log_destination, user specific
Next
From: Holger Jakobs
Date:
Subject: Re: Separate log_destination, user specific