pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedhow i can restrict databaseusers ?
5+ messages / 5 participants
[nested] [flat]
* how i can restrict databaseusers ?
@ 2008-05-20 13:57 pronix pronix <pronix.service@gmail.com>
0 siblings, 4 replies; 5+ messages in thread
From: pronix pronix @ 2008-05-20 13:57 UTC (permalink / raw)
To: pgsql-admin
hello
how i can restrict dbusers ( user's db size, cpu time)?
how i can monitoring this parameters
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: how i can restrict databaseusers ?
@ 2008-05-20 15:33 Travis Smith <tsmith@optionshouse.com>
parent: pronix pronix <pronix.service@gmail.com>
3 siblings, 0 replies; 5+ messages in thread
From: Travis Smith @ 2008-05-20 15:33 UTC (permalink / raw)
To: pronix pronix <pronix.service@gmail.com>; pgsql-admin
how i can restrict dbusers ( user's db size, cpu time)?
http://www.enterprisedb.com/documentation/kernel-resources.html#AEN32652
how i can monitoring this parameters
perl & /proc maybe..
________________________________
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of pronix pronix
Sent: Tuesday, May 20, 2008 8:57 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] how i can restrict databaseusers ?
hello
_______________________________________________________
The information in this email or in any file attached
hereto is intended only for the personal and confiden-
tial use of the individual or entity to which it is
addressed and may contain information that is propri-
etary and confidential. If you are not the intended
recipient of this message you are hereby notified that
any review, dissemination, distribution or copying of
this message is strictly prohibited. This communica-
tion is for information purposes only and should not
be regarded as an offer to sell or as a solicitation
of an offer to buy any financial product. Email trans-
mission cannot be guaranteed to be secure or error-
free. P6070214
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: how i can restrict databaseusers ?
@ 2008-05-20 17:38 Scott Marlowe <scott.marlowe@gmail.com>
parent: pronix pronix <pronix.service@gmail.com>
3 siblings, 0 replies; 5+ messages in thread
From: Scott Marlowe @ 2008-05-20 17:38 UTC (permalink / raw)
To: pronix pronix <pronix.service@gmail.com>; +Cc: pgsql-admin
On Tue, May 20, 2008 at 7:57 AM, pronix pronix <pronix.service@gmail.com> wrote:
> hello
> how i can restrict dbusers ( user's db size, cpu time)?
> how i can monitoring this parameters
You can create table spaces for each user, and then create a db or
schema or whatnot in that tablespace. If each tablespace is on a
partition that is limited to some size, then you've limited the user's
space. You don't get the more fine grained quotas that dbs like
Oracle provide, but then again, since you're not spending $250,000 a
year licensing postgresql, I guess you can buy a lot more space for
the users to play in if they all share the same db.
As for CPU time, there's really not restriction by user capability in
postgresql at this time.
To monitor it you can turn on stats collection and track what
statements are using up the most CPU by pid.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: how i can restrict databaseusers ?
@ 2008-10-31 11:36 Mathias Stjernström <mathias@globalinn.com>
parent: pronix pronix <pronix.service@gmail.com>
3 siblings, 0 replies; 5+ messages in thread
From: Mathias Stjernström @ 2008-10-31 11:36 UTC (permalink / raw)
To: pgsql-admin
Hi!
I do not think you can restrict resources on a user level or at any
lever for that matter.
There are numbers of ways to monitor all kinds of values. Just do a
quick search on google and you will find what you looking for.
This query can be used to display all database sizes.
SELECT
pg_database
.datname,pg_size_pretty(pg_database_size(pg_database.datname)) AS size
FROM pg_database;
Cheers!
Mathias
On 20 maj 2008, at 15.57, pronix pronix wrote:
> hello
> how i can restrict dbusers ( user's db size, cpu time)?
> how i can monitoring this parameters
Attachments:
PGP.sig (application/pgp-signature, 485B) download
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: how i can restrict databaseusers ?
@ 2008-11-04 21:31 Joshua D. Drake <jd@commandprompt.com>
parent: pronix pronix <pronix.service@gmail.com>
3 siblings, 0 replies; 5+ messages in thread
From: Joshua D. Drake @ 2008-11-04 21:31 UTC (permalink / raw)
To: pronix pronix <pronix.service@gmail.com>; +Cc: pgsql-admin
On Tue, 2008-05-20 at 17:57 +0400, pronix pronix wrote:
> hello
> how i can restrict dbusers ( user's db size, cpu time)?
You can't within PostgreSQL.
Joshua D. Drake
--
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2008-11-04 21:31 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-05-20 13:57 how i can restrict databaseusers ? pronix pronix <pronix.service@gmail.com>
2008-05-20 15:33 ` Travis Smith <tsmith@optionshouse.com>
2008-05-20 17:38 ` Scott Marlowe <scott.marlowe@gmail.com>
2008-10-31 11:36 ` Mathias Stjernström <mathias@globalinn.com>
2008-11-04 21:31 ` Joshua D. Drake <jd@commandprompt.com>
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