RoundSparrow, 9 months ago

Only way to solve this (imho) is to reinstall Lemmy BUT use another subdomain.

I wold agree that this is worth considering as an approach to not clash identity and get into custom SQL or Rust programming. But there isn’t even really a procedure in place to decommission the old lemmy entity… so another damned if you do, damned if you don’t in 0.18.4 era.

I’m a little surprised that the federation private key/public key signing doesn’t get upset about all new keys appearing on the same domain name. I’ve tried to get details of exactly how a server joins the Lemmy network and gets discovered over on !lemmyfederation but haven’t gotten any actually discussion on the details.

What do you think? Will this work?

I’ve seen people nuke and start-over their database from empty several times while having problems setting up NGinx and Docker… or whatever part.

I’m glancing at the list of SEQUENCE in Lemmy…

<span style="color:#323232;">CREATE SEQUENCE public.admin_purge_comment_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.admin_purge_community_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.admin_purge_person_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.admin_purge_post_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.captcha_answer_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.comment_aggregates_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.comment_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.comment_like_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.comment_reply_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.comment_report_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.comment_saved_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.community_aggregates_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.community_block_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.community_follower_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.community_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.community_language_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.community_moderator_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.community_person_ban_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.custom_emoji_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.custom_emoji_keyword_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.email_verification_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.federation_allowlist_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.federation_blocklist_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.instance_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.language_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.local_site_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.local_site_rate_limit_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.local_user_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.local_user_language_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.mod_add_community_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.mod_add_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.mod_ban_from_community_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.mod_ban_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.mod_hide_community_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.mod_lock_post_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.mod_remove_comment_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.mod_remove_community_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.mod_remove_post_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.mod_sticky_post_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.mod_transfer_community_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.password_reset_request_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.person_aggregates_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.person_ban_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.person_block_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.person_follower_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.person_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.person_mention_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.person_post_aggregates_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.post_aggregates_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.post_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.post_like_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.post_read_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.post_report_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.post_saved_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.private_message_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.private_message_report_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.received_activity_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.registration_application_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.secret_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.sent_activity_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.site_aggregates_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.site_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.site_language_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE public.tagline_id_seq
</span><span style="color:#323232;">CREATE SEQUENCE utils.deps_saved_ddl_id_seq
</span><span style="color:#323232;">
</span>