Bucardo Pros and Cons

Advantages of Using Bucardo
  • Simple to install
  • Supports multi-master, master-slave and full copy replication modes
  • It can be used to upgrade databases
  • Replication can be done between different PostgreSQL versions
Disadvantages of Using Bucardo
  • Being a trigger-based replication, the performance can be a challenge
  • Cannot handle DDL (Postgres has no triggers on system tables)
  • Cannot handle large objects (same reason)
  • Replicating a high number of tables can pose maintenance overhead
  • The infrastructure resources must be optimized for good performing replication, otherwise, the consistency cannot be achieved.
  • Cannot incrementally replicate tables without a unique key (it can “fullcopy” them)
  • Will not work on versions older than Postgres 8
Bucardo Pros and Cons
Scroll to top