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