How to separate database for each tenant in Alfresco

[miroslav]

It is possible to separate database schema / database for each tenant? (legislative requirements)

[EddieMay]

Hi @miroslav 

Have you read the docs re: enterprise & multi tenant support?

[miroslav]

Thank you for the answer, I read the documentation, but I didnt find any mention of separate databases for individual tenants. In alfresco database, there is parameter "db_url" in "alf_table" (its null for each tenant). I was hoping that it possible to separate metadata.

At the moment, everything is under one database and tables are just logically partitioned. It does not meet the legislative requirements in our country for record management functionality. I will try to separate mentioned partitions using PG 13.

[afaust · Accepted solution]

There is no support for multiple / separate databases in Alfresco multi-tenancy. The db_url parameter was added way back in anticipation of a separate database being eventually supported, but it never came to that.

[miroslav]

Thank you.