Re: performance problem - 10.000 databases - Mailing list pgsql-admin

From Marek Florianczyk
Subject Re: performance problem - 10.000 databases
Date
Msg-id 1067602452.22237.76.camel@franki-laptop.tpi.pl
Whole thread Raw
In response to Re: performance problem - 10.000 databases  ("Matt Clark" <matt@ymogen.net>)
Responses Re: performance problem - 10.000 databases  ("Matt Clark" <matt@ymogen.net>)
List 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 by date:

Previous
From: Gaetano Mendola
Date:
Subject: Re: performance problem - 10.000 databases
Next
From: "Matt Clark"
Date:
Subject: Re: performance problem - 10.000 databases