From: Tom Lane <tgl@sss.pgh.pa.us>
To: Indrajeeth Deshmukh <bkindrajeeth@gmail.com>
cc: David Rowley <dgrowleyml@gmail.com>, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18817: Security Bug Report: Plaintext Password Exposure in
 Logs
In-reply-to: 
 <CAAapt1i2Mf=S0FtPz8Z9RNkez=nP50AcYDVC7Dm8r=cskMn7tg@mail.gmail.com>
References: <18817-771682052a364bfe@postgresql.org>
 <CAApHDvoCnaLeVO4zdCaYJFBfcuGXYz1W5L917p526nWEcs=gqg@mail.gmail.com>
 <CAAapt1i2Mf=S0FtPz8Z9RNkez=nP50AcYDVC7Dm8r=cskMn7tg@mail.gmail.com>
Comments: In-reply-to Indrajeeth Deshmukh <bkindrajeeth@gmail.com>
	message dated "Tue, 18 Feb 2025 18:22:36 +0530"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <1241093.1739893072.1@sss.pgh.pa.us>
Date: Tue, 18 Feb 2025 10:37:52 -0500
Message-ID: <1241094.1739893072@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/1241094.1739893072%40sss.pgh.pa.us>
Precedence: bulk

Indrajeeth Deshmukh <bkindrajeeth@gmail.com> writes:
> Thanks for sharing the details. It looks like a valid issue and has not
> been resolved yet. Currently, the solution is keeping the file remains
> secure, but when it comes to SIEM monitoring, it will be a major concern.
> Any thoughts on this?

The real bottom-line answer to that is that passwords are just the
tip of the iceberg.  The server log is likely to contain other
critical information depending on your application; consider credit
card numbers, HIPAA-protected medical details, etc.  The server
has no way at all to know which fields might be sensitive in that
way.  Even if we had some notion of which fields to hide, in cases
like statements with syntax errors, we couldn't reliably identify
which parts of a query string are sensitive.

The only solution is to treat the server log files with the same
amount of care as you give to the database files themselves.
Or send them to /dev/null, but that's unlikely to be very workable
in practice.

Independently of that, best practice is to never send cleartext
passwords to the server in the first place.  psql has support
for setting a password without that, and I think libpq does too.

			regards, tom lane