Das Problem ist behoben. :) Einzig Bilddatein zwischen 9.5 und heute konnten nicht wiederhergestellt werden.

fixed: lemmy=# SELECT actor_id FROM community_aggregates_fast WHERE id = 2; actor_id

https://lemmy.161.social/c/main

but lemmy=# SELECT actor_id FROM community_aggregates_fast; actor_id

https://lemmy.161.social/c/recherche https://lemmy.ml/c/cello https://lemmy.161.social/c/meta https://lemmy.161.social/c/berlin https://lemmy.ml/c/diy https://lemmy.ml/c/security https://lemmy.ml/c/bonsai … https://my_domain/c/main

but I recall that I missed on creation of lemmy to enter the correct domain. I changed it later also in the DB manually

here is a part of the DB

lemmy=# SELECT actor_id FROM community; actor_id

https://lemmy.161.social/c/meta https://lemmy.161.social/c/main https://lemmy.161.social/c/tech https://lemmy.161.social/c/bildung https://lemmy.161.social/c/heisse_maimais https://lemmy.161.social/c/itsec https://lemmy.161.social/c/berlin https://lemmy.161.social/c/recherche https://lemmy.161.social/c/baden_wuerttemberg https://lemmy.161.social/c/hltsml https://lemmy.161.social/c/europa https://lemmy.161.social/c/niedersachsen https://lemmy.161.social/c/glossar https://lemmy.161.social/c/aktionstheorie https://lemmy.161.social/c/filmeabend https://lemmy.161.social/c/hamburg