Hi Greg,
Is this possible to make cascaded replication with bucardo 5.3? Here is my current set: bucardo list db Database: MM Status: active Conn: psql -p 5432 -U bucardo -d flt_v4 -h 192.168.5.60 Database: PM2 Status: active Conn: psql -p 5432 -U bucardo -d flt_v4 -h 192.168.5.69 Database: PM3 Status: active Conn: psql -p 5432 -U bucardo -d flt_v4 -h 192.168.5.214 Database: SL1_1 Status: active Conn: psql -p 5432 -U bucardo -d flt_v4 -h 192.168.5.217 Database: SL2_1 Status: active Conn: psql -p 5432 -U bucardo -d flt_v4 -h 192.168.5.218 bucardo list herd Relgroup: H1 DB: MM Members: public.clients Used in syncs: BR1, BR2, core Bucardo list dbgroups dbgroup: branch1 Members: PM2:source SL1_1:target dbgroup: branch2 Members: PM3:source SL2_1:target dbgroup: masters Members: MM:source PM2:source PM3:source bucardo list sync Sync "BR1" Relgroup "H1" DB group "branch1" PM2:source SL1_1:target [Active] Sync "BR2" Relgroup "H1" DB group "branch2" PM3:source SL2_1:target [Active] Sync "core" Relgroup "H1" DB group "masters" MM:source PM2:source PM3:source [Active] My goal is to decrease load on the master server (MM), because of huge number of potential slave servers (SL1_1 and SL2_1 in this example). Database group "masters" is under master<->master replication and I don't have a problems with replication in this configuration. But: SL1_1 receive an updates IF only data change on PM2 server happened SL2_1 receive an updates IF only data change on PM3 server happened Neither SL1_1 or SL2_1 do not receive updates if changes happened on MM. The same time MM<->PM2<->PM3 servers are getting updates well no matter where change happened. Is that possible to work around my situation and find a way how make slaves replicated correctly. Best regards, Alexander
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
