Re: performance problem - 10.000 databases

Поиск
Список
Период
Сортировка
От Marek Florianczyk
Тема Re: performance problem - 10.000 databases
Дата
Msg-id 1067602452.22237.76.camel@franki-laptop.tpi.pl
обсуждение исходный текст
Ответ на Re: performance problem - 10.000 databases  ("Matt Clark" <matt@ymogen.net>)
Ответы Re: performance problem - 10.000 databases
Список pgsql-admin
W liście z pią, 31-10-2003, godz. 12:25, Matt Clark pisze:
> Ooh, I see.  That's a tricky one.   Do you really need that level of separation?

Well, if you talk with the clients, and they promise, that they will not
access to other databasess, and specially don't do "drop database
my_bes_fried_db"
I can put:
host    any    any    0.0.0.0    0.0.0.0    trust
in the very beginning of pg_hba.conf ;)

greetings ;)
Marek

>
>
> > 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.
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>


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

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