[Bucardo-general] Error - permission denied for schema bucardo

[Geoff Williams]

Hi There,

I've had this before, users other than the superuser were not able to
truncate replicated tables because of insufficient permissions.  They
got errors like this:
        ERROR:  permission denied for schema bucardo
        LINE 1: INSERT INTO
        bucardo.bucardo_truncate_trigger(tablename,sname...
Looking at all other triggers, the bucardo.bucardo_triggerkick_SYNCNAME
one was missing the "SECURITY DEFINER" keywords to take on the role of
the bucardo user.  Once I added this, validated syncs and restarted
bucardo I was able to truncate tables as normal. 

HTH
Geoff

On Sun, 2011-01-30 at 23:25 +0100, Michelle Sullivan wrote:
> 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
> 
> _______________________________________________
> Bucardo-general mailing list
> Bucardo-general at bucardo.org
> https://mail.endcrypt.com/mailman/listinfo/bucardo-general