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

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


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


More information about the Bucardo-general mailing list