Database User Quota

From: Horst Düster <horst(dot)duester(at)sourcepole(dot)ch>
To: pgsql-admin(at)postgresql(dot)org
Subject: Database User Quota
Date: 2014-08-25 11:21:12
Message-ID: 53FB1C28.5080808@sourcepole.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


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

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

- --
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(dot)duester(at)sourcepole(dot)ch http://www.sourcepole.ch

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

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

iQEcBAEBAgAGBQJT+xwoAAoJENxaj+NbOI6SFoAH/i5GYakf76E9mJwdtMb/5NuF
BsWuXktudYTCHDeFCpIqTnwK8wRWlcxN/aBQI0RQWHse5wSEAljctE26EkBPkL/c
ZYAIi2t2p7nmOk190kYqp8i+65PLow8UdOVA/sTp/xf6LUr7XKWPA1feTDCesBev
m5a4cOKZyqOMx+Ax2/JYkwT9s9TRZD8CB8A1dmQIvPzihL7g1YxXu7lfne6O4TTK
EMuvM5xx/NZblaANJVPATI+jVGv50Vd2YvBwewD58YMZOA5gHcRF4ntMvNab0Xzs
Py26Li76xT7vo1E5dI2dKYkLozwpkQOnmH5eIJ4nsabXVSUp7abAd6qH8WvM9AI=
=qhey
-----END PGP SIGNATURE-----

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message hubert depesz lubaczewski 2014-08-25 11:34:22 Re: Database User Quota
Previous Message liuyuanyuan 2014-08-25 08:57:03 答复: [pgadmin-hackers] OF TYPE without SCHEMA specified in TABLE creation interface