frontpage.
newsnewestaskshowjobs

Open Source @Github

fp.

Open in hackernews

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

3•polishdude20•1y ago
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

tudorg•1y 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•1y 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.

woyten•1y ago
In case you don’t have FKs you could specify virtual foreign keys in Greenmask.

Check out docs for details

https://docs.greenmask.io/latest/database_subset/#virtual-re...

abhisek•1y 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•1y ago
Oh yes I agree with you. It may become a big push to convince my org to do that

PakkaGst – A GST invoicing tool built on a phone in termux

https://github.com/hunzo1/PakkaGst
1•PakkaGst•1m ago•0 comments

Why MCP has no openapi.json

https://www.kondz.io/blog/why-mcp-has-no-openapi-json/
1•ktalik•1m ago•1 comments

Treatment delivered via electric stimulation promots hair regrowth

https://www.nature.com/articles/s41467-026-79122-3
1•saltysaltysalty•2m ago•0 comments

Artex – AI autonomous penetration testing system

https://github.com/BaaRai/ARTEX
1•pretext•3m ago•0 comments

File Search Tools (17M files, 1.5 PB total)

https://filesearch.tools/
1•o_-_o•4m ago•0 comments

What is 'the jackpot'? Are we in it? Will we die?

https://www.cnn.com/2026/11/19/us/word-of-the-week-jackpot-tech-outages-cec
1•haakon•4m ago•0 comments

Ask HN: How to stay disciplined if careless risk-taking keeps getting rewarded?

1•devrob•4m ago•0 comments

Show HN: I Did My Own – open-source projects where someone rebuilt a famous app

https://idmo.app/own
1•FullStack_Byte•5m ago•0 comments

Www

1•saltysaltysalty•7m ago•0 comments

The End of the Beginning

https://www.robinsloan.com/lab/end-of-the-beginning/
1•janvdberg•7m ago•0 comments

Show HN: HL7Guard – HL7v2 regression testing for CI (validate, deidentify, diff)

https://github.com/VariantResearch/hl7guard
1•VariantResearch•7m ago•0 comments

Reddit ends RSS feeds on November 13 and closes its public API in March 2027

https://gattyworks.com/news/reddit-ends-rss-feeds-and-public-api
4•stasomatic•7m ago•2 comments

YIMBY Reforms Tend to Lower Birthrates

https://twitter.com/MoreBirths/status/1953189968840675628
1•barry-cotter•8m ago•0 comments

Velarx: A container engine with a chain of trust from signature to page reads

https://scrivano.org/posts/2026-11-18-velarx/
1•gscrivano•8m ago•0 comments

California Governor Newsom Signed Josh Bocanegra's AI Bill SB 1111

https://medium.com/@joshbocanegra/newsom-signed-my-ai-bill-into-law-48306d5d5f50
1•jbai•9m ago•0 comments

Of the Greate Liberation of Websytes

https://elliotbonneville.com/the-internet-is-about-to-get-weird-and-beautiful/
1•elliotbnvl•9m ago•1 comments

Show HN: SideLedger Tools – invoice generator and profit calculators, no sign-up

https://165188.xyz/
1•cnczeric•10m ago•0 comments

Show HN: Oyasoo – iPhone sleep tracking from Screen Time, no watch, no mic

https://oyasoo.com/
1•orangeappl3•10m ago•0 comments

Everyone sits in the same traffic now

https://www.ystrickler.com/everyone-sits-in-the-same-traffic-now/
1•surprisetalk•10m ago•0 comments

Show HN: Zwift in Minecraft – Explore your worlds with a real bike trainer

https://github.com/michidk/VoxVelo
2•michidk•10m ago•0 comments

Google talk at REBASE'26: Agentic Coding is not going to save C++ [video]

https://www.youtube.com/watch?v=Ob0CMX8s55s
1•pjmlp•11m ago•0 comments

Cutting Windows Background Bloat: Running OneDrive on a Daily Timer

https://tonym.us/onedrive-daily-timer-scheduled-sync.html
1•speckx•12m ago•0 comments

Cooling buildings is overtaking heating them as an energy need, IEA says

https://maccus.fr/en/cooling-overtaking-heating/
2•robtherobber•13m ago•0 comments

From Closed to Open-Weight LLMs: Choosing the Inference Stack for Voice AI

https://github.com/KmiQ/articles/blob/main/choosing-the-inference-stack-for-voice-ai.md
2•cqm89•14m ago•0 comments

Does Liquidity Drive the Stock Market? We Tested 22 Years of Fed Data

2•evgeniymezenov•14m ago•0 comments

Show HN: Goaler – a daily football grid you can send to a friend

https://goaler.net/?src=hn
1•omerhdr7•14m ago•1 comments

Where we're going, we don't need chatbots

https://dbushell.com/2026/11/19/we-dont-need-chatbots/
2•BrunoBernardino•14m ago•0 comments

Rust Anything: Rewrite your app in Rust

https://www.npmjs.com/package/rust-anything
1•AbuAssar•14m ago•1 comments

Ask HN: When was the last time you thought "that's bad API design"?

2•Mitchem•17m ago•0 comments

Don't Play Anthropic's Game

https://www.nytimes.com/2026/11/19/opinion/anthropic-ipo-ai-regulation.html
3•zzzeek•17m ago•0 comments