postgresql user quota

From: "Sandro Serafini" <s(dot)serafini(at)iam(dot)it>
To: pgsql-admin(at)postgresql(dot)org
Subject: postgresql user quota
Date: 2000-07-18 07:53:24
Message-ID: 20000718075324.671.qmail@sandro.vi.nettuno.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi!

I need to limit the postgresql user's quotas on my system...

I noticed that postgres creates a new directory for every database, so I tried
changing the owner of the directory and the files within the directory to the
unix user "owner" of the database, setting the group so the postgres daemon
works.

All works correctly, the postgres user is subject to the system quota and when
a user inserts too much data inside his tables, the system gives him an error.

BUT... there's a problem... when the postmaster creates new files (for
example, creating a new table), the new files fall into user "postgres" and
not the user owning the database.

Some ideas??

---
Sandro Serafini
Internet & Multimedia - POP Nextra - NETTuno
Via G.B. Imperiali, 75 - 36100 Vicenza - Italy

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Karel Zak 2000-07-18 08:25:16 Re: postgresql user quota
Previous Message Todd McGrath 2000-07-14 19:46:01 newbie Date question