Re: Is postgresql ca do the job for software deployed in

From: Markus Schaber <schabi(at)logix-tt(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Is postgresql ca do the job for software deployed in
Date: 2006-07-05 10:38:20
Message-ID: 44AB969C.6090604@logix-tt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Gregory S. Williamson 2006-07-05 11:06:23 Re: Is postgresql ca do the job for software deployed in
Previous Message Tomasz Ostrowski 2006-07-05 08:33:59 Re: query very slow when enable_seqscan=on