pgsql: Avoid logging complaints about abandoned connections when using

Поиск
Список
Период
Сортировка
От Tom Lane
Тема pgsql: Avoid logging complaints about abandoned connections when using
Дата
Msg-id E1iS4WG-0001L2-9X@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Avoid logging complaints about abandoned connections when using PAM.

For a long time (since commit aed378e8d) we have had a policy to log
nothing about a connection if the client disconnects when challenged
for a password.  This is because libpq-using clients will typically
do that, and then come back for a new connection attempt once they've
collected a password from their user, so that logging the abandoned
connection attempt will just result in log spam.  However, this did
not work well for PAM authentication: the bottom-level function
pam_passwd_conv_proc() was on board with it, but we logged messages
at higher levels anyway, for lack of any reporting mechanism.
Add a flag and tweak the logic so that the case is silent, as it is
for other password-using auth mechanisms.

Per complaint from Yoann La Cancellera.  It's been like this for awhile,
so back-patch to all supported branches.

Discussion: https://postgr.es/m/CACP=ajbrFFYUrLyJBLV8=q+eNCapa1xDEyvXhMoYrNphs-xqPw@mail.gmail.com

Branch
------
REL9_4_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/762b25653808897f013390ef55b9c7f80864a790

Modified Files
--------------
src/backend/libpq/auth.c | 26 +++++++++++++++++---------
1 file changed, 17 insertions(+), 9 deletions(-)


В списке pgsql-committers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: pgsql: Fix "unexpected relkind" error when denying permissions on toast
Следующее
От: Andres Freund
Дата:
Сообщение: pgsql: Split all OBJS style lines in makefiles into one-line-per-entry