Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wHMok-0076mc-23 for pgsql-announce@arkaria.postgresql.org; Mon, 27 Apr 2026 14:20:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wHMoj-00E9qj-2u for pgsql-announce@arkaria.postgresql.org; Mon, 27 Apr 2026 14:20:09 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wHMoi-00E9qa-2Z for pgsql-announce@lists.postgresql.org; Mon, 27 Apr 2026 14:20:09 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wHMof-000000032XT-14Vk for pgsql-announce@lists.postgresql.org; Mon, 27 Apr 2026 14:20:07 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:From:To:Subject: MIME-Version:Content-Type:Sender:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=4ZM5dN69jY2LJw5rwaLdMUEwFZPjT2FboNi3ylW2xb0=; b=MZYzaruY5AwuIinwqF+KrqMreW HvTuzosLCHQKIr/hlyA6c2wvvfjqAf+UKQDvIe7E4k96WXk7LR6kgZbQwJjwog0374gcCm7W9RKU+ UO5YT1wONr9GkBLG+LFXf5+RicJ5iJjS9e443QzV6+/Yn1JHmOcvKFoNz3qd3zQpLH9+/W7MKyh9G lrX713Uq3EgmCLGOjoFuWBX7a3GKuTMoup0kK+TVGI9px3nfl98cSjRIV0MtNDw8mg7c0Obxh+h40 XG1qEWcJlXARk0eOd1XJ8l92y7SRB9d8otY4kfVCRWIZF1+gbdlthapCwb1g9H25UPgcb7DeqRaMA A1+XjXZw==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wHMoe-009HDJ-1w for pgsql-announce@lists.postgresql.org; Mon, 27 Apr 2026 14:20:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wHMoc-0031Al-34 for pgsql-announce@lists.postgresql.org; Mon, 27 Apr 2026 14:20:03 +0000 Content-Type: multipart/alternative; boundary="===============5872885461319547042==" MIME-Version: 1.0 Subject: pgclone 4.0.0 released To: PostgreSQL Announce From: Valeh Agayev via PostgreSQL Announce Reply-To: valeh.agayev@gmail.com Date: Mon, 27 Apr 2026 14:19:23 +0000 Message-ID: <177729956373.4131768.13197674367580204736@wrigleys.postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated X-pglister-tags: related X-pglister-tagsig: 5412fc162e330006eebc50d1f8930a289e2d4f792c6b46af77ab35c735be956a List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============5872885461319547042== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable # pgclone v4.0.0: Native SQL-Based Database Cloning and Data Masking **Baku, Azerbaijan =E2=80=94 April 22, 2026** I am pleased to announce the release of **pgclone** version 4.0.0, a PostgreSQL extension that clones databases, schemas, and objects directly v= ia SQL. It features built-in data masking, parallel background workers, and full DDL support =E2=80=94 with no dependency on `pg_dump`, `pg_restore`, o= r external shell scripts. pgclone is released as open source under the PostgreSQL Licence. ## Description **pgclone** provides a seamless way to clone PostgreSQL objects across instances using nothing but SQL commands. By leveraging the PostgreSQL `COP= Y` protocol and custom Background Workers (BGW), it offers a high-performance, integrated alternative to traditional dump/restore workflows. ## Key Capabilities - **Native SQL Interface:** Clone databases, schemas, and tables without leaving `psql` or managing shell scripts. - **Integrated Data Masking:** Anonymize sensitive data (emails, names, phone numbers, hashes) during the cloning process using built-in masking functions. - **Auto-Discovery:** Automatically scan source schemas to identify sensitive columns and receive suggested masking rules. - **High Performance:** Parallel background workers handle concurrent table cloning, with real-time progress tracking via `pgclone.jobs_view`. - **Full DDL Support:** Preserves indexes, constraints (PK, UNIQUE, CHECK, FK, EXCLUDE), triggers, views, and sequences. - **Flexible Conflict Resolution:** Choose between `error`, `skip`, `replace`, or `rename` strategies when objects already exist. - **Cross-Version Compatibility:** Tested on PostgreSQL 14, 15, 16, 17, and 18. - **Open Source:** Distributed under the PostgreSQL Licence =E2=80=94 the s= ame permissive licence used by PostgreSQL itself. ## Links & Resources We welcome contributions and feedback from the community to help make pgclo= ne even better. - **GitHub:** https://github.com/valehdba/pgclone - **Release v4.0.0:** https://github.com/valehdba/pgclone/releases/tag/v4.0= .0 - **PGXN:** https://pgxn.org/dist/pgclone/4.0.0/ - **Usage Guide:** https://github.com/valehdba/pgclone/blob/main/docs/USAGE= .md - **Async Operations:** https://github.com/valehdba/pgclone/blob/main/docs/= ASYNC.md - **Architecture:** https://github.com/valehdba/pgclone/blob/main/docs/ARCH= ITECTURE.md - **Manual Testing:** https://github.com/valehdba/pgclone/blob/main/docs/TE= STING_MANUAL.md --- --===============5872885461319547042== Content-Type: text/html; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable pgclone 4.0.0 released
 

pgclone 4.0.0 released

pgclone v4.0.0: Native SQL-Based Database Cloning and Data Masking

Baku, Azerbaijan =E2=80=94 April 22= , 2026

I am pleased to announce the release of pgclone version 4.0.0, a PostgreSQL extension that clones databases, schemas, and objects directly v= ia SQL. It features built-in data masking, parallel background workers, and full DDL support =E2=80=94 with no dependency on pg_dump, pg_restore, or external shell scripts. pgclone is released as open source under the PostgreSQL Licence.

Description

pgclone provides a seamles= s way to clone PostgreSQL objects across instances using nothing but SQL commands. By leveraging the PostgreSQL COPY protocol and custom Background Workers (BGW), it offers a high-performance, integrated alternative to traditional dump/restore workflows.

Key Capabilities

  • Native = SQL Interface: Clone databases, schemas, and tables without leaving psql or managing shell scripts.
  • Integra= ted Data Masking: Anonymize sensitive data (emails, names, phone numbers, hashes) during the cloning process using built-in masking functions.
  • Auto-Di= scovery: Automatically scan source schemas to identify sensitive columns and receive suggested masking rules.
  • High Pe= rformance: Parallel background workers handle concurrent table cloning, with real-time progress tracking via pgclone.jobs_view.
  • Full DD= L Support: Preserves indexes, constraints (PK, UNIQUE, CHECK, FK, EXCLUDE), triggers, views, and sequences.
  • Flexibl= e Conflict Resolution: Choose between error, sk= ip, replace, or rename strategies when objects alre= ady exist.
  • Cross-V= ersion Compatibility: Tested on PostgreSQL 14, 15, 16, 17, and 18.
  • Open So= urce: Distributed under the PostgreSQL Licence =E2=80=94 the same permissive licence used by PostgreSQL itself.

Links & Resources

We welcome contributions and feedback from = the community to help make pgclone even better.

  • GitHub:= https://github.com/valehdba/pgclone
  • Release= v4.0.0: https://github.com/valehdba/pgclone/releases/tag/v4.0.0
  • PGXN: https://pgxn.org/dist/pgclone/4.0.0/
  • Usage G= uide: https://github.com/valehdba/pgclone/blob/main/docs/USAGE.md<= /li>
  • Async O= perations: https://github.com/valehdba/pgclone/blob/main/docs/ASYN= C.md
  • Archite= cture: https://github.com/valehdba/pgclone/blob/main/docs/ARCHITEC= TURE.md
  • Manual = Testing: https://github.com/valehdba/pgclone/blob/main/docs/TESTIN= G_MANUAL.md
This email was sent to you from Valeh Agayev. It was delivered on their beh= alf by the PostgreSQL project. Any questions about the content of the message shou= ld be sent to Valeh Agayev.

You were sent this email as a subscriber of the pgsql-announce mai= linglist, for the content tag Related Open Source. To unsubscribe from further emails, or change which emails you want to receive, please click th= e personal unsubscribe link that you can find in the headers of this email, or visit https://lists.postgresql.org/unsubscribe/.
 
--===============5872885461319547042==--