[Bucardo-general] Bucardo Question

akp geek akpgeek at gmail.com
Fri Oct 30 19:34:33 UTC 2009


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:06 PM, Rosser Schwarz <rosser.schwarz at gmail.com>wrote:

> 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/20091030/811347e1/attachment.html 


More information about the Bucardo-general mailing list