running postgresql database from loopback filesystem?

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

Responses

Browse pgsql-general by date

  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?