isthat I havea number ofpostgresclusterwe wantto consolidate intoa single cluster.Everyclusterhas adatabase withdifferentschemasnameseachtherefore inprinciplecouldcreatea single databasewhere they couldliveallschemasand should have noproblem, we generate adump and SQLfile, we begin to restorefilesand at firstannoyed with thefirst and secondbutthe third and fourthat the timeyou are restoringlobthe following error:
pg_restore: *** aborted because of error
pg_restore: [archiver] could not create large object 21709: ERROR: duplicate key value violates unique constraint "pg_largeobject_metadata_oid_index"