Обсуждение: how i can restrict databaseusers ?

hello
how i can restrict dbusers ( user's db size, cpu time)?
how i can monitoring this parameters

---

The information in this email or in any file attached hereto is intended only for the personal and confidential use of the individual or entity to which it is addressed and may contain information that is proprietary 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 communication 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 transmission cannot be guaranteed to be secure or error-free. P6070214

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.

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

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

--