MIME-Version: 1.0
References: <CAKeSjMiBZuMX+R3mTmxj-5DUqKN9disMALRnTPv-5B3+CUn6Hg@mail.gmail.com>
 <CAKFQuwYNhgArOxhAXwbf3cY=jmJnKYo8c1R66NLFtAvpmKktCA@mail.gmail.com>
 <CAKeSjMgH1td7Vuz=h_Knf_bP7uBxjFRCHtuMi1Z2+phd3F7kRg@mail.gmail.com> <CAKFQuwYWegiCQeQWtEM6unoAis_R=1JKWxehwJM51LFXegreqg@mail.gmail.com>
In-Reply-To: <CAKFQuwYWegiCQeQWtEM6unoAis_R=1JKWxehwJM51LFXegreqg@mail.gmail.com>
From: Jethish Jethish <jethish777@gmail.com>
Date: Fri, 22 Nov 2024 21:56:30 +0530
Message-ID: <CAKeSjMi_JMbQ9JkwgZUAMnYsaeO37V9Wq4+HvCerMncF_45YsQ@mail.gmail.com>
Subject: Re: PostgreSQL Log Info
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="00000000000016c9e0062782d984"
Archived-At: <https://www.postgresql.org/message-id/CAKeSjMi_JMbQ9JkwgZUAMnYsaeO37V9Wq4%2BHvCerMncF_45YsQ%40mail.gmail.com>
Precedence: bulk

--00000000000016c9e0062782d984
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Sorry guys, what I meant was to log the tuple returned count not the values
to get printed in logs.

On Fri, Nov 22, 2024, 9:46=E2=80=AFPM David G. Johnston <david.g.johnston@g=
mail.com>
wrote:

> On Fri, Nov 22, 2024 at 12:32=E2=80=AFAM Jethish Jethish <jethish777@gmai=
l.com>
> wrote:
>
>> If an select query is fired I need the query returned values needs to be
>> logged in my PostgreSQL log file.
>>
> Then the answer is no, and unlikely to become a feature anyone would
> develop or that we'd accept.
>
> A more innovative solution is going to need to be thought up to
> satisfy the security people that want to know what data was acquired from
> their system by either their users or semi-privileged hackers (privileged
> exploits would likely just disable such logging anyway).  The space of
> setting up a proxy server in between clients and the PostgreSQL server is
> under-explored as a means by which to incorporate such functionality
> externally to the core server.
>
> David J.
>

--00000000000016c9e0062782d984
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto"><p dir=3D"ltr">Sorry guys, what I meant was to log the tu=
ple returned count not the values to get printed in logs.</p></div>
<br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Fri=
, Nov 22, 2024, 9:46=E2=80=AFPM David G. Johnston &lt;<a href=3D"mailto:dav=
id.g.johnston@gmail.com" target=3D"_blank" rel=3D"noreferrer">david.g.johns=
ton@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" sty=
le=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div d=
ir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_default" style=3D"font-fami=
ly:arial,helvetica,sans-serif"><span style=3D"font-family:Arial,Helvetica,s=
ans-serif">On Fri, Nov 22, 2024 at 12:32=E2=80=AFAM Jethish Jethish &lt;<a =
href=3D"mailto:jethish777@gmail.com" rel=3D"noreferrer noreferrer" target=
=3D"_blank">jethish777@gmail.com</a>&gt; wrote:</span></div></div><div clas=
s=3D"gmail_quote"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px=
 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div di=
r=3D"auto"><p dir=3D"ltr">If an select query is fired I need the query retu=
rned values needs to be logged in my PostgreSQL log file.</p></div></blockq=
uote><div class=3D"gmail_default" style=3D"font-family:arial,helvetica,sans=
-serif">Then the answer is no, and unlikely to become a feature anyone woul=
d develop or that we&#39;d accept.</div><div class=3D"gmail_default" style=
=3D"font-family:arial,helvetica,sans-serif"><br></div><div class=3D"gmail_d=
efault" style=3D"font-family:arial,helvetica,sans-serif">A more innovative =
solution is going to need to be thought up to satisfy=C2=A0the=C2=A0securit=
y people that want to know what data was acquired=C2=A0from their system by=
 either their users or semi-privileged hackers (privileged exploits would l=
ikely just disable such logging anyway).=C2=A0 The space of setting up a pr=
oxy server in between clients and the PostgreSQL server is under-explored a=
s a means by which to incorporate such functionality externally to the core=
 server.</div><div class=3D"gmail_default" style=3D"font-family:arial,helve=
tica,sans-serif"><br></div><div class=3D"gmail_default" style=3D"font-famil=
y:arial,helvetica,sans-serif">David J.</div></div></div>
</blockquote></div>

--00000000000016c9e0062782d984--