[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [cobalt-users] Quotas on Database space

On Mon, 28 May 2001 14:35:16 +0300
"Andy S Panayiotou" <andy@xxxxxxxxxx> wrote:

> 
> 
> Hi all,
> I'm considering adapting an XTR for our web servering needs. What I need to
> know is if there is a way of limiting the amount of space a a certain
> website's database is using, i.e. imposing  a quota on database disk space.
> I know that the XTR allows quotas for each site under /home/ , but
> Postgresql databases are saved under /var/lib/, which does not have quotas
> enabled by default. It is also possible that other users might need to have
> access to the same database.
> Any help will be appreciated.


Yes there is a very simple way to do this.
1. copy the adequate database towards a folder in the users directory. Make sure 
he cannot touch these files if you don't want to have them destroy their own database
2.replace the database you just moved with an alias pointing to the new position
of the database ( In the users personal directory )
3.Don't forget to create the adequate cron job in order to move every newly createn database
towards the home directory of the user that created it.

This solution works with Mysql.However I have no idea what so ever about PostgresQL.

Cheers
Marco Baurdoux
Infomaniak Network SA
> 
> _______________________________________________
> cobalt-users mailing list
> cobalt-users@xxxxxxxxxxxxxxx
> To Subscribe or Unsubscribe, please go to:
> http://list.cobalt.com/mailman/listinfo/cobalt-users