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

LZ-RDO lands in ARM's astc-encoder

https://www.jonolick.com/home/lz-rdo-lands-in-arms-astc-encoder
1•dverlaeckt80•1m ago•0 comments

Show HN: x402-reconcile – check x402 payments against the chain

https://github.com/parthod0x/x402-reconcile
1•parthod0x•1m ago•0 comments

Running helped me recover from dizziness in the era of LLMs

https://geopet85.github.io/2026/11/18/running-helped-me-recover-from-dizziness.html
1•higeorge13•1m ago•0 comments

Data Contracts

https://martinfowler.com/articles/data-contracts.html
1•javaeeeee•2m ago•0 comments

Probe – crypto search, cited answers, both sides

https://www.probebyuplx.com
1•supersonicsonny•3m ago•0 comments

Title: Building Blocks for a Greener Skyline

https://news.mit.edu/2026/building-blocks-for-greener-skyline-miana-smith-1118
1•Hasitron•4m ago•0 comments

Show HN: Helio, compare your energy on days with and without each habit

https://apps.apple.com/us/app/helio-energy-tracker-habits/id6760257944
1•alexslkmain•5m ago•0 comments

Feather: Elegant Email Inbox

https://feather.computer/
1•frjalex•6m ago•0 comments

Show HN: ShipShape Scan – a passive security check for vibe-coded apps

https://shipshapescan.com
1•Xflash•6m ago•0 comments

LLMs can read and write executables byte by byte from a hex dump

https://sgiannopoulos.github.io/blog/machine-code-programming/
1•fortran77•8m ago•0 comments

More than one in four public MCP servers can take an action nobody can undo

https://github.com/RinwallDev/rinwall/blob/master/research/2026-10-public-mcp-scan.md
1•kn42428•9m ago•0 comments

ABFS: Google's open filesystem that cuts Android checkout from 36 min to 8 s

https://developers.googleblog.com/en/accelerating-development-for-massive-git-repositories/
2•fortran77•9m ago•0 comments

Privacy protected folders in macOS 27.3

https://eclecticlight.co/2026/11/18/privacy-protected-folders-in-macos-27-3/
2•Brajeshwar•10m ago•1 comments

Antipode – A local synth I built for my own music

https://github.com/mchl-schrdng/antipode-audio
1•Redeemer06•10m ago•1 comments

Startup Makes Headway Towards Formalizing All of Math with AI

https://spectrum.ieee.org/enormous-theorem-ai
1•pseudolus•10m ago•0 comments

The financial rules AI agents break when chasing results

https://www.unite.ai/the-financial-rules-ai-agents-break-when-chasing-results/
2•50kIters•11m ago•0 comments

San Diego dumps both Flock cameras and smart streetlights

https://arstechnica.com/tech-policy/2026/11/san-diego-dumps-both-flock-cameras-and-smart-streetli...
1•pseudolus•12m ago•0 comments

Illustrations of Impossible Creatures by Wildlife Artist Tim Andraka

https://twitter.com/pmamtraveller/status/2122897308090351668
1•MrBuddyCasino•12m ago•0 comments

What is FIDO2? WebAuthn, CTAP and passkeys explained

https://u2secured.com/blog/what-is-fido2
1•u2secured_team•12m ago•0 comments

OpenMetadata: The Open Context Layer for Data and AI

https://github.com/open-metadata/OpenMetadata
1•saikatsg•12m ago•0 comments

The Danish Concept

https://ninjasandrobots.com/the-danish-concept
1•nate•12m ago•0 comments

Show HN: An audit log for what our open-source agent memory learns offline

https://honcho.dev/blog/dream-histories
2•vvoruganti•13m ago•0 comments

Show HN: Reflektor – Turn AI PRs into something a human can review

https://github.com/bashovski/reflektor
2•anurbasic•14m ago•1 comments

More load is faster: Tuning Postgres read replicas

https://clickhouse.com/blog/tuning-postgres-read-replicas
1•tudorg•14m ago•0 comments

Show HN: Padit – Local-first personal finance app

https://padit.app
1•trollr•14m ago•0 comments

Should I keep building Publio or let it go?

https://cauenapier.com/blog/should-i-keep-building-publio-or-let-it-go/
1•speckx•15m ago•0 comments

Show HN: ServerDog – Deploy to your own servers from a Mac, no vendor holds keys

https://serverdog.app/
1•fulanw•15m ago•0 comments

Show HN: Indexed_bzip2 2.0 – I used AI to make bzip2 decompression 4x faster

https://github.com/mxmlnkn/librapidarchive/releases/tag/v2.0.0
2•mxmlnkn•15m ago•0 comments

The Public Launch of SolveIt

https://www.fast.ai/posts/2026-11-16-solveit-launch/
1•simonpure•15m ago•0 comments

Bytebase: Open-source database governance platform

https://github.com/bytebase/bytebase
2•saikatsg•17m ago•0 comments