Tue Sep 30 16:11:02 PDT 2014
- Previous message: [Slony1-general] 2.1.4 can't update pg_class as superuser
- Next message: [Slony1-general] 2.1.4 can't update pg_class as superuser
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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.
- Previous message: [Slony1-general] 2.1.4 can't update pg_class as superuser
- Next message: [Slony1-general] 2.1.4 can't update pg_class as superuser
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list