Message-ID: <8cca2a2c-9a05-5915-137d-4719f72623b6@jakobs.com>
Date: Tue, 25 Jan 2022 11:55:55 +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>
From: Holger Jakobs <holger@jakobs.com>
In-Reply-To: 
 <CALfOM6KLFk_YVv5Css6sT3nr9F3spd+VNzTS6C9jREJtQ=SGFA@mail.gmail.com>
Content-Type: multipart/signed; micalg=pgp-sha256;
 protocol="application/pgp-signature";
 boundary="------------aD2cveDpnEpmWWLO0KrvlSWE"
Archived-At: 
 <https://www.postgresql.org/message-id/8cca2a2c-9a05-5915-137d-4719f72623b6%40jakobs.com>
Precedence: bulk

This is an OpenPGP/MIME signed message (RFC 4880 and 3156)
--------------aD2cveDpnEpmWWLO0KrvlSWE
Content-Type: multipart/mixed; boundary="------------JeFlZZJOZO8hKvfCTjF0k3lk";
 protected-headers="v1"
From: Holger Jakobs <holger@jakobs.com>
To: pgsql-admin@lists.postgresql.org
Message-ID: <8cca2a2c-9a05-5915-137d-4719f72623b6@jakobs.com>
Subject: Re: Separate log_destination, user specific
References: <CALfOM6KLFk_YVv5Css6sT3nr9F3spd+VNzTS6C9jREJtQ=SGFA@mail.gmail.com>
In-Reply-To: <CALfOM6KLFk_YVv5Css6sT3nr9F3spd+VNzTS6C9jREJtQ=SGFA@mail.gmail.com>

--------------JeFlZZJOZO8hKvfCTjF0k3lk
Content-Type: multipart/alternative;
 boundary="------------ffDmG7lvV5aUE08fmKaL5CkJ"

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

QW0gMjUuMDEuMjIgdW0gMTE6NDggc2NocmllYiBEYXVsYXQ6DQo+IEhlbGxvIFRlYW0sDQo+
DQo+IElzIGl0IHBvc3NpYmxlIHRvIHNldCBhIHNlcGFyYXRlIGxvZ19kZXN0aW5hdGlvbiBm
b3Igc29tZSB1c2Vyc8KgIGluIA0KPiBQb3N0Z3Jlcz8NCj4gQXMgSSBrbm93IGFsbCBhY3Rp
b25zIGFyZSByZWNvcmRlZCB1bmRlciB0aGUgZGlyZWN0b3J5wqBzcGVjaWZpZWQgDQo+IGJ5
wqBsb2dfZGVzdGluYXRpb24uDQo+DQo+IEJ1dCBJIHdhbnQgdG8gY3JlYXRlIGEgc2VwYXJh
dGUgbG9nIGZpbGUgZm9yIERCQSB1c2VycyB0byBsb2cgdGhlaXIgDQo+IGFjdGlvbnMuDQo+
IElzIGFueSB0aGlyZCBwYXJ0eSBvciBmcmVlIHdhcmUgdG9vbCBhdmFpbGFibGUgdG8gYWNj
b21wbGlzaCB0aGlzIHRhc2sgPw0KPg0KPiBQbGVhc2Ugc3VnZ2VzdCAhDQo+DQo+IFRoYW5r
cywNCj4NClRoZXJlIGlzIG5vIHNldHRpbmcgZm9yIHRoaXMsIGJ1dCBvZiBjb3Vyc2UgeW91
IGNhbiBzZXQgdXAgYSBwcm9jZXNzIA0Kd2hpY2ggaXMgYWx3YXlzIHdhdGNoaW5nIHRoZSBs
b2cgYW5kIGNvcHlpbmcgbWVzc2FnZXMgYnkgdXNlciAob3Igb3RoZXIgDQpjcml0ZXJpYSkg
dG8gb3RoZXIgZmlsZXMuDQoNCk1ha2Ugc3VyZSB0aGF0IGluIGNhc2Ugb2YgbG9nIHJvdGF0
aW9uIHlvdXIgcHJvY2VzcyBzd2l0Y2hlcyB0byB0aGUgbmV3IA0KY3VycmVudCBsb2cgZmls
ZS4NCg0KDQotLSANCkhvbGdlciBKYWtvYnMsIEJlcmdpc2NoIEdsYWRiYWNoLCBUZWwuICs0
OS0xNzgtOTc1OTAxMg0KDQo=
--------------ffDmG7lvV5aUE08fmKaL5CkJ
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:48 schrieb Daulat:<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=3DU=
TF-8">
      <div dir=3D"ltr">Hello Team,<br>
        <div><br>
        </div>
        <div>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>
        <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><br>
        </div>
        <div>Please suggest !=C2=A0</div>
        <div><br>
        </div>
        <div>Thanks,</div>
        <div><br>
        </div>
      </div>
    </blockquote>
    <p>There is no setting for this, but of course you can set up a
      process which is always watching the log and copying messages by
      user (or other criteria) to other files.</p>
    <p>Make sure that in case of log rotation your process switches to
      the new current log file.</p>
    <p><br>
    </p>
    <pre class=3D"moz-signature" cols=3D"72">--=20
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012</pre>
  </body>
</html>
--------------ffDmG7lvV5aUE08fmKaL5CkJ--


--------------JeFlZZJOZO8hKvfCTjF0k3lk--

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

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

wmMEABEIACMWIQScuJCxWJK1p5BOebGKV5yTsxlhugUCYe/XOwUDAAAAAAAKCRCKV5yTsxlhuusw
AJ9psdZs4ehT+SOS6OVXcE0MM6XXbACgy3jYH9uDO/Pusv6eBbtoPqD2/i0=
=uRBz
-----END PGP SIGNATURE-----

--------------aD2cveDpnEpmWWLO0KrvlSWE--