pgclone 4.0.0 is a new PostgreSQL extension that enables native SQL-based cloning of databases, schemas, and tables without relying on pg_dump, pg_restore, or shell scripts. It uses the PostgreSQL COPY protocol and custom Background Workers for high-performance parallel cloning. Key features include integrated data masking (emails, names, phone numbers) with auto-discovery of sensitive columns, full DDL support (indexes, constraints, triggers, views, sequences), flexible conflict resolution strategies, and compatibility with PostgreSQL 14 through 18. Released under the PostgreSQL Licence.
Table of contents
pgclone 4.0.0 releasedpgclone v4.0.0: Native SQL-Based Database Cloning and Data MaskingSort: