Participants
Ken Colson
Ken Colson
Tom Lane
Tom Lane
Attachments
Show all attachments
Thread Outline
#1Ken ColsonKen Colson
Aug 29, 2007
#2Tom Lane↳Tom Laneto Ken Colson (#1)
Aug 29, 2007

show connection limit?

Started by Ken Colsonover 18 years ago2 messagesgeneral
Jump to latest
#1Ken Colson
Ken Colson
ken.colson@sage.com

I have set the connection limit of a user with the ALTER ROLE command in
8.1. Is there a way to see what the connection limit is set to for various
users?

Thanks,

Ken

#2Tom Lane
Tom Lane
tgl@sss.pgh.pa.us
In reply to: Ken Colson (#1)
Re: show connection limit?

Ken.Colson@sage.com writes:

Is there a way to see what the connection limit is set to for various
users?

Look in pg_authid.

regards, tom lane

← Back to Topics