[Bucardo-general] Error - permission denied for schema bucardo
Michelle Sullivan
michelle at sorbs.net
Sun Jan 30 22:25:41 UTC 2011
After adding a new table and then adding it to a swap sync and a delta
sync I see this from the database modification program trying to update
the table:
[Mon Jan 31 09:19:29 2011] geoasn.pl: DBD::Pg::db do failed: ERROR:
permission denied for schema bucardo
[Mon Jan 31 09:19:29 2011] geoasn.pl: LINE 1: INSERT INTO
bucardo.bucardo_truncate_trigger(tablename,sname...
[Mon Jan 31 09:19:29 2011] geoasn.pl: ^
[Mon Jan 31 09:19:29 2011] geoasn.pl: QUERY: INSERT INTO
bucardo.bucardo_truncate_trigger(tablename,sname,tname,sync) VALUES ( $1
, $2 , $3 , 'statistics')
[Mon Jan 31 09:19:29 2011] geoasn.pl: CONTEXT: PL/pgSQL function
"bucardo_triggerkick_statistics" line 4 at SQL statement at ./geoasn.pl
line 41.
What's the problem here? Simple fix?
Note: validate sync was used before getting this error - Bucardo version
is a GIT version
Thanks,
Michelle
More information about the Bucardo-general
mailing list