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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-general by date

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