Bucardo vs dsync

Bucardo is a free, open-source system for asynchronous PostgreSQL replication in multi-source and multi-target arrangements. It supports multi-way synchronization and one-direction master-standby replication. Users define named syncs that copy selected tables between a server and other servers. A Perl daemon listens for NOTIFY requests and connects to remote databases to copy data. Multi-source setups can use a standard conflict handler or a custom handler assigned per table. Configuration and replication databases require PostgreSQL 8.1 or later, while the configuration database also needs PL/pgSQL and PL/PerlU. The daemon needs a Unix-like operating system, is tested mainly on Linux and macOS, and does not run natively on Windows. Installation is available from source, RPM or Debian packages, and FreeBSD Ports. Bucardo does not replicate DDL or schema changes. The listed latest release is 5.6.0.

dsync moves data between databases and other data stores through one-time migrations or ongoing, one-way replication. After the initial copy, it can watch the source and apply later changes at the destination. The open source edition is a single binary that can run on a laptop, VM, or Docker container. Connectors include MongoDB, Cosmos DB, DynamoDB, AWS DocumentDB, PostgreSQL, S3, and CSV files; several others are still in preview or development. Checks range from quick namespace counts to full hash-based verification, and saved state lets an initial copy or change-capture flow resume. Progress appears in the CLI and a web page hosted on the machine running dsync. Adiom says dsync does not store data and supports network encryption. Transformations can use external processes connected over gRPC. It does not replicate source DDL statements or indexes. With a metadata store for resumability, the open source version has a 16 MB read-plan cap. Enterprise adds horizontal scalability, observability, and transformations. The open source plan is free.