limit database size

[exoskeleton]

hi dear experts, pls help. i was asked by my boss to limit the size of the database to 10MB per account holder. how can this be done? any code will be greatly appreciated...im using PHP and postgre database

pls help thank you...

[ronverdonk]

I think this can better be answered by PostgreSQL experts. So I will move it to the PostgreSQL forum.

Ronald :cool:

[michaelb]

In addition to the answer to your duplicate posting -
http://www.thescripts.com/forum/thread592201.html
- you can consider using a file system facilities (that is if you' running on a UNIX platform which has a support for per-user disk quota)

Provided that /dbdata is a quota-enabled partition you can try something like this:

CREATE TABLESPACE dbspace LOCATION '/dbdata'; 
CREATE DATABASE db_dbuser OWNER dbuser TABLESPACE dbspace;  
 

See the Postgres manual, CREATE TABLESPACE and CREATE DATABASE for details.

I don't like this approach, because if you run out of disk space and cannot commit a transaction you may have to do some work to recover the database.

[exoskeleton]

ok sir thank you.. i will read the manual for this command.

[exoskeleton]

I think this can better be answered by PostgreSQL experts. So I will move it to the PostgreSQL forum.

Ronald :cool:

thank you sir for moving to the right forum sir ronverdonk