Skip site navigation (1) Skip section navigation (2)

Re: Database Size Limiting

From: Richard Huxton <dev(at)archonet(dot)com>
To: "Campano, Troy" <Troy(dot)Campano(at)LibertyMutual(dot)com>
Cc: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>,Postgres general mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Re: Database Size Limiting
Date: 2004-05-28 08:05:52
Message-ID: 40B6F2E0.6000601@archonet.com (view raw or flat)
Thread:
Lists: pgsql-general
Campano, Troy wrote:
> Is it possible to have a database spread across two data files?
> So if it fills up filesystem1 then we could add a second filesystem and
> allow it to grow onto this second filesystem?

If you're using Linux there is a tool called the Linux Volume Manager 
(LVM) which does this. You can change volume sizes dynamically, add new 
disks etc.

I think all modern operating-systems offer something similar.

-- 
   Richard Huxton
   Archonet Ltd

In response to

pgsql-general by date

Next:From: Samuele BrignoliDate: 2004-05-28 09:28:10
Subject: date/time field value out of range
Previous:From: Ben-Nes MichaelDate: 2004-05-28 07:09:22
Subject: Re: Database Size Limiting

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group