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