Thank you very much, I will try this approach Paolo 2016-12-19 15:30 GMT+01:00 Melvin Davidson <melvin6...@gmail.com>:
> > On Mon, Dec 19, 2016 at 7:28 AM, Paolo Saudin <paolosau...@gmail.com> > wrote: > >> Hi, >> >> I deployed pgAdmin4 on a server and I have a script that every day >> restore a database from a dump file. The problem I am facing at, is that if >> somebody forget to diconnect from the database, the restore command fails >> with an error "database Test is being accessed by other users". >> >> Is there a way to tell pgAdmin to auto disconnect from all databases? >> >> Thanks >> Paolo Saudin >> > > PgAdmin4 actually has nothing to do with it, as it is nothing more than a > tool to monitor PostgreSQL. > However, you can kill all user processes (except your own) by submitting > the following query. > > SELECT pg_terminate_backend(pid) > FROM pg_stat_activity > WHERE pg_backend_pid() <> pid; > > CAVEAT EMPTOR: You must be a superuser for this to work properly. > > -- > *Melvin Davidson* > I reserve the right to fantasize. Whether or not you > wish to share my fantasy is entirely up to you. >
