Re: Permissions on large objects - db backup and restore

On 4/3/2013 5:57 PM, Tom Lane wrote:
> $ pg_restore -? ... -O, --no-owner skip restoration of object
> ownership ... So there you have it. pg_restore just restored all the
> objects (blobs and otherwise) as owned by the user running it. I
> should think you'd have had issues with other things besides the blobs
> by now. regards, tom lane

Thanks you! Unsure why that -O was being used since when I check
version control, it's been in there since PG 8.3 days. I hadn't checked
on its meaning and just assumed it was something to do with OIDs like
the pg_dump flags. No doubt it solved something back then since TABLE
GRANTS could be run after a restore since before 9.0 the loids had no
permission issue to deal with.

Thanks again, Tom! Best regards, David