W liście z pią, 31-10-2003, godz. 11:52, Matt Clark pisze: 
> > I could made persistent connection, but with 10.000 clients it will kill
> > the server.
> 
> But if they're virtual domains, why would you need one connection per domain?  You 
> should only need one connection per apache
> process...

Because every virtual domain has its own database, username and
password. So one client domain1.com with db: domain1db user: domain1user
cannot access to second client database domain2.com db: domain2db user:
domain2user
pg_hba.conf look like this:
host    domain1db       domain1user     ip_addr netmask md5
host    domain2db       domain2user     ip_addr netmask md5
.....
....
10.000 records
...
...
host    domain10000db   domain10000user ip_addr netmask md5


You know,  one client cannot access to other client database.
So, if one process is connected to domain1db it cannto access to
domain2db, and others.


greetings
Marek


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

Reply via email to