←back to thread

Ask HN: Any good tools to pgdump multi tenant database?

3 points polishdude20 | 2 comments | 16 May 25 18:48 UTC | HN request time: 0.417s | source

Just joined a new company and they run a multi tenant database in postgres where each tenant is distinguished by their account ID. I'd like to be able to dump the data of a single account to my local instance to assist in debugging.

Problem is, many of the entities do not include an account ID. For example, a user can have an account ID but a user post will not but it will be tied to a user ID.

Also foreign keys aren't really implemented fully.

Are there any tools or techniques that could help make this process easier to do?

1. abhisek ◴[16 May 25 19:04 UTC] No.44008802[source]▶
This is poor design. Multi-tenant data model design must have a tenant or segment ID for every tenant segmented tables. While it may not be a problem initially but as the business grows, you may need to move tenant data to separate DBs or even different regions based on compliance requirements. IMHO it is a good idea to run DB migrations and have a tenant ID populated in all tenant segmented tables
replies(1): >>44008850 #
2. polishdude20 ◴[16 May 25 19:11 UTC] No.44008850[source]▶
Oh yes I agree with you. It may become a big push to convince my org to do that