[Bucardo-general] Bucardo Question

[akp geek]

the issue got resolved. This is what I did. I have bucardo user on the
database where the bucardo was installed. on the other databse ( master
database ), I did not have the bucardo user. I am using the postgres. I ran
into this issue. I corrected the search path also. I have created a bucardo
user as superuser. Now I restarted the bucardo and it started working
fine...

thanks for the support and valuable suggestion

regards

On Thu, Oct 29, 2009 at 7:12 PM, Selena Deckelmann <selena at endpoint.com>wrote:

> akp geek wrote:
>
>> Hi All -
>>
>>                I am trying to replicate a table using Bucardo. The
>> table is a spatial table. I have all the GIS related tables under public
>> schema. We have the table for replication in other schema . When I do
>> the replication it is giving me the following error. Can you please help?
>>
>>  Source database for sync "sync_51_124" has column "shapeplanar" of
>> table "mySchema.location" as type "geometry", but target database
>> "slave_124" has a type of "public.geometry"
>>
>
> This may be a search_path issue. Check on your 'bucardo' user's search path
> on both systems and make sure they are *exactly* the same.
>
> You can check it with 'select rolname,rolconfig from pg_roles'.  You can
> set it with ALTER ROLE ... etc.
>
> -selena
>
> --
> Selena Deckelmann
> End Point Corporation
> selena at endpoint.com
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20091030/22410b5a/attachment.html