Re: Multiple customers sharing one database?

On Jun 3, 2007, at 12:45 , Lew wrote:

> Michael Glaesemann wrote:
>
>> Unless the database schema is shared by the different customers,  
>> I'd set up a separate database for each. There's better security  
>> with separate databases, and since different customer's data would  
>> never be combined, there's no advantage to putting them in the  
>> same one. Per database overhead is probably going to be negligible  
>> compared to the infrastructure you'd want to put in place for  
>> security.
>
> I am always confused by the overloaded term "database" in such  
> discussions. Do we mean the RDBMS engine, i.e., run separate  
> instances of PG?  I sure would recommend against that.  Or do we  
> mean it as the PG documentation does, e.g.,
> 

I likewise try to be careful in my usage of database and database  
server as they are different things. I meant (and used) database, not  
database server.

Michael Glaesemann
grzm seespotcode net