Re: [ADMIN] Passwords in clear text in server log - Mailing list pgsql-admin

From Don Seiler
Subject Re: [ADMIN] Passwords in clear text in server log
Date
Msg-id CAHJZqBBuYaT5YTv_EaiB_b4-HA8y84eahJbfKfmtpGDfVP6RkQ@mail.gmail.com
Whole thread Raw
In response to Re: [ADMIN] Passwords in clear text in server log  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [ADMIN] Passwords in clear text in server log  (Stephen Frost <sfrost@snowman.net>)
List pgsql-admin
On Wed, Oct 11, 2017 at 3:01 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
We have heard many times from people who don't have enough insight, or
enough debug support client-side, to know exactly what queries their
apps are issuing.  Disabling query logging would be a horrible setback
for debuggability of such apps.  How many times have you said "consult
the postmaster log to find out what's going on"?

Not logging statements that fail to parse isn't the same as disabling query logging. If a statement fails to parse it can't really be considered a query in my opinion. When it fails to parse it *should* send a loud-and-clear error to whatever client-side application sent it. Granted a lazy developer could code their app to swallow all errors, but then I'd say they deserve the headache.

--
Don Seiler
www.seiler.us

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: [ADMIN] Passwords in clear text in server log
Next
From: "Williams, Alex"
Date:
Subject: Re: [ADMIN] Passwords in clear text in server log