[Bucardo-general] Bucardo Question

[Rosser Schwarz]

It looks like the schema the geometry type is defined in differs between
databases.  From the CREATE TYPE docs:

If a schema name is given then the type is created in the specified schema.
Otherwise it is created in the current schema. The type name must be
distinct from the name of any existing type or domain in the same schema.

Did you schema-qualify your CREATE TYPE statement on the slave, but not on
the master?

rls

On Thu, Oct 29, 2009 at 3:07 PM, akp geek <akpgeek at gmail.com> 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"
>
>
> Regards
>
>
> On Wed, Oct 28, 2009 at 2:35 PM, akp geek <akpgeek at gmail.com> wrote:
>
>> It's working now. I have super users in db table. Thanks Greg. Appreciate
>> your help
>>
>> Regards
>>
>> On Wed, Oct 28, 2009 at 10:53 AM, akp geek <akpgeek at gmail.com> wrote:
>>
>>>  Thanks Greg for responding. The point is , I am wrong.. because one of
>>> the user ( master ) is not a superuser. i will make the correction and will
>>> update you..
>>>
>>>
>>>   On Wed, Oct 28, 2009 at 10:20 AM, Greg Sabino Mullane <
>>> greg at endpoint.com> wrote:
>>>
>>>> > "validate_sync": DBD::Pg::db do failed: ERROR:  permission denied for
>>>> > database databaseName at line 231. at line 30.
>>>> > STATEMENT:  INSERT INTO bucardo.sync (name,source,synctype,targetdb)
>>>> VALUES
>>>> > ($1,$2,$3,$4)
>>>> >
>>>> > I have the permission to the database  ...
>>>>
>>>> Are you sure about that? All users in the bucardo.db table need to be
>>>> superusers.
>>>>
>>>>
>>>> --
>>>> Greg Sabino Mullane greg at endpoint.com
>>>> End Point Corporation
>>>> PGP Key: 0x14964AC8
>>>>
>>>>
>>>
>>
>
> _______________________________________________
> Bucardo-general mailing list
> Bucardo-general at bucardo.org
> https://mail.endcrypt.com/mailman/listinfo/bucardo-general
>
>


-- 
:wq
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20091029/677665a0/attachment.html