Re: performance problem - 10.000 databases

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
>