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

Whilst connected to the database you want to get this information

SELECT rolname, rolconnlimitFROM pg_rolesWHERE rolconnlimit <> -1;

database postgresql database-connection

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.

CodeHunter