pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feeddata 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