Re: PostgreSQL Log Info - Mailing list pgsql-general

From Jethish Jethish
Subject Re: PostgreSQL Log Info
Date
Msg-id CAKeSjMi_JMbQ9JkwgZUAMnYsaeO37V9Wq4+HvCerMncF_45YsQ@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL Log Info  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: PostgreSQL Log Info
List pgsql-general

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 <david.g.johnston@gmail.com> wrote:
On Fri, Nov 22, 2024 at 12:32 AM Jethish Jethish <jethish777@gmail.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.

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: PostgreSQL Log Info
Next
From: Adrian Klaver
Date:
Subject: Re: PostgreSQL Log Info