Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 4C92C9FB1ED for ; Mon, 6 Nov 2006 18:31:18 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 76089-08 for ; Mon, 6 Nov 2006 22:31:12 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from ls405.htnet.hr (ls405.t-com.hr [195.29.150.135]) by postgresql.org (Postfix) with ESMTP id 02C1D9FB1F5 for ; Mon, 6 Nov 2006 18:31:11 -0400 (AST) Received: from ls422.t-com.hr (ls422.t-com.hr [195.29.150.237]) by ls405.htnet.hr (Postfix) with ESMTP id 3B145146E74 for ; Mon, 6 Nov 2006 23:29:39 +0100 (CET) Received: from ls422.t-com.hr (localhost.localdomain [127.0.0.1]) by ls422.t-com.hr (Qmlai) with ESMTP id 1FE23C9004F for ; Mon, 6 Nov 2006 23:29:39 +0100 (CET) X-Envelope-Sender-Info: V1Da1T7nZbwZQGUNUNl8zkdiJdDxoUlnsG4mMTL18kOkS0Yut/I0Xa0zb9pYg++Q X-Envelope-Sender: achillea@hi.t-com.hr Received: from ubuntu (89-172-198-135.adsl.net.t-com.hr [89.172.198.135])by ls422.t-com.hr (Qmlai) with ESMTP id A5FC8130803Ffor ; Mon, 6 Nov 2006 23:29:38 +0100 (CET) Subject: Re: Database size From: Nikola Radakovic To: pgsql-admin@postgresql.org In-Reply-To: <1162849972.5202.37.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> Content-Type: text/plain Date: Mon, 06 Nov 2006 16:29:38 -0600 Message-Id: <1162852178.18320.9.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.4.1 Content-Transfer-Encoding: 7bit X-imss-version: 2.043 X-imss-result: Passed X-imss-scores: Clean:85.42147 C:2 M:3 S:5 R:5 X-imss-settings: Baseline:1 C:1 M:1 S:1 R:1 (0.0000 0.0000) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/35 X-Sequence-Number: 23562 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. On Mon, 2006-11-06 at 16:52 -0500, Mike Goldner wrote: > On Mon, 2006-11-06 at 15:41 -0600, Nikola Radakovic wrote: > > Or, briefly how to set Postgresql user quota? > > > > On Mon, 2006-11-06 at 16:01 -0500, Mike Goldner wrote: > > > Nikola, > > > > > > I'm not exactly sure what you are asking. > > > > > > The size of the database is usually determined by the amount of data > > > stored and not determined beforehand. > > > > > > Are you refering of "tablespaces", as other DBMSs use them? If so, > > > Postgres has a tablespace command, but it simply points to a filesystem > > > location. There is no "size" specified. > > > > > > The size of the database is simply limited by the available filesystem > > > capacity (I suppose there may be some restrictions at the high-end). > > > > > > Mike > > > > > > On Mon, 2006-11-06 at 14:48 -0600, Nikola Radakovic wrote: > > > > Dear community, > > > > > > > > I would be very grateful if someone could answer me, > > > > where to find instructions how to set the size ( in megabytes ) for > > > > particular database. > > > > > > > > > > > > best regards, > > > > N.Radakovic > > > > > > > > > > > > ---------------------------(end of broadcast)--------------------------- > > > > TIP 1: if posting/reading through Usenet, please send an appropriate > > > > subscribe-nomail command to majordomo@postgresql.org so that your > > > > message can get through to the mailing list cleanly > > > > Nikola, > > Setting quotas is operating system-dependent. If you are using linux, > take a look at http://yolinux.com/TUTORIALS/LinuxTutorialQuotas.html >