Re: performance problem - 10.000 databases

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: Raw Message | Whole Thread | 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.

In response to

Responses

Browse pgsql-admin by date

  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