UPDATE pg_database SET datallowconn = 'false' WHERE datname = 'mydb' You can use one of following methods (the second seems safer, but does not prevent connections from superusers). Make sure no one can connect to this database. Now using plain database client you can force drop database using three simple steps: Do not use the database you want to drop. In PostgreSQL 12 and earlier, you cannot drop a database while clients are connected to it.Īt least, not with the dropdb utility - which is only a simple wrapper around DROP DATABASE server query.Ĭonnect to your server as superuser, using psql or other client. This willĪlso fail if we are not able to terminate connections. Pg_terminate_backend, described in Section 9.27.2. Required permissions are the same as with This will fail if the current user has no permissions to terminate Replication slots or subscriptions are present in the target database. It doesn't terminate if prepared transactions, active logical PostgreSQL 13 added: DROP DATABASE mydb WITH (FORCE) Īttempt to terminate all existing connections to the target database.
0 kommentar(er)
