Hello all,

I have accidently :-) found 'initlocation' and now I like to
know, how many secondary database i can create.

I like to do that, because I have a Virtual Webserver and for
each VirtualHost I have a local $USER. Now I like to create
seperatly secondary databases for each $USER/VHost.

Thanks
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)

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQFBlNQ1C0FPBMSS+BIRAiPyAJ4to+OYAS26IRPJdaPm04 ba4eBAjQCeN7Ef
wWRRBUCRgxuftxTYhX1d2TE=
=1UtQ
-----END PGP SIGNATURE-----

As many as you have disk space for I guess. You might need one
postmaster per location but I'm not sure about that, check the docs...

On Fri, Nov 12, 2004 at 04:18:13PM +0100, Michelle Konzack wrote:


--
Martijn van Oosterhout <kleptog (AT) svana (DOT) org> http://svana.org/kleptog/
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQFBlN5QY5Twig3Ge+YRAqqYAJ46SskSDg6IH48nzEvhTz jxJVW/wQCg3tD+
q7dd7xIqrmam0wuUu9g8soo=
=Bw9H
-----END PGP SIGNATURE-----

Hello Martijn,

Am 2004-11-12 17:01:20, schrieb Martijn van Oosterhout:
I have read, that the "secondary databases" are attached to the main
database which mean, it builds a cluster. I have nothing read about
other postmasters...

Please note, that I do not run seperatly databases.
I like only to split it per $USER physicaly from the main database.

I like to have this setup for my new Virtual-Webserver where I have
for each VHost a local $USER.

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)

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQFBlOLrC0FPBMSS+BIRAuQIAKCjsqusVRNBPM7Gh+K8WL thLfkEDgCdHG6R
tpcc8odsDM0Ar2pLIkCb/hw=
=wp5Y
-----END PGP SIGNATURE-----

On Fri, 12 Nov 2004 17:20:59 +0100, Michelle Konzack
<linux4michelle (AT) freenet (DOT) de> wrote:
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.

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...

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...

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....

Regards.
Dawid

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Dawid Kuroczko wrote:


We use this version as it allows us to provide the best security
and flexibility to the customer

Sincerely,

Joshua D. Drake




--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd (AT) commandprompt (DOT) com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL



---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)

Hello Dawid,

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

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.

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.

To much administration.

:-(

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


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)

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQFBl6FnC0FPBMSS+BIRAslKAJ9KkiEyHfPnyIA6cwtqBb jf1NqNdwCfTIv0
Ae71xFT14aIyUgkS+3yZNIo=
=u8YC
-----END PGP SIGNATURE-----

Hello Joshua,

Am 2004-11-13 21:40:10, schrieb Joshua D. Drake:
This is right, but how many $USER do you have and what Computer ?

And I think, the database is only accessible local without TCP ?

If you have 100 $USER und 100 postmasers running and $USER wish
to connect via TCP how do you manage the Ports ?

I am searching a solution to split up a ~800 GByte big database...
and currently it increase around 100 MByte/day. (running with 9 x
SCSI-HDD 147 GByte in Raid-5 on a Quad-Athlon with only 4 GByte of
memory and not 8 GByte as I like)

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)

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQFBl6NoC0FPBMSS+BIRAvHKAJ94cgsYbCdPvNM2351D05 eI0AzwRwCaA8LB
70Nkan6G/yiIiNWEmjVfE6I=
=LrNe
-----END PGP SIGNATURE-----