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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
