Changing your Mastodon "joined" date with PostgreSQL

Thanks to Micah F Lee for the tip!

su mastodon

psql -d mastodon_production

mastodon_production=> UPDATE accounts SET created_at='1993-03-10 00:00:00' WHERE username='yawnbox';

exit

Please note two things:

  1. The change is immediate. No need to restart postgresql.
  2. Set the day (“10” in the above example) ahead by one day. So you if you want March 09, 1993, set it to 1993-03-10.

yawnbox

copyleft 2004-2022