Hi, Mikael,
Just my 2 cents:
Mikael Carneholm wrote:
> Do you really need to create one *DB* per client - that is, is one
> schema (in the same DB) per client out of the question?
Sometimes, schemas would work _technically_, but not politically, as a
postgresql user cannot be prevented from listing all schemas (or even
all databases in the same user), regardless whether he/she has access
rights.
But it is not always acceptable that a customer knows which other
customers one has.
This forces the use of the "one cluster per customer" paradigm.
Thanks,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
