Re: [PATCH] pgpassfile connection option

Поиск
Список
Период
Сортировка
От Mithun Cy
Тема Re: [PATCH] pgpassfile connection option
Дата
Msg-id CAD__OuiyrBYsD_h-bLZN4Cb2GJNk7+uonm2g=fxoCGHbhansWA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [PATCH] pgpassfile connection option  (Fabien COELHO <coelho@cri.ensmp.fr>)
Ответы Re: [PATCH] pgpassfile connection option  (Julian Markwort <julian.markwort@uni-muenster.de>)
Список pgsql-hackers
 > Independently of your patch, while testing I concluded that the multi-host feature and documentation should be improved:
 > - If a connection fails, it does not say for which host/port.

Thanks I will re-test same.

> In fact they are tried in turn if the network connection fails, but not
> if the connection fails for some other reason such as the auth.
> The documentation is not precise enough.

If we fail due to authentication, then I think we should notify the client instead of trying next host. I think it is expected genuine user have right credentials for making the connection. So it's better if we notify same to client immediately rather than silently ignoring them. Otherwise the host node which the client failed to connect will be permanently unavailable until client corrects itself. But I agree documentation and error message as you said need improvements. I will try to correct same.

--
Thanks and Regards
Mithun C Y

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

Предыдущее
От: "Tsunakawa, Takayuki"
Дата:
Сообщение: Re: [RFC] Should we fix postmaster to avoid slow shutdown?
Следующее
От: Etsuro Fujita
Дата:
Сообщение: Re: postgres_fdw : altering foreign table not invalidating prepare statement execution plan.