Re: PostgreSQL users on webhosting
От | Jeff Davis |
---|---|
Тема | Re: PostgreSQL users on webhosting |
Дата | |
Msg-id | 1104957645.2886.41.camel@jeff обсуждение исходный текст |
Ответ на | Re: PostgreSQL users on webhosting (Jeff <threshar@torgo.978.org>) |
Список | pgsql-general |
On Wed, 2005-01-05 at 13:52 -0500, Jeff wrote: [snip] > You'd have to have separate shared buffers for each which would eat > away from the filesystem cache. Not to mention overhead of having > many more PG's running (in terms of just processes htat need to be > managed and memory used by each). True. Those are the costs. > You'd also have to have the users > connect to PG on an alternate port and that may irritate some. > You can also use unix local domain sockets. I'm not sure if that gains much, but most web hosts don't allow tcp/ip connections anyway. > In a web hosting (multi-user) environment it may make more sense. but > you could also just give each user his own db and only allow sameuser > access to each db via pg_hba.conf. > I would like to add that there are risks associated with doing that. If one user fills up the disk (like with an infinite loop in a web app) than that affects all database users, since it's running as the "postgres" user. No more commits can happen at all. Regards, Jeff Davis
В списке pgsql-general по дате отправления: