TruePrivacy + PostgreSQL
Scan PostgreSQL databases for personal data and automate DSR deletion.
Overview
PostgreSQL is the world's most advanced open-source relational database, used to store structured application data including customer records, user profiles, and transaction history. TruePrivacy connects to PostgreSQL via a dedicated read (and optionally write) database user to scan schemas and tables for personal data, classify fields by data category, and execute deletion operations for DSR compliance.
For organizations running PostgreSQL as their primary application database, TruePrivacy provides the compliance automation layer that scans the live database for personal data and executes targeted deletion queries — documented with a full audit trail for regulatory review.
What TruePrivacy can do
Data types accessed
- •Customer records
- •User profiles
- •Transaction data
- •Application event tables
- •Any structured PII in application schemas
DSR capabilities
- Execute targeted DELETE statements across tables
- Anonymise personal fields via UPDATE statements
- Export data subject records for access requests
- Search across all schemas by email or user ID
How it works
- 1
Create a dedicated PostgreSQL user for TruePrivacy with SELECT privileges on relevant schemas for discovery, and DELETE/UPDATE for DSR automation.
- 2
TruePrivacy connects via SSL and scans all tables and columns in the specified schemas, classifying personal data fields by category.
- 3
DSR requests are matched against database records by email address, user ID, or other configured identifiers.
- 4
Deletion requests execute parameterized DELETE or UPDATE statements across all relevant tables, with every query logged in TruePrivacy's audit trail.
Frequently asked questions
For data discovery, TruePrivacy needs CONNECT on the database, USAGE on relevant schemas, and SELECT on target tables. For DSR automation, it additionally needs DELETE and UPDATE on tables containing personal data. We recommend a dedicated role (e.g. trueprivacy_role) assigned only the necessary privileges.
Yes. TruePrivacy connects to PostgreSQL via standard JDBC/psycopg2 connections, which work with self-hosted PostgreSQL, AWS RDS, Google Cloud SQL, Azure Database for PostgreSQL, and Supabase.
TruePrivacy's deletion engine resolves foreign key relationships before executing deletion — deleting or anonymising child records first, then parent records, to avoid constraint violations. The deletion order is configurable and can be reviewed in the integration settings.
Connect TruePrivacy to PostgreSQL today
Start your free trial and connect PostgreSQL in 15 minutes.