Re: Multi tenancy : schema vs databases

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: Rakesh Kumar <rakeshkumar464(at)outlook(dot)com>
Cc: Venkata B Nagothi <nag1010(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Multi tenancy : schema vs databases
Date: 2016-09-30 17:53:22
Message-ID: CAMkU=1yu0NHv7apv_RFav7WVQN+89nb333ZoNpA7fOw7dpNksA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Sep 30, 2016 at 2:06 AM, Rakesh Kumar <rakeshkumar464(at)outlook(dot)com>
wrote:

>
> We require complete data isolation. Absolutely nothing should be shared
> between two tenants.
>

Then you need different clusters per tenant. Otherwise, the WAL records of
different tenants are inextricably mingled together.

Cheers,

Jeff

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephen Frost 2016-09-30 17:58:32 Re: Multi tenancy : schema vs databases
Previous Message Devrim Gündüz 2016-09-30 17:35:27 Re: [ANNOUNCE] pgAdmin 4 v1.0 Released!