Re: Best way to limit database sizes - Mailing list pgsql-admin

From Dimitri Fontaine
Subject Re: Best way to limit database sizes
Date
Msg-id 08A677B0-4BE9-4F75-83F2-410DE6F360C3@hi-media.com
Whole thread Raw
In response to Best way to limit database sizes  (Dev <dev_hyd2001@yahoo.com>)
Responses Re: Best way to limit database sizes  (Tino Schwarze <postgresql@tisc.de>)
List 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-----

pgsql-admin by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Best way to limit database sizes
Next
From: Tino Schwarze
Date:
Subject: Re: Best way to limit database sizes