[Bucardo-general] ERROR: permission denied for schema - Bucardo 5

[Lucas Possamai]

On Tue, 19 Feb 2019 at 09:18, Lucas Possamai <drum.lucas at gmail.com> wrote:

> On Tue, 19 Feb 2019 at 09:07, Lucas Possamai <drum.lucas at gmail.com> wrote:
>
>> Hi.
>>
>> I am getting
>>
>> (28053) [Mon Feb 18 20:04:23 2019] MCP Warning: Killed (line 7030):
>>> DBD::Pg::st execute failed: ERROR:  permission denied for schema schematest
>>> at /usr/share/perl5/Bucardo.pm line 7030.
>>
>>
>> when executing "bucardo start".
>>
>> Permissions I've granted the bucardo user so far:
>>
>> create role bucardo with login superuser password 'password';
>>> GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA schematest TO bucardo;
>>> GRANT USAGE ON SCHEMA schematest TO bucardo;
>>
>>
>> The owner of schema "schematest" is NOT bucardo, as it is the source_db.
>>
>> Does anybody know how to fix that?
>>
>> Thanks!
>>
>
> psql -h localhost -U bucardo database_name
> select * from  schematest.table_test limit 5;
>
>
>
Select works!
>

hmm sorry this was my bad.

That error was on the target_db, and not on the source_db as I thought.
Running the command above fixed it.

Thanks!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20190219/a10fdee3/attachment.html>