Re: Best way to limit database sizes

From: Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
To: dev_hyd2001(at)yahoo(dot)com
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Best way to limit database sizes
Date: 2008-07-03 19:10:47
Message-ID: 08A677B0-4BE9-4F75-83F2-410DE6F360C3@hi-media.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

Le 3 juil. 08 à 18:07, Dev a écrit :
> I've considered creating a tablespace in a directory owned by the
> user , so I can use Linux quotas to prevent higher disk usage , but
> this turned out be a bad thought, as all the files are anyway owned
> by the postgres user and so disk quotas won't have any effect.

What if you put each tablespace on a LVM partition of a control sized,
extensible?

- --
dim

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (Darwin)

iEYEARECAAYFAkhtJDcACgkQlBXRlnbh1bkQlACfY825U1pq7Livch4sPSEgj1x6
iCMAoMN9Wjxb3KFOHbOmj2oi5sqnvyUn
=IeBI
-----END PGP SIGNATURE-----

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tino Schwarze 2008-07-03 19:17:36 Re: Best way to limit database sizes
Previous Message Kevin Grittner 2008-07-03 18:31:47 Re: Best way to limit database sizes