citusdata / django-multitenant

Python/Django support for distributed multi-tenant databases like Postgres+Citus
MIT License
707 stars 116 forks source link

Restore one tenant #229

Open andyp05 opened 1 month ago

andyp05 commented 1 month ago

Any best practices or instructions for restoring one tenant's data in an app using django-multitenant.

Use case: A client has a malicious or careless employee who deleted/modified data. They need to revert back to last night's backup.

Can't do a normal postgres restore or all client's will revert. Can't do a schema restore since all client's are in one schema.

Any ideas/suggestions?

Thanks