Re: Restrict connection from pgadmin.

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Ravi Krishna <ravikrishna(at)vivaldi(dot)net>
Cc: Pawan Sharma <pawanpg0963(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Restrict connection from pgadmin.
Date: 2020-02-03 17:43:18
Message-ID: cac9bdde-bd61-d0c9-5f53-0cb8d064aad5@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Matthias Apitz 2020-02-03 17:58:51 Re: performance of loading CSV data with COPY is 50 times faster than Perl::DBI
Previous Message Ravi Krishna 2020-02-03 17:15:50 Re: Restrict connection from pgadmin.