[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