Re: Restrict connection from pgadmin. - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Restrict connection from pgadmin.
Date
Msg-id cac9bdde-bd61-d0c9-5f53-0cb8d064aad5@aklaver.com
Whole thread Raw
In response to Re: Restrict connection from pgadmin.  (Ravi Krishna <ravikrishna@vivaldi.net>)
Responses Re: Restrict connection from pgadmin.  (Pawan Sharma <pawanpg0963@gmail.com>)
List pgsql-general
On 2/3/20 9:15 AM, Ravi Krishna wrote:
>>
>> Not that I know of. pgAdmin is just another client so you just have the methods available here:
>>
>> https://www.postgresql.org/docs/12/auth-pg-hba-conf.html
>>
> 
> will the col application_name from pg_stat_activity list pgadmin as pgadmin. if yes, then the closest one can
achieve

Make a connection from pgAdmin and see.

> is to have a daemon process wake up every 1 min or so and terminate any pgadmin app.

I can do a lot of damage in a minute.




-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: Ravi Krishna
Date:
Subject: Re: Restrict connection from pgadmin.
Next
From: Matthias Apitz
Date:
Subject: Re: performance of loading CSV data with COPY is 50 times fasterthan Perl::DBI