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

From Tom Lane
Subject Re: [ADMIN] Passwords in clear text in server log
Date
Msg-id 23672.1507752070@sss.pgh.pa.us
Whole thread Raw
In response to Re: [ADMIN] Passwords in clear text in server log  (Ervin Weber <webervin@gmail.com>)
Responses Re: [ADMIN] Passwords in clear text in server log  (Don Seiler <don@seiler.us>)
Re: [ADMIN] Passwords in clear text in server log  ("Williams, Alex" <awilliams@teamdrg.com>)
List pgsql-admin
Ervin Weber <webervin@gmail.com> writes:
> Alvaro Herrera  wrote:
>> Actually, I do wonder why we log statements that fail to parse.  Surely
>> the client ought to know that it failed, but what is the value of
>> additionally storing the query in the server log?

> To debug clients who claim it is working on their end, but data does not change.

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"?
        regards, tom lane


--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

pgsql-admin by date:

Previous
From: Ervin Weber
Date:
Subject: Re: [ADMIN] Passwords in clear text in server log
Next
From: Don Seiler
Date:
Subject: Re: [ADMIN] Passwords in clear text in server log