Re: performance problem - 10.000 databases

Поиск
Список
Период
Сортировка
От Matt Clark
Тема Re: performance problem - 10.000 databases
Дата
Msg-id OAEAKHEHCMLBLIDGAFELAEDGDPAA.matt@ymogen.net
обсуждение исходный текст
Ответ на Re: performance problem - 10.000 databases  (Marek Florianczyk <franki@tpi.pl>)
Ответы Re: performance problem - 10.000 databases  (Marek Florianczyk <franki@tpi.pl>)
Список 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.



В списке pgsql-admin по дате отправления:

Предыдущее
От: Marek Florianczyk
Дата:
Сообщение: Re: performance problem - 10.000 databases
Следующее
От: Gaetano Mendola
Дата:
Сообщение: Re: performance problem - 10.000 databases