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"
DETAIL: Key (oid)=(21709) already exists.
pg_restore: *** aborted because of error
Thanks
Есть вопросы? Напишите нам!
Соглашаюсь с условиями обработки персональных данных
✖
By continuing to browse this website, you agree to the use of cookies. Go to Privacy Policy.