[Bucardo-general] Eek - can't figure out how to fix this one....

[Karl Denninger]

Michelle Sullivan wrote:
> Karl Denninger wrote:
>   
>> So I have a database I want to replicate.
>>
>> I set up Bucardo, and tell it about both database copies - the master
>> and the remote.  All appears ok.
>> I add all the tables and sequences to a herd.
>>     
>
> <snip>
>
>   
>> [Sun Aug  1 12:44:23 2010]  MCP Warning: Source database for sync "fapforum"
>> has column "ordinal" of table "public.post_thread" with a DEFAULT of
>> "nextval
>> ('public.post_thread_ordinal_seq'::regclass)", but target database
>> "replicated_fap" has a DEFAULT of
>> "nextval('post_thread_ordinal_seq'::regclass)"
>> [Sun Aug  1 12:44:23 2010]  MCP Validation of sync fapforum FAILED
>>
>> And that's that - bang.
>>
>> A look at both shows that I did not intentionally specify the "public"
>> schema in either case.  In any event trying to specify it doesn't do me
>> a bit of good, nor does recreating the default value without the
>> "public" tag in front.  I still get the same error - the system sees the
>> "public " schema prefix on the local copy, but not on the remote one,
>> whether I have it explicitly specified or not, and as a result it won't
>> validate and start the copy.
>>
>> I'm stuck here..... this looks like an interesting alternative to SLONY,
>> but first I have to get it running :-)
>>     
>
>
> What postgres versions and OS's are you using?  What's your search path
> (for schemas)
>
> Michelle
>   
Postgres 8.4.4., FreeBSD 8.0
(18 rows)

On master:
fapforum=# show search_path;
  search_path  
----------------
 "$user",public
(1 row)


On client:
fapforum=# show search_path;
  search_path  
----------------
 "$user",public
(1 row)

fapforum=#

No differences.

-- Karl
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20100801/e496a683/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: karl.vcf
Type: text/x-vcard
Size: 124 bytes
Desc: not available
Url : https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20100801/e496a683/attachment.vcf