David Wall <d.wall@xxxxxxxxxxxx> writes: > On 4/3/2013 3:14 PM, Tom Lane wrote: >> A 9.2->9.2 dump and restore certainly should preserve large object >> ownership (and permissions, if you've set any). In a quick check I do >> see "ALTER LARGE OBJECT nnn OWNER TO ..." commands in pg_dump's output >> for such a case. Are you sure this is really the "same" issue? Are you >> doing something strange like using pg_dump's --no-owner option? > We used this to backup on server1 (9.2.2): > pg_dump --format=c --oids /dbname/ > And we restored on server2 (9.2.3) with: > pg_restore -v -O -d /dbname/ $ 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
