Bucardo
bucardo.org
What it is
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.
Spec sheet
- Purpose
- Bucardo is an asynchronous PostgreSQL replication system for multi-source, multi-target operations.Read 9 Oct 2026 · bucardo.org
- Community support
- The project directs usage questions, bug reports, feature requests, and general discussion to its Bucardo-general mailing list, and also provides an IRC channel.Read 9 Oct 2026 · bucardo.org
- Conflict handling
- For multi-source syncs, Bucardo runs a standard conflict handler or a custom handler set per table.Read 9 Oct 2026 · bucardo.org
- Current published release
- The project page lists Bucardo 5.6.0 as its latest version and links to a downloadable archive and signature.Read 9 Oct 2026 · bucardo.org
- Daemon platforms
- The daemon requires a Unix-like system, has been tested primarily on Linux and macOS, and does not run natively on Windows.Read 9 Oct 2026 · bucardo.org
- Data selection
- Users configure named syncs to copy specific sets of tables between a server and one or more servers.Read 9 Oct 2026 · bucardo.org
- How it works
- A Perl daemon listens for NOTIFY requests and connects to remote databases to copy data.Read 9 Oct 2026 · bucardo.org
- Installation
- Bucardo can be installed from source, with RPM or Debian packages, or through FreeBSD Ports.Read 9 Oct 2026 · bucardo.org
- Notable limitation
- Bucardo does not replicate DDL or schema changes.Read 9 Oct 2026 · bucardo.org
- PostgreSQL requirements
- The configuration database and replication databases must use PostgreSQL 8.1 or higher; the configuration database also needs PL/pgSQL and PL/PerlU.Read 9 Oct 2026 · bucardo.org
- Professional support
- End Point Dev offers professional support for Bucardo.Read 9 Oct 2026 · bucardo.org
- Replication modes
- It supports multi-source and multi-target replication, including one-direction master-standby replication.Read 9 Oct 2026 · bucardo.org
- Security notices
- The Bucardo-announce mailing list is used for notices about new versions, important bugs, and security warnings.Read 9 Oct 2026 · bucardo.org
- Truncate support
- Truncate replication requires PostgreSQL 8.4 or higher and is currently fully working only for pushdelta syncs.Read 9 Oct 2026 · bucardo.org
Plans and prices
Strong points and limits
Strong points
- Free and open source under a BSD license
- Supports multi-source and multi-target replication
- Custom conflict handlers can be assigned per table
- Named syncs select tables to copy
- Source and package installation options
Limits
- No native Windows daemon
- Does not replicate DDL or schema changes
- Requires PostgreSQL 8.1 or higher
- Truncate support has version and sync limits
Who it suits
It suits teams running PostgreSQL replication on Linux, macOS or another Unix-like self-hosted environment. It is relevant where asynchronous, multi-way table synchronization is needed and schema changes can be managed separately.
Verdict
Bucardo provides configurable asynchronous PostgreSQL replication without a license charge. Its operating-system, PostgreSQL-version and schema-change limits should be checked before deployment.
Where Specifiction places it
- Database Replication Software#9 of 328.1
- Data Replication Software#10 of 278.1