[Bucardo-general] newbie questions

[Joe Conway]

On 06/12/2010 02:40 PM, Joe Conway wrote:
> If I want to set up a swap sync:
> 
> 1) Is there a bucardo_ctl function to set "standard_conflict"
>    or does it need to be done by manually modifying goat?
> 2) What should "standard_conflict" be set to for sequences?
> 3) How do sequences behave in a multi-master scenario?

Probably related, but after manually modifying goat like so:

8<---------------------------------------------------
# psql -U bucardo -c "update goat set \
   standard_conflict = 'latest' where standard_conflict \
   is NULL and reltype = 'table'"
 UPDATE 64
8<---------------------------------------------------

I seemingly successfully added a sync

8<---------------------------------------------------
# bucardo_ctl add sync pres_swap source=alpha \
   targetdb=pres_slave1 type=swap
 Added sync "pres_swap"
8<---------------------------------------------------

and then started Bucardo

8<---------------------------------------------------
# bucardo_ctl start
 Checking for existing processes
 Removing /var/run/bucardo/fullstopbucardo
 Starting Bucardo
8<---------------------------------------------------

However, replication is not running, and at the log shows:

8<---------------------------------------------------
# tail log.bucardo
[Sat Jun 12 16:09:56 2010]  MCP Warning: Source database for sync
"pres_swap" has column "f0" of table "public.foo" with a DEFAULT of
"nextval('public.foo_f0_seq'::regclass)", but target database
"pres_slave1" has a DEFAULT of "nextval('foo_f0_seq'::regclass)"
[Sat Jun 12 16:09:56 2010]  MCP     Checking column on target database
"pres_slave1": "f1" (integer)
[Sat Jun 12 16:09:56 2010]  MCP     Checking column on target database
"pres_slave1": "f2" (text)
[Sat Jun 12 16:09:56 2010]  MCP Validation of sync pres_swap FAILED
[Sat Jun 12 16:09:56 2010]  MCP Active syncs: 0
[Sat Jun 12 16:09:56 2010]  MCP No active syncs were found, so we are
exiting
8<---------------------------------------------------

So I guess I'm still looking for the swap sync formula in the context of
sequences, and wondering why "bucardo_ctl add sync ..." appears to have
succeeded even though it apparently should not have.

Thanks,

Joe

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 899 bytes
Desc: OpenPGP digital signature
Url : https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20100612/6124f088/attachment.bin