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