[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