Neal Wilson ✅ @neal@social.typica.us

@agudbrandson Okay, so on a Mac the installer usually doesn't put the pg* programs in $PATH, but under /Library/PostgreSQL/<version number>/bin where <version number> is replaced with the version of PostgreSQL you're using. If you open Terminal, you can:

cd /Library/PostgreSQL
ls

to see which version is there.

cd

to get back into your home directory and then /Library/PostgreSQL/x.y/bin/pg_dump -h localhost -U username -f backup.db db_name

Replacement instructions in the following reply.

@piggo Yes. I've written things basically architected like that. Sometimes it's kind of nasty because of bugs a compiler would have just failed on/worse debugger support, but if the native core is well thought out, feature development goes so much faster and you can often get customizations/fixes out to people without a need for changes in the core.

@cardassianvole Maybe they don't know. Male politicians in particular have repeatedly demonstrated a failure to grasp the basic biology involved.

Yesterday I was looking at new mug designs and mercats (like mermaids except with a cat top) are apparently the hot new thing. I'm guessing these were designed by a Macross fan. Personally, I'm looking forward to getting the octopus mugs.

@agudbrandson Sure. Let me know if you need help.

So in a completely bizarre turn I've been asked if I want to take over leadership of the committee I resigned from. I'll be asking some people for advice and getting some more information to help me make that decision.

@agudbrandson Do you know how to use pg_dump? If so, and if you find that plan agreeable, you can upload the data at https://atelier.wilsonscoffee.com/s/e9fHwr99SDgcLrB

If not, let me know and I'll walk you through it.

@agudbrandson Not the database software, the data in the database. Something is going wrong there. I think what might be the fastest way to get this fixed would be if you could create a backup of your database with pg_dump and I'll be able to look at that and see if I can replicate the problem locally, figure out what's happening there, and see if it's repairable. If so, I'd fix the data, export it so you could reload that, and then delete my copy once you've succeeded.

The cat is bored, but it's 1:19AM.

PeerTube embeds no longer have rainbows

My sister is having dental work done tomorrow so I'll be taking over more of the tasks she normally takes care of for a few days while she recovers from that.

I'm not exactly sure where the typo was (once I knew which section it must have been in I just copy/pasted from the example instead of trying to hunt down the difference), but it resulted in 404s on webseeds (downloads still worked).

https://video.typica.us/ is back up and running with local videos working correctly. Bad nginx modification during the upgrade to PeerTube 1.2. I was stuck in a meeting for too long before I was able to fix that but everything should be good now.

local videos on video.typica.us temporarily down. will try to get that up soon.

Cat is wet. I think she decided to drag herself through her water dish.

Traffic design there is bad enough when everybody is following the rules.

Had to double back and reroute on the way to work today. There was a convoy of extremely slow moving public works trucks going the wrong way on 1 way streets blocking my route.

One of the great things about my eclectic professional experience is that lots of people talk to me. I can't share most of the stories I hear (I'll anonymize and/or wait until the company involved gets bought out/goes out of business or until the people involved are no longer in the business) but I do enjoy hearing them.

Sadly, nobody locally wants to talk shop. I might "steal their secrets." (I totally steal ideas from others but local competitors don't have secrets worth stealing)