Re: Restrict connection from pgadmin.

2020-02-04 Thread raf
Tom Lane wrote: > Pawan Sharma writes: > > Yes I will show the pgadmin in stat_activity but how can block that.. > > I think I need to create a job to terminate the pgadmin connections and > > schedule it for every 5 min and so that I will check any new connections > > from pgadmin. > > I thin

Re: Restrict connection from pgadmin.

2020-02-03 Thread Tom Lane
Pawan Sharma writes: > Yes I will show the pgadmin in stat_activity but how can block that.. > I think I need to create a job to terminate the pgadmin connections and > schedule it for every 5 min and so that I will check any new connections > from pgadmin. I think onlookers are still completel

Re: Restrict connection from pgadmin.

2020-02-03 Thread Pawan Sharma
Yes I will show the pgadmin in stat_activity but how can block that.. I think I need to create a job to terminate the pgadmin connections and schedule it for every 5 min and so that I will check any new connections from pgadmin. On Mon, 3 Feb 2020, 11:13 pm Adrian Klaver, wrote: > On 2/3/20 9

Re: Restrict connection from pgadmin.

2020-02-03 Thread Adrian Klaver
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 clos

Re: Restrict connection from pgadmin.

2020-02-03 Thread Ravi Krishna
> > 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 is to have

Re: Restrict connection from pgadmin.

2020-02-03 Thread David G. Johnston
On Sun, Feb 2, 2020 at 11:48 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..??? > Why just pgAdmin? Why not psql? How do you expect to know

Re: Restrict connection from pgadmin.

2020-02-03 Thread Adrian Klaver
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 metho

Restrict connection from pgadmin.

2020-02-02 Thread Pawan Sharma
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..???