From: | Jeff Davis <jdavis-pgsql(at)empires(dot)org> |
---|---|
To: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
Subject: | running postgresql database from loopback filesystem? |
Date: | 2004-04-10 04:54:48 |
Message-ID: | 1081572887.25652.208.camel@jeff |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I have virtual hosted users on a server and some of them have a
postgresql database. I'm concerned about the outside possibility that a
user could create an infinite loop and fill up the partition on which
everyone's database resides.
Anyway, it occured to me that I could create a special file for each
database user of limited size, and make a filesystem on top of that
file. The file could be owned by the user. Then, each user could have a
seperate database and that database would be at the location of the
mountpoint of that filesystem.
It seems like a strange thing to do (an understatement, to be sure), but
is there anything wrong with it? Are there performance considerations
when using loopback devices like that? Are there dangers of corruption?
How does journaling (ext3, reiser, etc) work in that regard?
Regards,
Jeff Davis
From | Date | Subject | |
---|---|---|---|
Next Message | Janning Vygen | 2004-04-10 07:17:22 | Re: Accented chars in several apps |
Previous Message | William White | 2004-04-10 04:52:24 | Re: running postgresql database from loopback filesystem? |