RE: [HACKERS] Client Connection redirection support for PostgreSQL

Поиск
Список
Период
Сортировка
От Satyanarayana Narlapuram
Тема RE: [HACKERS] Client Connection redirection support for PostgreSQL
Дата
Msg-id MWHPR21MB08293E49A3060302567CA21991DA0@MWHPR21MB0829.namprd21.prod.outlook.com
обсуждение исходный текст
Ответ на Re: [HACKERS] Client Connection redirection support for PostgreSQL  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: [HACKERS] Client Connection redirection support for PostgreSQL  (Heikki Linnakangas <hlinnaka@iki.fi>)
Список pgsql-hackers
Please see the attached patch with the comments.

Changes in the patch:
    A client-side PGREDIRECTLIMIT parameter has been introduced to control the maximum number of retries. 
    BE_v3.1 sends a ProtocolNegotiation message. FE_v3.1 downgrades to v3.0 upon receipt of this message.
    FE falls back to v3.0 if 3.1 is not supported by the server.


    >> I hadn't really thought deeply about whether redirection should happen before or after authentication.  For the
mostpart, before seems better, because it seems a bit silly to force people to authenticate just so that you can tell
themto go someplace else.  Also, that would lead to double authentication,          which might for example result in
multiplepassword prompts, which users might either dislike or find confusing.  
 

    Yes, redirection before authentication would avoid multiple password prompts.

Thanks,
Satya

Вложения

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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: JIT compiling with LLVM v11
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: pg_get_functiondef forgets about most GUC_LIST_INPUT GUCs