Jeff Frost jeff at pgexperts.com
Tue Sep 30 16:11:02 PDT 2014
On Sep 30, 2014, at 3:18 PM, Jeff Frost <jeff at pgexperts.com> wrote:

> Seeing this error from finishTableAfterCopy:
> 
> PGRES_FATAL_ERROR ERROR:  permission denied for relation pg_class
> CONTEXT:  SQL statement "update pg_catalog.pg_class set relhasindex ='t' where oid = i_oid"
> 
> 
> slony 2.1.4 connecting to postgresql 9.2.9 as the slony user which is a postgresql superuser.
> 
> ccom=# select * from pg_authid where rolname = 'slony';
> -[ RECORD 1 ]--+------------------------------------
> rolname        | slony
> rolsuper       | t
> rolinherit     | t
> rolcreaterole  | t
> rolcreatedb    | t
> rolcatupdate   | t
> rolcanlogin    | t
> rolreplication | f
> rolconnlimit   | -1
> rolpassword    | xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> rolvaliduntil  |
> 
> Anybody have any ideas?
> 

Also, I tried dropping the slony role and recreating it, but still having the same issue.




More information about the Slony1-general mailing list