Обсуждение: Blocking clients based on application name?

Поиск

Список

Период

Сортировка

От

Wells Oliver

Дата:

29 августа 2019 г., 20:48:38

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...

От

"David G. Johnston"

Дата:

29 августа 2019 г., 21:04:18

On Thursday, August 29, 2019, 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...

David J.

От

Jeff Janes

Дата:

01 сентября 2019 г., 19:58:15

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.

Cheers,

Jeff