Skip to main content

Questions tagged [bucardo]

Bucardo is an asynchronous PostgreSQL replication system, allowing for both multi-master and multi-slave operations.

Filter by
Sorted by
Tagged with
0 votes
0 answers
188 views

BUCARDO - PL/Perl function "validate_goat" at /usr/local/bin/bucardo

I'm new to Bucardo, I have been trying to replicate PostgreSQL-12 using Bucardo with no success due to the errors. DBD::Pg::st execute failed: ERROR: DBI connect('dbname=test1','bucardo',...) failed: ...
Shawn's user avatar
  • 101
-1 votes
1 answer
637 views

Bucardo - without Primary Key and Unique Key

I read this from Postgresql Wiki page. Cannot incrementally replicate tables without a unique key (it can "fullcopy" them) Now we have 5.5.0, so still do we need PK or unique key for this? What ...
TheDataGuy's user avatar
  • 1,950
7 votes
1 answer
4k views

Partial (filtered) replication in PostgreSQL

My setup looks something like this: I have a primary server (Postgres 9.6) that continually scrapes a bunch of data from the web. I'd like to be able to stream a subset of tables or databases from ...
jeancochrane's user avatar
2 votes
1 answer
1k views

How to keep the sync active with Bucardo

I have a master-master sync setup between 3 nodes or 3 different host machines using bucardo. All works good. However when one of the database or a host is not reachable or goes down for some reason, ...
Sijo's user avatar
  • 21