Foundry (YC F24) Is Hiring – Founding Engineer (ML × SWE) (ycombinator.com)

1 points by lakabimanil 17h ago 0 comments

Dalus (YC W25) is hiring an engineer for hardware system design software (ycombinator.com)

1 points by sebastianvoelkl 22h ago 0 comments

Wasmer (YC S19) Is Hiring a Rust Compiler Engineer (workatastartup.com)

1 points by syrusakbary 1d ago 0 comments

Fetii (YC S22) Is Hiring (ycombinator.com)

1 points by Mattiommi 1d ago 0 comments

PermitFlow (YC W22) Is Hiring Senior/Staff Engineers in NYC (jobs.ashbyhq.com)

1 points by samuelklam 1d ago 0 comments

Tiptap (YC S23) Is Hiring (ycombinator.com)

1 points by philipisik 2d ago 0 comments

StackAI (YC W23) Is Hiring Pydantic and FastAPI Wizard (ycombinator.com)

1 points by baceituno 2d ago 0 comments

Artie (YC S23) Is Hiring a Senior Product Marketing Manager (SF) (ycombinator.com)

1 points by tang8330 2d ago 0 comments

Legion Health (YC S21) is hiring engineers to help fix mental health with AI (workatastartup.com)

1 points by the_danny_g 4d ago 0 comments

Spark AI (YC W24) Is Hiring a Full Stack Engineer in San Francisco (ycombinator.com)

1 points by tk90 4d ago 0 comments

Synder (YC S21) Is Hiring (ycombinator.com)

1 points by michaelastreiko 5d ago 0 comments

Roame (YC S23) Is Hiring Lead Fullstack Engineer (ycombinator.com)

1 points by timqin 5d ago 0 comments

Weave (YC W25) is hiring a founding engineer (ycombinator.com)

1 points by adchurch 6d ago 0 comments

Rollstack (YC W23) Is Hiring TypeScript Engineers (Remote US/CA) (ycombinator.com)

1 points by yjallouli 7d ago 0 comments

Ciro (YC S22) is hiring a software engineer to build AI agents for sales (ycombinator.com)

1 points by dwiner 8d ago 0 comments

Artifact (YC W25) Is Hiring (ycombinator.com)

1 points by antonysamuel 8d ago 0 comments

Thunder Compute (YC S24) Is Hiring a C++ Low-Latency Systems Developer (ycombinator.com)

1 points by cpeterson42 9d ago 0 comments

GovEagle (YC W23) Is Hiring (ycombinator.com)

1 points by gabev 9d ago 0 comments

Motion (YC W20) Is Hiring a Senior Engineers (jobs.ashbyhq.com)

1 points by ethanyu94 9d ago 0 comments

Tabular (YC S24) Is Hiring (ycombinator.com)

1 points by kilianjustus 10d ago 0 comments

Continue (YC S23) is hiring software engineers in San Francisco (ycombinator.com)

1 points by tydunn 10d ago 0 comments

Instant (YC S22) Is Hiring a Founding TypeScript Engineer (instantdb.com)

1 points by stopachka 11d ago 0 comments

Jiga (YC W21) Is Hiring Engineers (workatastartup.com)

1 points by grmmph 11d ago 0 comments

KaiPod Learning (YC S21) Is Hiring VP of Engineering (ycombinator.com)

1 points by amarkumar81 12d ago 0 comments

Hightouch (YC S19) Is Hiring (ycombinator.com)

1 points by joshwget 12d ago 0 comments

Helpcare AI (YC F24) Is Hiring (docs.google.com)

1 points by hsial 13d ago 0 comments

Stellar Sleep (YC S23) is hiring a product engineer in SF (ycombinator.com)

1 points by edreichua 13d ago 0 comments

OneText (YC W23) Is Hiring a DevOps/DBA Lead Engineer

1 points by bluepnume 14d ago 0 comments

Toma (YC W24) Is Hiring Engs #3-4 (AI for Automotive) (ycombinator.com)

1 points by anthonykrivonos 14d ago 0 comments

Waypoint Transit (YC W25) is hiring a software engineer (workatastartup.com)

1 points by varuntandon 15d ago 0 comments

GroMo (YC W21) Is Hiring (ycombinator.com)

1 points by darpank 16d ago 0 comments

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

3 polishdude20 4 5/16/2025, 6:48:35 PM

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?

Comments (4)

tudorg · 15h ago

You can try with data subsetting tools, a few that I know are: greenmask, jailer, tonic condenser, and I think there are more. They are not exactly for your use case, but might help you a bit. The problem is most of these tools can walk foreign keys, but only in one directions.

Also, since you said FK are not fully implemented, then there just won't be enough information for them to work with. So you can either work on fixing the foreign keys or have more complex scripts.

polishdude20 · 15h ago

Thanks for the suggestions!

Yeah due to the unavailability of FK's, I'd have to somehow map certain ID columns to the tables they're for, accounting for slight naming convention differences.

abhisek · 15h ago

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

polishdude20 · 15h ago

Oh yes I agree with you. It may become a big push to convince my org to do that