Hi Birgit,
Am 10.07.25 um 10:36 schrieb 'Birgit Ducarroz' via bareos-users:
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.
this indeed looks like a problem with the database itself.
AFAICT this could only happen if there are duplicates in that primary
key column - which would indicate a corrupted database.
However, the fileid column isn't really critical unless you use BVFS.
What you could try if you still have the original database is to
pg_dump --schema-only
and
pg_dump --data-only
This way you get seperate dumps for the database structure and the data.
When you then restore the schema first, you can drop the primary key
before restoring the data.
In the end you will have the same corruption in your restored database
that you had in the original one.
I can play around with the sql file, no problem of data loss since I
have backuped my installaton. So every suggestion is appreciated.
You can just remove the line adding the primary key. Most of Bareos will
work fine without that primary key, even though BVFS and a few other
things will not like it.
My question is, how can I clean my database correctly from these
duplicates and finally import my dump into the new psql 16?
That's a question for the PostgreSQL mailing list, as your PostgreSQL 12
database should not have these duplicates in the first place.
Hope that helps!
Best Regards,
Andreas
--
Andreas Rogge [email protected]
Bareos GmbH & Co. KG Phone: +49 221-630693-86
http://www.bareos.com
Sitz der Gesellschaft: Köln | Amtsgericht Köln: HRA 29646
Komplementär: Bareos Verwaltungs-GmbH
Geschäftsführer: Stephan Dühr, Jörg Steffens, Philipp Storz
--
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/1d383b20-6ca7-4e91-9533-2d67028a17dc%40bareos.com.
