I managed to get it to run. I checked in postgresql logs and it seems it was caused by trying to add into site. Apparently the site name cannot be more than 20 chars but this is mentioned nowhere in the documentation.
And when this happens, it causes this cascade of somehow trying to recreate the admin again and again, which is a red herring after all.
He y'all, same db0 as usual, posting from the FHMY instance. As we expect a big surge of pirates and lemmy is urging people to also utilize other instances, please consider accessing this community via FHMY: https://lemmy.fmhy.ml/c/piracy@lemmy.ml...
@dessalines can a user from a different instance be a mod in a community in lemmy.ml? Would be nice to have mod access from elsewhere in case lemmy.ml goes down.
With forewarning about a huge influx of users, you know Lemmy.ml will go down. Even if people go to https://join-lemmy.org/instances and disperse among the great instances there, the servers will go down....
Do you have the frontend a DB serving in the same VPS? If so it would be a great time to split them. Likewise if you DB is running in a VPS, you're likely suffering from significant steal from the hypervisor so you would benefit from switching to a dedicated box. My API calls saw a speedup of 10x just from switching from a VPS DB to a Dedicated Box DB.
I just checked OVH VPS offers and they're shit! Even at 70 Eur dedicated on hetzner, you would gain more than double those resources without steal. I would recommend switching your DB ASAP for immediate massive gains.
If you're wondering why you should listen to me, I built and run https://aihorde.net and are handling about 5K concurrent connections currently.
Even if you choose Hetzner, it won't even know it has anything to do with piracy because it will be just hosting the DB, and nobody will know where your DB is. That fear is overblown.
Likewise believe me a dedicated server is night and day from a VPS.
Hey y'all, In the past I had arranged that /f/piracy in raddle.me would be the fallback forum for /r/piracy, but I recently noticed that raddle.me has disabled new user registrations and that would be a problem in case we need it....
If I am going to redirect all the sizable community of reddit /r/piracy to a safe haven, I feel I have a responsibility to make sure that the destination is well run. The only way I can do that is to be a mod.
current lemmy status (lemmy.world)
People need to realize you can use alternatives
Fresh Installation fails because user email violates unique constraint
I am trying to install Lemmy, I am using a modified ansible role so that it deploys the DB on an external postgresql instead of a docker one....
Piracy on FHMY
He y'all, same db0 as usual, posting from the FHMY instance. As we expect a big surge of pirates and lemmy is urging people to also utilize other instances, please consider accessing this community via FHMY: https://lemmy.fmhy.ml/c/piracy@lemmy.ml...
How much money does Lemmy.ml need to temporarily boost their servers?
With forewarning about a huge influx of users, you know Lemmy.ml will go down. Even if people go to https://join-lemmy.org/instances and disperse among the great instances there, the servers will go down....
Lemmy announced as the primary fallback of /r/piracy (www.reddit.com)
I'm the top mod of /r/piracy in reddit. Can I get a mod position? (www.reddit.com)
Hey y'all, In the past I had arranged that /f/piracy in raddle.me would be the fallback forum for /r/piracy, but I recently noticed that raddle.me has disabled new user registrations and that would be a problem in case we need it....