Received: from localhost (uranus.hub.org [200.46.204.60]) by postgresql.org (Postfix) with ESMTP id 4D1E49FB1ED for ; Mon, 6 Nov 2006 18:44:45 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.60]) (amavisd-new, port 10024) with ESMTP id 09415-05 for ; Mon, 6 Nov 2006 18:44:39 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from exchange.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by postgresql.org (Postfix) with ESMTP id 064049FA497 for ; Mon, 6 Nov 2006 18:44:37 -0400 (AST) Received: from 10.10.1.37 ([10.10.1.37]) by exchange.g2switchworks.com ([10.10.1.2]) with Microsoft Exchange Server HTTP-DAV ; Mon, 6 Nov 2006 22:44:34 +0000 Received: from state.g2switchworks.com by mail.g2switchworks.com; 06 Nov 2006 16:44:34 -0600 Subject: Re: Database size From: Scott Marlowe To: Nikola Radakovic Cc: pgsql-admin@postgresql.org In-Reply-To: <1162852178.18320.9.camel@localhost.localdomain> References: <1162846082.16473.5.camel@localhost.localdomain> <1162846879.5202.34.camel@localhost.localdomain> <1162849299.16935.16.camel@localhost.localdomain> <1162849972.5202.37.camel@localhost.localdomain> <1162852178.18320.9.camel@localhost.localdomain> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1162853074.5195.65.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Mon, 06 Nov 2006 16:44:34 -0600 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/37 X-Sequence-Number: 23564 On Mon, 2006-11-06 at 16:29, Nikola Radakovic wrote: > Setting user's quota on my linux machine wont affect database > quota.It will have impact on users directories.So, it must > be a trick how to set PostgreSQL quota. Or how to link PostgreSQL > database with directories which already have set quotas. PostgreSQL itself has no ability to set quotas. You can limit the amount of data a particular table space uses, either by drive size or quota. But for individual users, I don't think there's a solution.