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

Lucas Possamai drum.lucas at gmail.com
Mon Feb 18 20:18:26 UTC 2019


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!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20190219/265e63bf/attachment.html>


More information about the Bucardo-general mailing list