Thread: Blocking clients based on application name?

From

Wells Oliver

Date:

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

From

"David G. Johnston"

Date:

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

From

Jeff Janes

Date:

01 September 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