Re: quota's ? - Mailing list pgsql-general

From Richard Huxton
Subject Re: quota's ?
Date
Msg-id 006101c0beab$22e6a5c0$1001a8c0@archonet.com
Whole thread Raw
In response to quota's ?  ("Kris Van Hulle" <uxs@compulink.gr>)
List pgsql-general
From: "Kris Van Hulle" <uxs@compulink.gr>

> Hi...
>
> Is there a way to limit the amount of disk space a PostgreSQL
> server can use ? Or to limit this for a specific database on the
> server ? (or preferably both ?) (apart from limiting this in an external
> way, like the quota's on the linux file system or something like that)
> Also, is it possible to limit other things like cpu usage or memory
> usage ?

AFAIK you can only do this at the OS level. Certainly cpu/memory usage can
be restricted on pretty much all unix-like systems - you'll need to see the
documentation for your specific platform to find how.

Limiting disk usage, you *should* be able to change the group of the various
database files and limit group file usage. I can't say I've tested this
though.

HTH

- Richard Huxton


pgsql-general by date:

Previous
From: Patrick Welche
Date:
Subject: Re: The dreaded readline, again, on OpenBSD
Next
From: "ADBAAMD"
Date:
Subject: Re: Database Name Case Sensitivity