Postgres Pro
Downloads
Home   >   mailing lists

Re: limits on the number of concurrent DBMS sessions per account - Mailing list pgsql-sql

From Kevin Tu
Subject Re: limits on the number of concurrent DBMS sessions per account
Date
Msg-id CAKbWnAW4JM-_dEJnjbd3aF4To=c9=pPLNPV=R1A0QU9gTB3GRQ@mail.gmail.com
Whole thread Raw
In response to Re: limits on the number of concurrent DBMS sessions per account  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view
Thanks Tom!  As always, you're the best!

On Fri, Mar 4, 2022 at 10:11 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Kevin Tu <kevintu888@gmail.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

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: limits on the number of concurrent DBMS sessions per account
Next
From: "David G. Johnston"
Date:
Subject: Re: unique index with several columns