From: Paul Smith <paul@pscs.co.uk>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Separate log_destination, user specific
Date: Tue, 25 Jan 2022 10:57:48 +0000
Message-ID: <066fa9a8-9e51-dd4d-83e6-4efcc8e36f53@pscs.co.uk> (raw)
In-Reply-To: <CALfOM6KLFk_YVv5Css6sT3nr9F3spd+VNzTS6C9jREJtQ=SGFA@mail.gmail.com>
References: <CALfOM6KLFk_YVv5Css6sT3nr9F3spd+VNzTS6C9jREJtQ=SGFA@mail.gmail.com>
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
Sign up for news & updates at http://www.pscs.co.uk/go/subscribe
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: paul@pscs.co.uk, pgsql-admin@lists.postgresql.org
Subject: Re: Separate log_destination, user specific
In-Reply-To: <066fa9a8-9e51-dd4d-83e6-4efcc8e36f53@pscs.co.uk>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox