Egregoros · Phoenix Framework

Feacher? I hardly know 'er

@prettygood@socially.drinkingatmy.computer

Uncle PG, your local alcoholic anime LARPing night owl text-walling love-and-hope poster.

The resident old man and self-appointed conscience of "dark fedi". Bona-fide certified wifeguy.

Queer-friendly enough to be accused of being a chaser. Great Value brand generic socialist.

Linux cis-admin/DBA and PHP dev, self-hosting fanatic, Gentoo adherent, general freetard, and all-around chatterbox. Ask me about my USE flags!

Posts always underrated, opinions usually overstated, liver often saturated, instance broadly federated.

Greatest hits: @prettybad

---

"The wizard of ethanol" - Monkey

"what the fuck why is literally gandalf posting anime girls on the fediverse" - coolbeans

"are you Hunter S. Thompson" - nyx

"one of the good ones" - monkey & mildred

"You don’t have to make life to make life better" - sapphire

"cease living" - Grace

"too friendly" - pwm

"conspiracy vibes" - writeout.ink

"Far right" - incorrect, I'm just the wrong flavor of leftist

"ywnbaw" - correct

"you have a problem" - thanks, very helpful

271

Posts

1095

Followers

1099

Following

Posts

Latest notes

Feacher? I hardly know 'er

@prettygood@socially.drinkingatmy.computer remote

[CW]

Content warning

Stupid, lewd

Show

Columbussy

Feacher? I hardly know 'er

@prettygood@socially.drinkingatmy.computer remote

@Li

Feacher? I hardly know 'er

@prettygood@socially.drinkingatmy.computer remote

>post innocent photograph of something funny
>get doxed by tiny background detail
>pic related

Some day I will learn my lesson.

Feacher? I hardly know 'er

@prettygood@socially.drinkingatmy.computer remote

"Now for more songs you probably tried to download on Napster" hey fuck you man

Feacher? I hardly know 'er

@prettygood@socially.drinkingatmy.computer remote

😳

Feacher? I hardly know 'er

@prettygood@socially.drinkingatmy.computer remote

@phnt @sampler @Suiseiseki I mean you can, in the same way you can exceed the speed limit.

Feacher? I hardly know 'er

@prettygood@socially.drinkingatmy.computer remote

@phnt @rez @vekkq >I don't see a reason for that.

Unless I'm completely mistaken, pleroma has to be running to use the prune_objects directive, no? So given the I/O limitations of a VPS, is it better to run "pleroma_ctl database prune_objects --keep-non-public --prune-orphaned-activities --keep-threads" while pleroma is running, or shut it down and do manual delete queries?

Feacher? I hardly know 'er

@prettygood@socially.drinkingatmy.computer remote

26w

People with a public transport fetish be like "yeah this is where I get off"

Feacher? I hardly know 'er

@prettygood@socially.drinkingatmy.computer remote

@phnt @rez @vekkq well, for the prune operation I was using the pleroma_ctl prune_objects routine, which yes I understand is merely just deletes but do you have handy a query that can replace it directly? I do shut it down for the vacuum as part of my own routine.

Feacher? I hardly know 'er

@prettygood@socially.drinkingatmy.computer remote

@phnt @rez @vekkq never had any explicit errors, which makes me think there wasn't any corruption or anything. pg_amcheck didn't give any complaints either.

I changed my retention days back to 90 to try to keep a lid on the overall DB size (too cheap to pay for more disk...) but getting interrupted put it in a bad state I guess. We'll find out next Monday

Feacher? I hardly know 'er

@prettygood@socially.drinkingatmy.computer remote

Oh, and I also figured out why Ironfox quit working (it was DNS this time).

Stupid app maintainers enabled DNS over https by default, overriding current settings, in an update, without any notification or prompts. I MITM DNS on my network, with pihole, so I block DNS over https because I'm more concerned by ads tracking me than I am about my ISP seeing me browsing hentai.

Is this what they call a Free Software Award?

Feacher? I hardly know 'er

@prettygood@socially.drinkingatmy.computer remote

Chat I think I fixed it.

Feacher? I hardly know 'er

@prettygood@socially.drinkingatmy.computer remote

@rez @vekkq database problems. Monday, pleroma crashed during a prune operation, which normally isn't a big deal but it was behaving badly (weird timeline artifacts, etc.) so I shut it down for a day or so to reindex the database, retool the script, update postgres, vacuum, etc.

Feacher? I hardly know 'er

@prettygood@socially.drinkingatmy.computer remote

@sendpaws @maid I wanna be clear I'm actively rooting against ARM here, the company not the architecture. Apple's chips are alright though.

Feacher? I hardly know 'er

@prettygood@socially.drinkingatmy.computer remote

There are two pounds of copper and ~3g of gold in every Flock camera. Just thought that was interesting

Feacher? I hardly know 'er

@prettygood@socially.drinkingatmy.computer remote

@N33R

Feacher? I hardly know 'er

@prettygood@socially.drinkingatmy.computer remote

@sun I'm not a luddite but lasik scares the shit out of me. Like if that laser misses suddenly you're hammerfucked. I just spend more on good glasses instead.

Feacher? I hardly know 'er

@prettygood@socially.drinkingatmy.computer remote

@sun you mean like LASIK or something else

Feacher? I hardly know 'er

@prettygood@socially.drinkingatmy.computer remote

Open the fuckin' source code, you crazy bastards, or you'll be living in Github - JUST WATCH! Praise be to Stallman. Uncle PG

Feacher? I hardly know 'er

@prettygood@socially.drinkingatmy.computer remote

@SuperDicq

[NSFW]

Sensitive media

Hidden by default.