pg.ddx.io  pgsql-announce@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Brume via PostgreSQL Announce <announce-noreply@postgresql.org>
To: PostgreSQL Announce <pgsql-announce@lists.postgresql.org>
Subject: Brume: FK-safe pseudonymization for PostgreSQL test and debug copies
Date: Sat, 07 Nov 2026 12:04:54 +0000
Message-ID: <179405309462.595141.455056588245268087@wrigleys.postgresql.org> (raw)

Brume 2.1, an open source (Apache 2.0) tool that creates deterministic, foreign-key-safe pseudonymized copies of PostgreSQL databases for testing, debugging and demos, is now available.

## Why Brume?

Development teams often need realistic data to reproduce bugs, run tests or prepare demos, but copying production exposes real personal data. Classic masking scripts also tend to break referential integrity, which forces you to disable triggers, suspend constraints or repair broken joins by hand.

Brume copies a targeted subset of a source database to a target database or to a `.sql` file, and transforms personal data on the fly, before anything is written. Foreign keys stay valid end-to-end on the target. Brume only reads from the source database.

## Key features

- **Column-level strategies:** `FAKE` for realistic synthetic values, `MASK` for partial reveals, `HASH` for one-way hashing, `NULLIFY` to drop sensitive data, `FPE_ID` / `FPE_UUID` for format-preserving encryption of identifiers, and `DATE_SHIFT` to move dates while keeping their distribution.
- **Deterministic output:** transformations are keyed by your own secrets. The same input with the same secret always gives the same output, across all releases of a major version, so test fixtures and debug sessions stay stable from one run to the next.
- **Referential integrity:** format-preserving encryption rewrites primary keys and the foreign keys pointing to them consistently. With `linked_columns`, a value shared between tables that have no formal foreign key (for example, an email in both `users` and `audit_logs`) gets the same pseudonym everywhere.
- **Subsetting:** define row-level filters on any table (`created_at >= '2025-01-01'`, `tenant_id = 42`...). Brume follows foreign keys up to a configurable depth, towards parents and children, to produce a small, self-contained and coherent extract.
- **Declarative configuration:** a single `brume.yml` file describes the strategy for each table and column, with semantic types (`EMAIL`, `PHONE`, `IBAN`, `ADDRESS`...) and JSONB paths to target nested fields. The file can be version-controlled and reviewed like code before any run.

## GDPR

Pseudonymization is one of the measures cited by GDPR Articles 25 and 32. Brume gives DPOs and security teams a reviewable, auditable description of how personal data is transformed before it leaves production.

## Compatibility and installation

Brume supports PostgreSQL 12 to 18. Packages are available for Debian/Ubuntu (apt), RHEL/Fedora (dnf) and macOS (Homebrew).

## Links

- [Website and documentation](https://www.brume.software/)
- [Quickstart](https://www.brume.software/docs/getting-started/)
- [Source code](https://github.com/brumeorg/Brume)
- [Releases](https://github.com/brumeorg/Brume/releases)

Message-ID: <179405309462.595141.455056588245268087@wrigleys.postgresql.org>
Permalink:  ../179405309462.595141.455056588245268087@wrigleys.postgresql.org/
Also on:    postgresql.org/message-id/179405309462.595141.455056588245268087@wrigleys.postgresql.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-announce@postgresql.org
  Cc: announce-noreply@postgresql.org, pgsql-announce@lists.postgresql.org
  Subject: Re: Brume: FK-safe pseudonymization for PostgreSQL test and debug copies
  In-Reply-To: <179405309462.595141.455056588245268087@wrigleys.postgresql.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox