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. Yo
] Database Size
Limiting
Is
there a way to limit the size that an individual database can take
up?
My understanding is
that all your databases go into a file system which is your
catalog
cluster.
But all the
databases can grow until that filesystem is full.
Is
3:23 PM
To: Joshua D. Drake
Cc: Campano, Troy; Postgres general mailing list
Subject: Re: [GENERAL] Database Size Limiting
Joshua D. Drake wrote:
> Hello,
>
> You could use Filsystem quotas but I strongly suggest against it as it
> will probably bring about database corruption.
Joshua D. Drake wrote:
Hello,
You could use Filsystem quotas but I strongly suggest against it as it
will probably bring about database corruption.
Ah - manual reference
http://www.postgresql.org/docs/current/static/disk-full.html
"24.2. Disk Full Failure
The most important disk monitoring task of
Joshua D. Drake wrote:
Hello,
You could use Filsystem quotas but I strongly suggest against it as it
will probably bring about database corruption.
I thought we handled that? I'm not saying it'd be pleasant, but I think
it's no worse than a power-outage.
Hmm, can't find anything in the manuals t
ke [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 27, 2004 2:12 PM
To: Campano, Troy
Cc: Postgres general mailing list
Subject: Re: [GENERAL] Database Size Limiting
Hello,
You could use Filsystem quotas but I strongly suggest against it as it
will probably bring about database corruption.
A bette
Hello,
You could use Filsystem quotas but I strongly suggest against it as it
will probably bring about database corruption.
A better solution would be to monitor the space being allocated so you
can add storage as required.
Sincerely,
Joshua D. Drake
Campano, Troy wrote:
-->
Is there a way to li
Campano, Troy wrote:
Is there a way to limit the size that an individual database can take
up?
My understanding is that all your databases go into a file system which
is your 'catalog cluster'.
But all the databases can grow until that filesystem is full.
Is there a way to limit how big a database
Title: Database Size Limiting
Is there
a way to limit the size that an individual database can take up?
My understanding is that all your databases go
into a file system which is your ‘catalog
cluster’.
But all the databases can grow until that
filesystem is full.
Is there a way to limi
