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.,
<http://www.postgresql.org/docs/8.1/interactive/ddl-schemas.html>
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
