Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1XLsL7-0004DW-2W for pgsql-admin@arkaria.postgresql.org; Mon, 25 Aug 2014 11:21:33 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1XLsL5-00052c-0B for pgsql-admin@arkaria.postgresql.org; Mon, 25 Aug 2014 11:21:31 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1XLsKv-0004ks-6R for pgsql-admin@postgresql.org; Mon, 25 Aug 2014 11:21:21 +0000 Received: from brisi.sourcepole.ch ([5.9.57.43]) by magus.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1XLsKp-00031d-Ja for pgsql-admin@postgresql.org; Mon, 25 Aug 2014 11:21:17 +0000 Received: from 164.8.24.31.ftth.as8758.net ([31.24.8.164] helo=[192.168.178.90]) by vilan-mail with esmtpsa (TLS1.2:DHE_RSA_AES_128_CBC_SHA1:128) (Exim 4.80) (envelope-from ) id 1XLsKn-0003WR-Gy for pgsql-admin@postgresql.org; Mon, 25 Aug 2014 13:21:13 +0200 Message-ID: <53FB1C28.5080808@sourcepole.ch> Date: Mon, 25 Aug 2014 13:21:12 +0200 From: =?UTF-8?B?SG9yc3QgRMO8c3Rlcg==?= User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:31.0) Gecko/20100101 Thunderbird/31.0 MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Database User Quota Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org -----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.duester@sourcepole.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----- -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin