Linode's switch to hourly is murdering the Mastodon. Before abandon all hope, any ideas here?

It looked like the screenshot below worked, but it was followed by this trying to migrate:

mastodon@ecosteaderhost:~/live$ RAILS_ENV=production bundle exec rails db:migrate
rails aborted!
ActiveRecord::NoDatabaseError: FATAL: role "mastodon" does not exist

@ecosteader Well, what I see in the screenshot is a pg_restore and when running "RAILS_ENV=production bundle exec rails db:migrate" it shouldn't do a pg_restore.

So, I don't know. Never came across a similar situation.

Linode shut down and disabled postgres when it downgraded my server, so I had to reinstall postgres. This apparently destroys EVERYTHING on your production postgres setup.

Yes, I have backups, which is why I restored them as shown by the screenshot. My question is where does mastodon as a "role" get defined? That should already be part of what I backed up.

@ecosteader why not just host with @mastohost ? We have hosted with them from the start and not had a single issue. Nothing at all. Nada.

It frees you up to concentrate on the community, instead of sysadmin. Plus, Hugo is a genius! 😁

@kev One does not "choose" to become a sysadmin. It happened this way for a reason, I presume, because being honest and forthright makes you a target for the bad guys. I couldn't go the CPA route because I know finance people and tech too well. Silicon Valley's "new" crowd has no ethics, and doesn't care for truth.

To have your messages buried on Reddit, removed from Google search results, suffocated by Facebook, banned from most public domains, you learn how to recover from being DDOS'd.

@ecosteader I disagree. I think people always have a choice. I assume your instance doesn’t have many members? If so, the cost to have Masto host it will likely be similar to what you’re paying Linode, just with less headaches.

What ever you decide, I hope it works out for you. 👍

@kev Mostly what I meant was the "job" sometimes chooses its people to handle ... let's call them "delicate but powerful things". It's not always the other way around. 🌎 👩‍💻 🐑 🌻 🌱 🕵️‍♀️

@mastohost was just curious if you'd had to restore from backups before; as a host I assumed you would have! 😁

Sign in to participate in the conversation

Fosstodon is an English speaking Mastodon instance that is open to anyone who is interested in technology; particularly free & open source software.