Re: Restrict connection from pgadmin.

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: 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:03:11
Message-ID: 993e25c3-0389-3f32-2b0c-a3d250e09a10@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2/2/20 10:47 PM, Pawan Sharma wrote:
> Hi All,
>
> Is there any way to restrict the connection only from pgadmin???  The
> same user can connect through application but can't from pgadmin.. Or
> any logon triggers..???
>

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

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2020-02-03 17:13:51 Re: Restrict connection from pgadmin.
Previous Message Ravi Krishna 2020-02-03 16:57:14 Re: performance of loading CSV data with COPY is 50 times faster than Perl::DBI