Re: how i can restrict databaseusers ?

From: Mathias Stjernström <mathias(at)globalinn(dot)com>
To: PostgreSQL Admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: how i can restrict databaseusers ?
Date: 2008-10-31 11:36:23
Message-ID: BC809CB1-DBC5-4E4E-9EC4-90E1C2A87870@globalinn.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Jaume Sabater 2008-10-31 12:12:11 Re: Deleting old archived WAL files
Previous Message Jaume Sabater 2008-10-31 11:32:42 Re: Deleting old archived WAL files