Re: Large object and pg_restore problem

Gregory Gimenez <gimenez(at)ibdm(dot)univ-mrs(dot)fr> writes:
> So, we try to get rid of this particular image by first deleting the
> picture row with this corresponding oid and then making a vaccumdb +
> reindex to delete the reference in the pg_largeoject but still the
> largeobject is there.

Well, yeah, you didn't delete the large object. Since you're restoring
the whole DB, why don't you just drop and recreate the database?

If you really don't want to do that, contrib/vacuumlo might help you, or
in the longer term consider using the contrib/lo datatype instead of
bare OIDs for referencing large objects.

BTW, using -i with pg_dump or pg_restore on a routine basis is
extremely bad practice. It will bite you eventually. If pg_dump
doesn't want to play with your server version, there is probably
a good reason, and you should not override it without knowing
exactly what you are doing and why it's safe for the particular
combination of versions.

regards, tom lane