Tue Sep 30 17:03:17 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 Tue, Sep 30, 2014 at 03:18:42PM -0700, Jeff Frost wrote: > Seeing this error from finishTableAfterCopy: > > PGRES_FATAL_ERROR ERROR: permission denied for relation pg_class > > slony 2.1.4 connecting to postgresql 9.2.9 as the slony user which is a postgresql superuser. > ... > rolname | slony > rolsuper | t At the risk of stating the obvious, triple check the right role is being used. If your log_line_prefix has a %u, check that in the error message. Or try dropping the slony user and try rerunning. If that gives the expected error, double check it has rolsuper /and/ rolcatupdate set. -- Greg Sabino Mullane greg at endpoint.com End Point Corporation PGP Key: 0x14964AC8 -------------- next part -------------- A non-text attachment was scrubbed... Name: not available Type: application/pgp-signature Size: 163 bytes Desc: Digital signature Url : http://lists.slony.info/pipermail/slony1-general/attachments/20140930/e75263eb/attachment.pgp
- 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