pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
data from system tables.
3+ messages / 3 participants
[nested] [flat]

* data from system tables.
@ 2007-03-26 20:45 Carol Walter <walterc@indiana.edu>
  2007-03-27 03:58 ` Re: data from system tables. Tom Lane <tgl@sss.pgh.pa.us>
  2007-03-27 04:03 ` Re: data from system tables. Michael Fuhr <mike@fuhr.org>
  0 siblings, 2 replies; 3+ messages in thread

From: Carol Walter @ 2007-03-26 20:45 UTC (permalink / raw)
  To: pgsql-admin

Hello,

We recently began giving our users a ten connection limit.  The are  
some accounts that have no limit.  Some of these should have no limit  
because they're system accounts, but others are just users that were  
created before we started the limit.  Is there a psql command that I  
can run with a "where" clause that will let me get a list of everyone  
who has no connection limit?

Carol



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: data from system tables.
  2007-03-26 20:45 data from system tables. Carol Walter <walterc@indiana.edu>
@ 2007-03-27 03:58 ` Tom Lane <tgl@sss.pgh.pa.us>
  1 sibling, 0 replies; 3+ messages in thread

From: Tom Lane @ 2007-03-27 03:58 UTC (permalink / raw)
  To: Carol Walter <walterc@indiana.edu>; +Cc: pgsql-admin

Carol Walter <walterc@indiana.edu> writes:
> We recently began giving our users a ten connection limit.  The are  
> some accounts that have no limit.  Some of these should have no limit  
> because they're system accounts, but others are just users that were  
> created before we started the limit.  Is there a psql command that I  
> can run with a "where" clause that will let me get a list of everyone  
> who has no connection limit?

Sure, look into pg_authid for negative rolconnlimit entries.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: data from system tables.
  2007-03-26 20:45 data from system tables. Carol Walter <walterc@indiana.edu>
@ 2007-03-27 04:03 ` Michael Fuhr <mike@fuhr.org>
  1 sibling, 0 replies; 3+ messages in thread

From: Michael Fuhr @ 2007-03-27 04:03 UTC (permalink / raw)
  To: Carol Walter <walterc@indiana.edu>; +Cc: pgsql-admin

On Mon, Mar 26, 2007 at 04:45:01PM -0400, Carol Walter wrote:
> We recently began giving our users a ten connection limit.  The are  
> some accounts that have no limit.  Some of these should have no limit  
> because they're system accounts, but others are just users that were  
> created before we started the limit.  Is there a psql command that I  
> can run with a "where" clause that will let me get a list of everyone  
> who has no connection limit?

Look at the SQL that psql executes for its \d commands:

\set ECHO_HIDDEN
\du

See also the "System Catalogs" chapter in the documentation for the
version you're running.  Here's the link for 8.2:

http://www.postgresql.org/docs/8.2/interactive/catalogs.html

-- 
Michael Fuhr



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2007-03-27 04:03 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-03-26 20:45 data from system tables. Carol Walter <walterc@indiana.edu>
2007-03-27 03:58 ` Tom Lane <tgl@sss.pgh.pa.us>
2007-03-27 04:03 ` Michael Fuhr <mike@fuhr.org>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox