Thread: How to limit database size

Hi,

How can I limit the maximum space uses by Posgres database ??. So that
it should not use total disk space available on system.

Thanks in advance,
Vishnu

am  23.08.2005, um 15:12:54 +0530 mailte Vishnu folgendes:
> Hi,
>
> How can I limit the maximum space uses by Posgres database ??. So that it
> should not use total disk space available on system.

You can use the tools from the os, under Linux for instance quotas.
You can also put the data dir on a separate partition.


Regards, Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47212,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===

On Tue, Aug 23, 2005 at 01:19:11PM +0200, A. Kretschmer wrote:
> am  23.08.2005, um 15:12:54 +0530 mailte Vishnu folgendes:
> > How can I limit the maximum space uses by Posgres database ??. So that it
> > should not use total disk space available on system.
>
> You can use the tools from the os, under Linux for instance quotas.

Be aware that exceeding a disk quota might cause problems beyond a
simple "Sorry, you can't insert any more records" error.

http://www.postgresql.org/docs/8.0/static/disk-full.html

Even with a quota in place, you should probably monitor the database's
disk usage so you can take action before the quota is exceeded.

--
Michael Fuhr