[Bucardo-general] Bucardo Question

[Selena Deckelmann]

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