This guide covers how to connect PostgreSQL databases to OwlMask and configure robust masking rules for sensitive columns.
Video Chapters — the 11 Steps
- 00:14 — Prerequisites: A read-only role is the only PostgreSQL setup you need.
- 00:32 — Step 1, Connect: Host, port, database, user, and SSL mode for source and target.
- 00:56 — Step 2, Scan the schema: Tables, row estimates, foreign keys, sequences, constraints.
- 01:18 — Steps 3–4, Discover and review PII: Classification with confidence scores, including jsonb columns.
- 02:02 — Step 5, Build the masking profile: Synthetic, format-preserving, and deterministic rules per column.
- 02:30 — Steps 6–7, Integrity and constraints: FK remapping, uniqueness, NOT NULL, and sequences preserved.
- 03:08 — Steps 8–9, Readiness and run: The gated job streaming three million rows to the target.
- 03:54 — Steps 10–11, Verify and validate: psql spot-checks, then a full PII re-scan with zero findings.
Related external video
PostgreSQL Anonymization Concepts
Next Steps
Ready to try it out? Start by configuring your first PostgreSQL connection in the OwlTable Manager or read more about PostgreSQL specifics in our documentation.