| From: | "Matt Clark" <matt(at)ymogen(dot)net> |
|---|---|
| To: | "Marek Florianczyk" <franki(at)tpi(dot)pl> |
| Cc: | <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: performance problem - 10.000 databases |
| Date: | 2003-10-31 11:25:21 |
| Message-ID: | OAEAKHEHCMLBLIDGAFELAEDGDPAA.matt@ymogen.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Ooh, I see. That's a tricky one. Do you really need that level of separation?
> 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gaetano Mendola | 2003-10-31 12:06:58 | Re: performance problem - 10.000 databases |
| Previous Message | Marek Florianczyk | 2003-10-31 11:08:08 | Re: performance problem - 10.000 databases |