Message-ID: <d42de064-3f13-32c0-a02e-a5a0c3792ff5@jakobs.com>
Date: Tue, 25 Jan 2022 12:00:44 +0100
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101
 Thunderbird/91.3.2
Subject: Re: Separate log_destination, user specific
Content-Language: de-DE
To: pgsql-admin@lists.postgresql.org
References: 
 <CALfOM6KLFk_YVv5Css6sT3nr9F3spd+VNzTS6C9jREJtQ=SGFA@mail.gmail.com>
 <066fa9a8-9e51-dd4d-83e6-4efcc8e36f53@pscs.co.uk>
From: Holger Jakobs <holger@jakobs.com>
In-Reply-To: <066fa9a8-9e51-dd4d-83e6-4efcc8e36f53@pscs.co.uk>
Content-Type: multipart/signed; micalg=pgp-sha256;
 protocol="application/pgp-signature";
 boundary="------------ELMpVrbTnp0k2oPme90L9wvF"
Archived-At: 
 <https://www.postgresql.org/message-id/d42de064-3f13-32c0-a02e-a5a0c3792ff5%40jakobs.com>
Precedence: bulk

This is an OpenPGP/MIME signed message (RFC 4880 and 3156)
--------------ELMpVrbTnp0k2oPme90L9wvF
Content-Type: multipart/mixed; boundary="------------BNvungpLEKGrJcT6acPRfJps";
 protected-headers="v1"
From: Holger Jakobs <holger@jakobs.com>
To: pgsql-admin@lists.postgresql.org
Message-ID: <d42de064-3f13-32c0-a02e-a5a0c3792ff5@jakobs.com>
Subject: Re: Separate log_destination, user specific
References: <CALfOM6KLFk_YVv5Css6sT3nr9F3spd+VNzTS6C9jREJtQ=SGFA@mail.gmail.com>
 <066fa9a8-9e51-dd4d-83e6-4efcc8e36f53@pscs.co.uk>
In-Reply-To: <066fa9a8-9e51-dd4d-83e6-4efcc8e36f53@pscs.co.uk>

--------------BNvungpLEKGrJcT6acPRfJps
Content-Type: multipart/alternative;
 boundary="------------eNC7Gjn8GmNh2eElW0e8g9Dc"

--------------eNC7Gjn8GmNh2eElW0e8g9Dc
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: base64

QW0gMjUuMDEuMjIgdW0gMTE6NTcgc2NocmllYiBQYXVsIFNtaXRoOg0KPiBPbiAyNS8wMS8y
MDIyIDEwOjQ4LCBEYXVsYXQgd3JvdGU6DQo+PiBJcyBpdCBwb3NzaWJsZSB0byBzZXQgYSBz
ZXBhcmF0ZSBsb2dfZGVzdGluYXRpb24gZm9yIHNvbWUgdXNlcnPCoCBpbiANCj4+IFBvc3Rn
cmVzPw0KPj4gQXMgSSBrbm93IGFsbCBhY3Rpb25zIGFyZSByZWNvcmRlZCB1bmRlciB0aGUg
ZGlyZWN0b3J5wqBzcGVjaWZpZWQgDQo+PiBiecKgbG9nX2Rlc3RpbmF0aW9uLg0KPj4NCj4+
IEJ1dCBJIHdhbnQgdG8gY3JlYXRlIGEgc2VwYXJhdGUgbG9nIGZpbGUgZm9yIERCQSB1c2Vy
cyB0byBsb2cgdGhlaXIgDQo+PiBhY3Rpb25zLg0KPj4gSXMgYW55IHRoaXJkIHBhcnR5IG9y
IGZyZWUgd2FyZSB0b29sIGF2YWlsYWJsZSB0byBhY2NvbXBsaXNoIHRoaXMgdGFzayA/DQo+
DQo+DQo+IENvdWxkIHlvdSBzZXQgUG9zdGdyZVNRTCB0byBsb2cgdG8gU3lzbG9nLCBhbmQg
dGhlbiBzZXQgdXAgZmlsdGVycyBpbiANCj4gcnN5c2xvZz8NCj4gKEkndmUgbm90IGRvbmUg
aXQsIGJ1dCBpdCBzb3VuZHMgbGlrZSBpdCBtYXkgd29yaykNCj4NCj4NClVzaW5nIHN5c2xv
ZyBpcyBub3QgYWR2aXNhYmxlLiBRdXRvZSBmcm9tIA0KaHR0cHM6Ly93d3cucG9zdGdyZXNx
bC5vcmcvZG9jcy9jdXJyZW50L3J1bnRpbWUtY29uZmlnLWxvZ2dpbmcuaHRtbA0KDQpUaGUg
bG9nZ2luZyBjb2xsZWN0b3IgaXMgZGVzaWduZWQgdG8gbmV2ZXIgbG9zZSBtZXNzYWdlcy4g
VGhpcyBtZWFucyANCnRoYXQgaW4gY2FzZSBvZiBleHRyZW1lbHkgaGlnaCBsb2FkLCBzZXJ2
ZXIgcHJvY2Vzc2VzIGNvdWxkIGJlIGJsb2NrZWQgDQp3aGlsZSB0cnlpbmcgdG8gc2VuZCBh
ZGRpdGlvbmFsIGxvZyBtZXNzYWdlcyB3aGVuIHRoZSBjb2xsZWN0b3IgaGFzIA0KZmFsbGVu
IGJlaGluZC4gSW4gY29udHJhc3QsIHN5c2xvZyBwcmVmZXJzIHRvIGRyb3AgbWVzc2FnZXMg
aWYgaXQgY2Fubm90IA0Kd3JpdGUgdGhlbSwgd2hpY2ggbWVhbnMgaXQgbWF5IGZhaWwgdG8g
bG9nIHNvbWUgbWVzc2FnZXMgaW4gc3VjaCBjYXNlcyANCmJ1dCBpdCB3aWxsIG5vdCBibG9j
ayB0aGUgcmVzdCBvZiB0aGUgc3lzdGVtLg0KDQpEbyB5b3UgcmVhbGx5IHdhbnQgdG8gbG9z
ZSBtZXNzYWdlcz8/DQoNCg==
--------------eNC7Gjn8GmNh2eElW0e8g9Dc
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<html>
  <head>
    <meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3DUTF=
-8">
  </head>
  <body>
    <div class=3D"moz-cite-prefix">Am 25.01.22 um 11:57 schrieb Paul
      Smith:<br>
    </div>
    <blockquote type=3D"cite"
      cite=3D"mid:066fa9a8-9e51-dd4d-83e6-4efcc8e36f53@pscs.co.uk">
      <meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3DU=
TF-8">
      <div class=3D"moz-cite-prefix">On 25/01/2022 10:48, Daulat wrote:<b=
r>
      </div>
      <blockquote type=3D"cite"
cite=3D"mid:CALfOM6KLFk_YVv5Css6sT3nr9F3spd+VNzTS6C9jREJtQ=3DSGFA@mail.gm=
ail.com">
        <meta http-equiv=3D"content-type" content=3D"text/html;
          charset=3DUTF-8">
        <div dir=3D"ltr">Is it possible to set a separate=C2=A0<span
style=3D"background-color:transparent;color:inherit;font-family:inherit;f=
ont-size:inherit;font-weight:inherit">log_destination
            for some users=C2=A0 in Postgres?=C2=A0</span>
          <div>As I know all actions are recorded under the
            directory=C2=A0specified by=C2=A0log_destination.=C2=A0<br>
          </div>
          <div><br>
          </div>
          <div>But I want to create a separate log file for DBA users to
            log their actions.</div>
          <div>Is any third party or free ware tool available to
            accomplish this task ?</div>
        </div>
      </blockquote>
      <p><br>
      </p>
      <p>Could you set PostgreSQL to log to Syslog, and then set up
        filters in rsyslog?<br>
        (I've not done it, but it sounds like it may work)<br>
      </p>
      <br>
    </blockquote>
    <p>Using syslog is not advisable. Qutoe from
      <a class=3D"moz-txt-link-freetext" href=3D"https://www.postgresql.o=
rg/docs/current/runtime-config-logging.html">https://www.postgresql.org/d=
ocs/current/runtime-config-logging.html</a><br>
    </p>
    <p>The logging collector is designed to never lose messages. This
      means that in case of extremely high load, server processes could
      be blocked while trying to send additional log messages when the
      collector has fallen behind. In contrast, <span
        class=3D"application">syslog</span> prefers to drop messages if i=
t
      cannot write them, which means it may fail to log some messages in
      such cases but it will not block the rest of the system.</p>
    <p>Do you really want to lose messages??<br>
    </p>
  </body>
</html>
--------------eNC7Gjn8GmNh2eElW0e8g9Dc--


--------------BNvungpLEKGrJcT6acPRfJps--

--------------ELMpVrbTnp0k2oPme90L9wvF
Content-Type: application/pgp-signature; name="OpenPGP_signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="OpenPGP_signature"

-----BEGIN PGP SIGNATURE-----

wmMEABEIACMWIQScuJCxWJK1p5BOebGKV5yTsxlhugUCYe/YXAUDAAAAAAAKCRCKV5yTsxlhuvER
AJ9PFeGX4ksDYnBBw3ofhITnQjllfwCfXSD05YIlmCZxNstbLOEe31gIIAQ=
=GTAi
-----END PGP SIGNATURE-----

--------------ELMpVrbTnp0k2oPme90L9wvF--