X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id DCDFA9FADD1 for ; Tue, 30 May 2006 13:37:23 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 36118-09 for ; Tue, 30 May 2006 13:37:01 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sydney.mailnetwork.co.uk (server88-208-192-113.live-servers.net [88.208.192.113]) by postgresql.org (Postfix) with ESMTP id 9A01F9FA5E9 for ; Tue, 30 May 2006 13:36:59 -0300 (ADT) Received: from andyshellam-gw.adsl.newnet.co.uk ([80.175.198.137]:1121 helo=[192.168.1.5]) by sydney.mailnetwork.co.uk with esmtpa (Exim 4.60) (envelope-from ) id 1Fl7DG-0006sF-84; Tue, 30 May 2006 17:36:58 +0100 Message-ID: <447C74A8.7090002@andycc.net> Date: Tue, 30 May 2006 17:36:56 +0100 From: Andy Shellam Reply-To: andy@andycc.net Organization: AndyShellam.EU User-Agent: Thunderbird 1.5.0.2 (Windows/20060308) MIME-Version: 1.0 To: Aaron Bono CC: pgsql-admin@postgresql.org Subject: Re: Separating Databases on Different Partitions References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/419 X-Sequence-Number: 21951 Ah, fair enough, table spaces are definitely the way to go then. I did use it about a year ago to put one database on a different physical drive, but I haven't used it for ages so cannot remember how to set it up. Andy Aaron Bono wrote: > I think the tablespace option will work best - I will check it out. I > do not give the users control of the database since I do the > development, I just need a way to allocate the space and charge for > space used. Since cPanel monitors user space, I don't want to rely on > having to query the database to get size information - I would have to > put together separate scripts to watch space usage which I would > rather not do. > > Thanks for the help! > > -Aaron > > On 5/30/06, *Andy Shellam* > wrote: > > Hi Aaron > > > > I believe you could probably do this best with table spaces. > You'll have to look it up in the documentation as I haven't done > it for a while. > > You symlink a directory under /pg_tblspc to another > physical directory (eg. Your user's home/db directory), then when > you create the database, set its default table space to which > directory you create. > > > > There is a downside in that the user could create a new table and > override the table space to that of another user. > > > > You could always query the system catalogues for the usage for > each user's database and add that to the physical size of their > home directory? > > > > Regards, > > > > Andy > > > !DSPAM:14,447c6d25256841812113538!