Re: Blocking clients based on application name?

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Blocking clients based on application name?
Дата
Msg-id CAMkU=1xusATj_awJsTaHuWVW0Fp1+Zy14NQ62oRuQCJndyDxYQ@mail.gmail.com
обсуждение исходный текст
Ответ на Blocking clients based on application name?  (Wells Oliver <wells.oliver@gmail.com>)
Список pgsql-admin
Дерево обсуждения
On Thu, Aug 29, 2019 at 1:49 PM Wells Oliver <wells.oliver@gmail.com> wrote:
Seems silly, but can you block clients based on the application name? i.e. if you wanted to block anyone trying to connect with PG Admin III...

There is an authentication hook you can use to do that, if you are willing to compile some C code and install the .so file.

It isn't going to be very robust, because there are different ways to set the application_name.  But it works for the way pgAdmin3 sets it.

This is heavily based on auth_delay (https://www.postgresql.org/docs/current/auth-delay.html).

Cheers,

Jeff
Вложения

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

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: Index not always being used
Следующее
От: "James B. Byrne"
Дата:
Сообщение: overwrote THE 'postgres' database - how to recover