See here for my blog post, hopefully you can make something out of this:

https://pen.blahaj.zone/supakaity/installing-a-patroni-cluster-on-ubuntu

Hopefully fixed now. (see https://lemmy.blahaj.zone/comment/18602435)

For those having issues (intermittently), it was likely due to some rate limiting problem I had with unwrapping forwarded IPs from some edge nodes.

Fixed now, so you should be good from now on, also for those in South America who had to transit all the way up to Canada, you now have an edge node in São Paulo that will be a little closer to home, and not have to squeeze through Miami transit.

I’ll get together my scraps of notes and text files and put together something for you tomorrow. I’ve been meaning to setup a tech blog for a while now and this sounds like a good reason to spin it up. :D

Ahh, that’s just Figma (a FigJam to be precise).

If you can let me know what region you’re coming from, that will help (country if possible and you’re comfortable with that, and in a DM if you prefer)

If you can let me know what region you’re coming from, that will help (country if possible and you’re comfortable with that, and in a DM if you prefer)

At one point I would have said the same thing… but these days my spare time is so low and ROI on creating and debugging and replaying over and over again until it works flawlessly then maintaining that when I next have to do it and they have changed the process (again)…

I find as I get older I lack the enthusiasm for perfecting these things unless it’s truly going to make my life better, it’s needed for a time critical or replicable/repeatable install or it needs to be run by complete idiots clients.

No, patroni is literally like a dozen commands to run for a new server, and I have those in a text file. It takes me maybe 10 minutes and a few hours of waiting for replication to start up/sync if I need to create a new one. I’m up to our 6th db server through incremental upgrades now (the current secondary used to be the primary, then a new server replaced its primacy).

You asked for it, so here it is:

https://lemmyverse.link/lemmy.blahaj.zone/post/36690717

I truly feel for all of you in the US at the moment. However in terms of hosting things, I’m staying right away from any place where the US government can come and seize, monitor or tap literally with zero effort or consequence.

So no, A US edge node is not possible.

So I’m lying in bed and thought I’d ask Ada what she thought about it.

@ada@lemmy.blahaj.zone said that “I think the rise in popularity of the Ada language on Ada Lovelace day is ADAmn fine thing”

I found that the Caddy handler above blocked many third party clients and even Tesseract.

So instead I’m using this CEL expression to return a 444 error on match of the unscoped old-sorted 50 per-page comments past page 99:

@block_comment_spam expression <<CEL
    {http.request.uri.path} == "/api/v3/comment/list" &&
    {http.request.uri.query.limit} == "50" &&
    {http.request.uri.query.sort} == "Old" &&
    int({http.request.uri.query.page}) > 99 &&
    {http.request.uri.query.post_id} == ""
CEL

handle @block_comment_spam {
    respond 444
}

I’ll check it out. See what this alpha API thing is all about.

@ada@lemmy.blahaj.zone does a fantastic job of moderating, and it constantly amazes me that she manages to keep her cool (and calms me down when I get riled up too!).

Thanks for being the moderator to my sysadmin, babe. I couldn’t do it without you.

Ada, by far, has the most moderation experience and level head of the both of us.

If I was moderating this place it’d be a barren wasteland with salted and scorched earth as far as the eyes can see and a list of rules as long as your arm which keeps getting longer every time you look as I try to keep up with the rules lawyers.

When we first setup Blåhaj Zone with Ada, we discussed exactly this scenario and Ada said that you’ll never create a set of rules that are comprehensive enough to defeat those that are intent on being horrible human beings and trying to make a safe space for queer and gender diverse people unsafe. And instead of keeping the space safe you’ll spend all your time and effort refining and defending the intricacies of the rules.

Instead of doing that, we want a safe space, so the guiding principle is don’t make it unsafe.

Obviously some people need more clarification on what safety means to us, but really if you need more than what we have provided to “get it”, then you are the kind of person who would make it unsafe just by being present.

Most decent human beings can grok “be kind and respect each other” as a set square.

There’s only two (really one) admins

Ooof, that’s a bit unfair don’t you think?

While it is true that I do the majority of the work keeping our servers running behind the scenes for you all, it’s still a bit rough to say Ada doesn’t pull her own weight! 😊

Poor li’l blighter got attacked by a bin chick’n and was limping away last we saw em… after goin’ the bin juice drinkin’ irrit of course.

Apparently I was wrong, it’s decided it’s done and working again now.

The pict-rs upgrade is ongoing.

From what I can tell it’ll be about another 5 hours. I’m going to have to go to bed and check on it in the morning.

Unfortunately the stock-standard lemmy-ui doesn’t like it that pict-rs is migrating to a new version of database and not serving images, so it’s stubbornly just not working at all.