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(at)pscs(dot)co(dot)uk - 01484 855800
--
Paul Smith Computer Services
Tel: 01484 855800
Vat No: GB 685 6987 53
Sign up for news & updates at http://www.pscs.co.uk/go/subscribe