Re: Managing multiple tenant "namespaces"

2021-04-16 Thread Mike Bayer
On Fri, Apr 16, 2021, at 7:15 AM, Nikola Radovanovic wrote: > Hi, > we have one Postgres DB with multiple schemes: > 1. general (one schema, contains users and some common and data shared > between clients/clusters) > 2. client schemes: c_client_1, c_client_2, c_client_3, etc. (all clients >

Re: Managing multiple tenant "namespaces"

2021-04-16 Thread Nikola Radovanovic
Hi, we have one Postgres DB with multiple schemes: 1. general (one schema, contains users and some common and data shared between clients/clusters) 2. client schemes: c_client_1, c_client_2, c_client_3, etc. (all clients have same table layout, and have some access to general

Re: Managing multiple tenant "namespaces"

2021-04-09 Thread Mike Bayer
On Wed, Apr 7, 2021, at 5:18 AM, Nikola Radovanovic wrote: > Hi, > I have a bit unusual use-case in software I work on. > > There are three main "namespaces" (kinds of data): first one is "general" > (not multi-tenant), where we keep some common security and settings data. > > Second one is

Managing multiple tenant "namespaces"

2021-04-07 Thread Nikola Radovanovic
Hi, I have a bit unusual use-case in software I work on. There are three main "namespaces" (kinds of data): first one is "general" (not multi-tenant), where we keep some common security and settings data. Second one is "client", where we keep clients (which are companies/organisations) and