Greg Sabino Mullane greg at endpoint.com
Tue Sep 30 17:03:17 PDT 2014
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 


More information about the Slony1-general mailing list