How to limit database size

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