How to find out the connection limit per user on Postgresql?

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.


Whilst connected to the database you want to get this information

SELECT rolname, rolconnlimit
FROM pg_roles
WHERE rolconnlimit <> -1;

More details are available at http://www.postgresql.org/docs/current/static/view-pg-roles.html

Tags:

Database

Postgresql

Database Connection

Related

Is there any real alternative to GeoServer as dynamic map generator in Java? How extract years, months, days, hours, minutes, seconds from a mysql date? What is event bubbling and capturing? Automatically Generating Documentation for All Python Package Contents How to generate a random string, and specify the length you want, or better generate unique string on specification you want Turning off ASP.Net WebForms authentication for one sub-directory Is there a reason why a base class decorated with XmlInclude would still throw a type unknown exception when serialized? Handling Signals in Python Threads Self-references in object literals / initializers Is there a command in Vim/gVim to combine two or more tabs into a single split window? Converting System.Windows.Media.Color to System.Drawing.Color get base class type in python

Recent Posts