限制每个用户只能连接指定数量的session,防止服务器资源紧张
(1)创建测试用户test:
highgo=#create user test;
CREATEROLE
highgo=#\du
List of roles
Role name | Attributes | Member of
-----------+------------------------------------------------+----------
highgo | Superuser, Create role, Create DB, Replication | {}
test | | {}
(2)设置仅允许用户test使用一个连接
highgo=#ALTER ROLE test CONNECTION LIMIT 1;
ALTERROLE
(3)在session 1中使用test用户连接highgo数据库