Re: How many secondary databases can I create?

Hello Dawid,

Am 2004-11-13 21:42:14, schrieb Dawid Kuroczko:

> Some time ago I talked with a friend working at some ISP, and we were
> talking about PostgreSQL's superiority to hmm, other RDBMSs... ;)
> Blah, blah, blah. The question is - how to give many many users
> access to PostgreSQL... I see three approaches, and all of these
> have pros and cons.
>
> 1) One pgsql per user -- in other words each user runs its own copy of
> pgsql -- waste of memory (each user having its own shared mem, etc),
> but can enforce quota limits, etc. Hard to keep all those copies of
> pgsql running.

This is what I have tried for 2 (???) years... and failed. It need to
much memory. I have on one of my older Servers only ~140 VHosts/$USERS
and I have tried to start for each $USER a postmaster... I was running
out of memory with 4 GByte of RAM on a Dual Athlon.

> 2) one pgsql database per user. Probably most common. :) Each user
> has full pgsql database at her disposal. It's a bit hard to manage quotas,
> dbsize comes in handy but it involeves creating some sort of "quota
> enforcing" daemon...

This is what I like to do, but if I use

initlocation /home/$USER/.postgresql/

to create a secondary database and use my it with tha master db as
cluster, I do not know, how I put the $USER database into this
location...

It seems not to be possibel.

I think, it works only, If I have ond HDD and it is not enough
diskspace so I attach a second HDD and a secondary db on the new HDD.

> 3) one pgsql database with one schema per user. Interesting, can very
> easily create many "databases", does not give full pgsql power, harder
> to manage quotas than previous model...

To much administration.

> Hmm, I wonder what are the feelings of people using such models.
> I did not use them, so I have no idea. And I wonder how problematic
> is "quota enforcement" there....

:-(

I have the wish, that $USER can create a secondary/cluster database
in there own $HOME. A feature which I am missing...

> Regards.
> Dawid

Greetings
Michelle

--
Linux-User #280138 with the Linux Counter, http://counter.li.org/
Michelle Konzack Apt. 917 ICQ #328449886
50, rue de Soultz MSM LinuxMichi
0033/3/88452356 67100 Strasbourg/France IRC #Debian (irc.icq.com)