On Tue, 19 Feb 2019 at 09:18, Lucas Possamai <[email protected]> wrote:
> On Tue, 19 Feb 2019 at 09:07, Lucas Possamai <[email protected]> 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!
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
