From: | Melvin Davidson <melvin6925(at)gmail(dot)com> |
---|---|
To: | Paolo Saudin <paolosaudin(at)gmail(dot)com> |
Cc: | PostgreSQL <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: pgAdmin 4 - auto disconnect |
Date: | 2016-12-19 14:30:26 |
Message-ID: | CANu8FiwssteothTH56=hAfJiafRSzPfCquBSu=KxMib+29HzEQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mon, Dec 19, 2016 at 7:28 AM, Paolo Saudin <paolosaudin(at)gmail(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Poul Kristensen | 2016-12-19 15:17:36 | pg_hba.conf debugging or logging when using ldag to authenticate |
Previous Message | Mickaël Le Baillif | 2016-12-19 13:36:49 | JSON objects merge using || operator |