Re: Forcibly disconnect users from one database

On 4/10/20 1:20 PM, Andrus wrote: Hi! Postgres 12 does not allow to drop database if it is in use. DROP DATABASE throws error: postgres@template1 ERROR:  database "mydb" is being accessed by other users postgres@template1 DETAIL:  There is 1 other session using the database. postgres@template

Forcibly disconnect users from one database

Hi! Postgres 12 does not allow to drop database if it is in use. DROP DATABASE throws error: postgres@template1 ERROR: database "mydb" is being accessed by other users postgres@template1 DETAIL: There is 1 other session using the database. postgres@template1 STATEMENT: DROP DATABASE "mydb"