Re: "Quota" - Mailing list pgsql-general

From Albe Laurenz
Subject Re: "Quota"
Date
Msg-id AFCCBB403D7E7A4581E48F20AF3E5DB20390EFF8@EXADV1.host.magwien.gv.at
Whole thread Raw
In response to "Quota"  (Hannes Dorbath <light@theendofthetunnel.de>)
Responses Re: "Quota"  (Hannes Dorbath <light@theendofthetunnel.de>)
List pgsql-general
Hannes Dorbath wrote:
>
> What would be a solution to prevent a single user/schema to fill the
> disk using PostgreSQL? Is it a good idea to use separate table spaces?

Table spaces are the only solution I can think of.
If you create a table space on a different file system, then a table in
that table space can only fill up that file system.

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: "Dmitry Koterov"
Date:
Subject: Re: Does slonik EXECUTE SCRIPT call waits for comands termination?
Next
From: Jaime Silvela
Date:
Subject: COPY to/from non-local file