Set PostgreSQL concurrent connection limit

In this article we are going to set PostgreSQL concurrent connection limit for user. As a administrator, we have to revoke permissions from the user, set the connection limits to user and set unlimited concurrent connection limits.

Set PostgreSQL concurrent connection limit:
In this video, we have the concurrent user connection limit to none,5, and unlimited.

1. Set concurrent connection limit none.

alter user anil connection limit 0;

2. Set concurrent connection limit 5.

alter user anil connection limit 5;

3. Set concurrent connection limit unlimited.

alter user anil connection limit -1;