Message-ID: <53FB2DDA.9060303@sourcepole.ch>
Date: Mon, 25 Aug 2014 14:36:42 +0200
From: =?UTF-8?B?SG9yc3QgRMO8c3Rlcg==?= <horst.duester@sourcepole.ch>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
 rv:31.0) Gecko/20100101 Thunderbird/31.0
MIME-Version: 1.0
To: hubert depesz lubaczewski <depesz@gmail.com>
CC: pgsql-admin@postgresql.org
Subject: Re: Database User Quota
References: <53FB1C28.5080808@sourcepole.ch>
 <CAKrjmhdoRHwJP4ogyaoK0MT+nAZ5HVyM9segk_TsoEprNWD6MQ@mail.gmail.com>
In-Reply-To: 
 <CAKrjmhdoRHwJP4ogyaoK0MT+nAZ5HVyM9segk_TsoEprNWD6MQ@mail.gmail.com>
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 8bit
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi depesz

Thanks a lot for your quick response. I'll have a look on your solution
soon.

All the best
Horst


Am 25/08/14 um 13:34 schrieb hubert depesz lubaczewski:
> You could add script that would scan databases, and summarize size of
> objects per owner role.
>
> More or less something like:
>
> for a in $( psql -c "select datname from pg_database where datallowconn"
> -qAtX )
> do
>     psql -d $a -c "select u.usename, pg_table_size(c.oid) from pg_class c
> join pg_user u on c.relowner = u.usesysid where c.relkind in ('r', 'i')"
> -qAtX -F,
> done | \
>     awk -F, '{s[$1]+=$2} END{for (i in s) {printf "%-30s : %20d\n", i,
> s[i]}}' | \
>     sort -nk2
>
> And then, run it from cron, add some logic to alert user/admin or simply
> block user access.
>
> depesz
>
>
>
> On Mon, Aug 25, 2014 at 1:21 PM, Horst Düster
<horst.duester@sourcepole.ch>
> wrote:
>
>>
> Hi
>
> I'm looking for a method to set quotas per user in a Postgresql Database
> Cluster. After searching around I found the trigger called check_quota.
> But this trigger has to be added to every table stored in a database.
> What I'm looking for is a cluster wide quotation based on user or role.
>
> Any help or hint are very appreciated.
>
> All the best
> Horst Düster
>
>
>
>>
>>
>>
>> --
>> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-admin
>>
>

- -- 
Dr. Horst Düster
Managing Director
Sourcepole AG - Linux & Open Source Solutions
Weberstrasse 5, 8004 Zürich, Switzerland
Tel: +41 (0)44 440 77 11
Direkt: +41 (0)44 515 67 70
horst.duester@sourcepole.ch  http://www.sourcepole.ch

www.sourcepole.ch/kurse - Das Kursangebot Herbst 2014


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1

iQEcBAEBAgAGBQJT+y3aAAoJENxaj+NbOI6S8dAH/iaVfBFqAnTjP3WyF7/8CIXB
0Ju7uTG35tN5hEXTbUJYVO0Ly5dd7nEBDaGSMZkMMHyPGOM92zeKJif9sX/xrPBu
0lNnUjq/crp5pvkh2u2BtvNfHawzbEDapCzoCkI4KlkOoyyYzGUO3rMpWprY/H/j
q1ZJrd6saHIrOfRRwuoq8Sg1fUdcCcTpcBBT4s9mkhfRCrUAwPhcv2n6k458kO0z
glJiWdMq+KaD6GyZawBxc4XLJJEvn0oiyvhZ7OkroboKPO2bQcwb7538S8Hl/8IP
CdDRbAZWdrrXdmmeB5k7Alt+DOtxDNjQdr4+g9NzH1GfF50yWEFagGp8xEsslJQ=
=aNNI
-----END PGP SIGNATURE-----


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin