Re: limits on the number of concurrent DBMS sessions per account

From: Kevin Tu <kevintu888(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-sql(at)lists(dot)postgresql(dot)org
Subject: Re: limits on the number of concurrent DBMS sessions per account
Date: 2022-03-04 15:29:39
Message-ID: CAKbWnAW4JM-_dEJnjbd3aF4To=c9=pPLNPV=R1A0QU9gTB3GRQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Thanks Tom! As always, you're the best!

On Fri, Mar 4, 2022 at 10:11 AM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Kevin Tu <kevintu888(at)gmail(dot)com> writes:
> > Let's say I have a user userA, does anyone know how to limit the number
> of
> > concurrent sessions for this user?
>
> ALTER USER joe CONNECTION LIMIT 42;
>
> regards, tom lane
>

--
Best Regards,

Kevin Tu

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message David G. Johnston 2022-03-04 15:32:15 Re: unique index with several columns
Previous Message Tom Lane 2022-03-04 15:11:50 Re: limits on the number of concurrent DBMS sessions per account