Re: Best way to limit database sizes

Поиск
Список
Период
Сортировка
От Dimitri Fontaine
Тема Re: Best way to limit database sizes
Дата
Msg-id 08A677B0-4BE9-4F75-83F2-410DE6F360C3@hi-media.com
обсуждение исходный текст
Ответ на Best way to limit database sizes  (Dev <dev_hyd2001@yahoo.com>)
Ответы Re: Best way to limit database sizes  (Tino Schwarze <postgresql@tisc.de>)
Список 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 по дате отправления:

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Best way to limit database sizes
Следующее
От: Tino Schwarze
Дата:
Сообщение: Re: Best way to limit database sizes