Hi, I have an old bareos.sql dump made with postgresql 12. It is very important, it contains our archives on tape. I try to import it to a new postgresql 16, but I get
ERROR: could not create unique index "file_pkey" DETAIL: Key (fileid)=(29987396) is duplicated. I investigated a lot of time to delete all the duplicates - It seems that there are thousands, I don't know why. But when I try then to import the cleaned database, I see no jobs. When I start my old bareos version with the old database, all works fine: i can backup, restore etc., so it seems that all these duplicates do not interfere anywhere. I can play around with the sql file, no problem of data loss since I have backuped my installaton. So every suggestion is appreciated. My question is, how can I clean my database correctly from these duplicates and finally import my dump into the new psql 16? In case it is not possible I have a plan B, but maybe someone can help me anyway. Thank you so lot in advance. Birgit -- You received this message because you are subscribed to the Google Groups "bareos-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion visit https://groups.google.com/d/msgid/bareos-users/9e7061da-eb7f-4e40-99bb-373e9649faefn%40googlegroups.com.
