Обсуждение: [GENERAL] pgAdmin 4 - auto disconnect
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
On Mon, Dec 19, 2016 at 7:28 AM, Paolo Saudin <paolosaudin@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?ThanksPaolo 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;
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.![](http://us.i1.yimg.com/us.yimg.com/i/mesg/tsmileys2/01.gif)
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
![](http://us.i1.yimg.com/us.yimg.com/i/mesg/tsmileys2/01.gif)
Thank you very much,
I will try this approach
Paolo
2016-12-19 15:30 GMT+01:00 Melvin Davidson <melvin6925@gmail.com>:
PgAdmin4 actually has nothing to do with it, as it is nothing more than a tool to monitor PostgreSQL.On Mon, Dec 19, 2016 at 7:28 AM, Paolo Saudin <paolosaudin@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?ThanksPaolo SaudinHowever, 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.