public inbox for [email protected]  

help / color / mirror / Atom feed

From: Jethish Jethish <[email protected]>
To: David G. Johnston <[email protected]>
Cc: [email protected]
Subject: Re: PostgreSQL Log Info
Date: Fri, 22 Nov 2024 21:56:30 +0530
Message-ID: <CAKeSjMi_JMbQ9JkwgZUAMnYsaeO37V9Wq4+HvCerMncF_45YsQ@mail.gmail.com> (raw)
In-Reply-To: <CAKFQuwYWegiCQeQWtEM6unoAis_R=1JKWxehwJM51LFXegreqg@mail.gmail.com>
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>

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 PM David G. Johnston <[email protected]>
wrote:

> On Fri, Nov 22, 2024 at 12:32 AM Jethish Jethish <[email protected]>
> 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.
>

view thread (9+ messages)  latest in thread

reply

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: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: PostgreSQL Log Info
  In-Reply-To: <CAKeSjMi_JMbQ9JkwgZUAMnYsaeO37V9Wq4+HvCerMncF_45YsQ@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox