| From: | MichaelDBA <MichaelDBA(at)sqlexec(dot)com> |
|---|---|
| To: | "Godfrin, Philippe E" <Philippe(dot)Godfrin(at)nov(dot)com> |
| Cc: | Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>, "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: [EXTERNAL] Re: Limits user connection in pgbouncer |
| Date: | 2021-12-13 13:07:32 |
| Message-ID: | 1da96539-bdef-4158-1e38-fa95371c464e@sqlexec.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hi all,
If you add the user to the database specification, then you can limit
connections per user:
db1 = host=localhost dbname=db1 pool_size=2 user=myuser
Regards,
Michael Vitale
Godfrin, Philippe E wrote on 12/13/2021 7:57 AM:
> On 13/12/21 10:05 π.μ., Daulat wrote:
>> Hello Team,
>> How can we limit the user to make a specific number of connections
>> to the database?
> Just specify this in the db definition configuration :
>
> db1 = host=localhost dbname=db1 pool_size=2
>
> but it will apply to every user, so that every user's pool will have
> max 2 connections, not only user1.
>
> Alternatively you could set "ALTER ROLE .. CONNECTION LIMIT connlimit
> " for user1 individually.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | dave | 2021-12-13 14:09:27 | RE: PostgreSQL - CVE-2021-44228 - dependency on Log4j ? |
| Previous Message | Godfrin, Philippe E | 2021-12-13 12:57:44 | RE: [EXTERNAL] Re: Limits user connection in pgbouncer |