title: pg_restore for 9.4 fails with error 'could not execute query'
body: <p>The PostgreSQL version I am trying to restore is 9.4.10. I backed up a database from the same version. The command I am using for restore is:</p>
  <pre><code>/opt/PostgreSQL/9.4/bin/pg_restore -U postgres --port=5432 -v --dbname=mydb &lt; /backups/309646/WAL/pipe_309646
  </code></pre>
  <p>The error I get is:</p>
  <pre><code>pg_restore: executing BLOB 71197
  pg_restore: [archiver (db)] Error from TOC entry 3822; 2613 71197 BLOB 71197 user
  pg_restore: [archiver (db)] could not execute query: ERROR:  duplicate key value violates unique constraint &quot;pg_largeobject_metadata_oid_index&quot;
  DETAIL:  Key (oid)=(71197) already exists.
      Command was: SELECT pg_catalog.lo_create('71197');
  </code></pre>
  <p>This is repeated in the pg errors some 112 times. I need to restore to the same database. Here is the command I used for dumping:</p>
  <pre><code>/opt/PostgreSQL/9.4/bin/pg_dump&quot; -U postgres -Fc -b  --port=5432  'mydb' -t public.users &gt; /backups/309646/WAL/pipe_309646
  </code></pre>
  <p>Any indication as to why this is happening? How can I mitigate this error?</p>