pgsql database group ownership for client databases

From: "Dave" <dave(at)hawk-systems(dot)com>
To: <pgsql-general(at)PostgreSQL(dot)org>
Subject: pgsql database group ownership for client databases
Date: 2002-05-17 15:01:32
Message-ID: DBEIKNMKGOBGNDHAAKGNAEALOPAA.dave@hawk-systems.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

ISP solution, we want to allow large email quotas, but report overall disk usage
by a particular user group. for example...

client group is "mygroup"
"mygroup" has a soft quota of 200mb and hard of 250mb
"mygroup" also has two dabases mydb1 and mydb2
we want to include the usage of database files in the usage quota.

this could be simply accomplished by
chown pgsql:mygroup /usr/local/pgsql/data/base/mydb1
chown pgsql:mygroup /usr/local/pgsql/data/base/mydb2

as it doesn't appear that pgsql (the default group for these directories) has
any group permission bits set anyway. This would allow a quota check on the
/usr partition to include any databases storage used by the two databases

I do not believe that this would cause database storage and modification errors
since the pgsql user still has the ability to write into the directories
regardless of mygroup's quota status...

anyone care to sanity check this process for me?

Thanks

Dave

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Perrin 2002-05-17 15:56:22 DBD::Pg: Placeholders not working
Previous Message Vincent Stoessel 2002-05-17 14:25:42 Re: simple yet complex join