Re: Database Size Limiting - Mailing list pgsql-general

From Richard Huxton
Subject Re: Database Size Limiting
Date
Msg-id 40B6F2E0.6000601@archonet.com
Whole thread Raw
In response to Re: Database Size Limiting  ("Campano, Troy" <Troy.Campano@LibertyMutual.com>)
List 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

pgsql-general by date:

Previous
From: "Ben-Nes Michael"
Date:
Subject: Re: Database Size Limiting
Next
From: Rory Campbell-Lange
Date:
Subject: pg_dump and schema namespace notes