postgresql – 我无法从Odoo界面复制或删除数据库,因为有会话使

ERROR:  source database "database_name" is being accessed by other users
DETAIL:  There are 5 other sessions using the database.

然后,如果想要复制或删除数据库,我必须运行此查询以终止所有连接：

SELECT pg_terminate_backend(pg_stat_activity.pid) 
FROM pg_stat_activity 
WHERE pg_stat_activity.datname = 'database_name' AND pid <> pg_backend_pid();

我想要做的是覆盖以下控制器,以便在执行函数duplicate_database和drop之前始终运行查询：

@http.route('/web/database/duplicate',type='json',auth="none")
def duplicate(self,fields):
    params = dict(map(operator.itemgetter('name','value'),fields))
    duplicate_attrs = (
        params['super_admin_pwd'],params['db_original_name'],params['db_name'],)
    return request.session.proxy("db").duplicate_database(*duplicate_attrs)

@http.route('/web/database/drop',auth="none")
def drop(self,fields):
    password,db = operator.itemgetter(
        'drop_pwd','drop_db')(
            dict(map(operator.itemgetter('name',fields)))
    try:
        if request.session.proxy("db").drop(password,db):
            return True
        else:
            return False
    except openerp.exceptions.AccessDenied:
        return {'error': 'AccessDenied','title': 'Drop Database'}
    except Exception:
        return {'error': _('Could not drop database !'),'title': _('Drop Database')}

我在Documentation of Odoo中找到了这个注释：

[…] This operation requires that there be no connection to the
database being duplicated,but Odoo doesn’t currently break
existing/outstanding connections,so restarting the server is the
simplest way to ensure everything is in the right state.

可以安全地覆盖这些控制器吗？有什么更好的方法呢？我想使用界面执行此操作,因为如果我手动执行此操作或者每次需要我必须停止服务器都非常烦人.