Forum OpenACS Q&A: Response to Problem dumping under pg 7.1

Collapse
Posted by Don Baccus on
This is superficially like a perms problem reported for views, where you could have a view readable by a user but the underlying dummy table not readable by the user, causing PG dump to fail due to a perms problem.

But sequences don't create an underlying dummy table AFAIK...

This problem doesn't occur with simple, vanilla setups (at least, it didn't for me) - what kind of user permissions have you set up?  Have you tried granting all permissions on the sequence to the postgres user before dumping?

You may want to talk to the PG development folks about this directly - after upgrading to PG 7.1.2, though, as the view/table problem may've been fixed (and I know some other dump problems were fixed).