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 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.