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

[Karl Denninger]

Michelle Sullivan wrote:
> 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)
>>     
>
> FYI, you might want to take a look at:
>
> http://www.postgresql.org/docs/8.4/interactive/ddl-schemas.html
>
> When the schemas and search paths are the same you should get the same
> results for querying the tables.  Alter the table to use the full path
> or no path if necessary.
>
> Best,
>
> Michelle
Ah, it appears that when the installation script runs, it creates the
user and sets a non-default search path of it's own.

Hmmm... that sounds like a bug, as it's definitely undocumented - and
furthermore, if the remote and local hosts are different (and thus you
created the "bucardo" user on the remote using the usual "createuser"
command, you suddenly have a problem just like this.

Will investigate; it does appear that there may be fruitful results
found here....

-- Karl

-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20100801/2c85f0f9/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/2c85f0f9/attachment.vcf