Re: Large Object permissions lost in transfer

On Monday, April 04, 2011 6:47:44 am Andy Colson wrote:
> On 4/4/2011 6:12 AM, Howard Cole wrote:
> > I have recently transferred data from 8.4 to 9.0 and now only my
> > superuser has read access to the large objects.
> >
> > (The transfer was done using pg_dump version 9.0).
> >
> > The large objects have all transferred, the problem is just the
> > permissions, - but how do I set up the permissions for the large objects?

Is to late to redo the dump/restore? If not you may want to take a look at:
http://www.postgresql.org/docs/9.0/interactive/runtime-config-
compatible.html#GUC-LO-COMPAT-PRIVILEGES

> >
> > Thanks,
> >
> > Howard Cole
> > www.selestial.com
>
> I had the same problem. and there is no grant all... there is the new
> DO though. That's what I used, a simple DO expression to iterate and
> update the permissions.
>
> -Andy

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com