我需要了解是否在每个用户的PostgreSQL数据库上设置了连接限制.
我知道您可以通过以下方式设置这样的限制:
ALTER USER johndoe WITH CONNECTION LIMIT 2;
您能在pg_users表中判断这一点吗?
我需要了解是否在每个用户的PostgreSQL数据库上设置了连接限制.
我知道您可以通过以下方式设置这样的限制:
ALTER USER johndoe WITH CONNECTION LIMIT 2;
您能在pg_users表中判断这一点吗?
This information is available in the column rolconnlimit in the view pg_roles
http://www.postgresql.org/docs/current/static/view-pg-roles.html
For roles that can log in, this sets maximum number of concurrent connections this role can make. -1 means no limit.个