The account ID will be occupied by deleted/ suspended account?

Were IDs be occupied by these accounts forever? Can I just remove these account records in PostgreSQL?

Assuming by “account ID” you mean username, then yes, usernames of suspended accounts are kept forever, mostly to avoid issues with remote instances possibly confusing the old and new accounts, and to keep a trace of reports etc.

The cleanest way to free up those usernames may be something like typing the following in RAILS_ENV=production bundle exec rails c:

Account.where(domain: nil, username: ['suspended_user1', 'suspended_user2']).destroy_all

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.