patatas backup acct's Avatar

patatas backup acct

@patatas.ca.bsky.social

This is my alt in case I break my PDS again. Main is @its.small.patatas.ca Craftsperson, artist, labourer in #HamOnt Luddite & tech tinkerer website: thedabbler.patatas.ca also: blundervalley.ca

40 Followers  |  22 Following  |  21 Posts  |  Joined: 07.05.2025  |  2.3667

Latest posts by patatas.ca on Bluesky

Tax the rich

20.05.2025 19:02 โ€” ๐Ÿ‘ 7    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0

Wow that CBC article just flat out did not bother to include any AI critics. I guess if there's no budget document guaranteeing their funding, they gotta shill for the government's attack on the federal workforce?

20.05.2025 17:03 โ€” ๐Ÿ‘ 1    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0

With Trudeau we were just fighting "reconciliation pipelines", now we're gonna be fighting "reconciliation datacentres" too while being being "consulted" by chatbots ๐Ÿ™ƒ bsky.app/profile/hali...

20.05.2025 16:26 โ€” ๐Ÿ‘ 16    ๐Ÿ” 3    ๐Ÿ’ฌ 1    ๐Ÿ“Œ 0
Post image

Whatโ€™s the difference between Amazon and the Post Office?

My letter carrier has never thrown parcels over a back alley fence because they donโ€™t know and canโ€™t find the address

But the Amazon driver has to rush his job so Bezos can maintain his fortune

Boycott Bezos
Support the post office

20.05.2025 01:19 โ€” ๐Ÿ‘ 55    ๐Ÿ” 19    ๐Ÿ’ฌ 3    ๐Ÿ“Œ 0

To be fair, it's probably hard mostly because I don't really know what I'm doing ๐Ÿ˜‚

08.05.2025 17:40 โ€” ๐Ÿ‘ 1    ๐Ÿ” 0    ๐Ÿ’ฌ 1    ๐Ÿ“Œ 0

and it *seems* like i can log in via the web app - but my feed is a spinning loading icon, and if i try viewing my profile I get 'internal server error'.

this feels so close to working. Is it a permissions/chown issue? What's the proper structure there?

08.05.2025 17:30 โ€” ๐Ÿ‘ 0    ๐Ÿ” 0    ๐Ÿ’ฌ 1    ๐Ÿ“Œ 0

OK so it looks like I may be even closer than I thought; the backup I took immediately after the failed update still has .gz versions of the main sqlite dbs, and these zipped files seem to contain data.

I unzipped them and i can once again see my acct with 'sudo pdsadmin account list'

1/

08.05.2025 17:30 โ€” ๐Ÿ‘ 0    ๐Ÿ” 0    ๐Ÿ’ฌ 1    ๐Ÿ“Œ 0

2/2

anything, but I'm asking on the discord if there's any risk of just deleting the empty dbs and unzipping these to replace them. I might just try it anyway and report back

08.05.2025 16:44 โ€” ๐Ÿ‘ 0    ๐Ÿ” 0    ๐Ÿ’ฌ 1    ๐Ÿ“Œ 0

so um, I'm about to try something: the backup I took right after the failed update has .gz backups of the sqlite databases ... so I cracked one open on my laptop. They seem to be intact?!

Wondering if you still have those or not. I unzipped the .gz on my local machine so as not to disturb

1/2

08.05.2025 16:44 โ€” ๐Ÿ‘ 1    ๐Ÿ” 0    ๐Ÿ’ฌ 2    ๐Ÿ“Œ 0

This store.sqlite database has my account preferences, a table w/ all the 'likes' etc ...

I also have .gz files of all the media blobs referenced in that db!

So it really seems like I have all the 'stuff', but I don't know enough to be sure - much less how to, say, rebuild the dbs or whatever

08.05.2025 15:58 โ€” ๐Ÿ‘ 0    ๐Ÿ” 0    ๐Ÿ’ฌ 1    ๐Ÿ“Œ 0

Thank you for the json file, that's fantastic!! โค๏ธ

> "It'd be surprising if it somehow deleted everything"

yeah that's kinda what my hunch is too. Like, on my server I can go to the ~/pds/service/data/actors/[folder]/[did]/ and there's the 'key.gz' and 'store.sqlite.gz' which both look to be intact

08.05.2025 15:58 โ€” ๐Ÿ‘ 2    ๐Ÿ” 0    ๐Ÿ’ฌ 1    ๐Ÿ“Œ 0

Thanks, yes - so, this is one of the guides I skimmed through, and here's an embarrassing question: when it says "call bsky.actor.getPreferences" or similar, how does one actually do that? ๐Ÿซฃ

Even if I knew though, it looks like the dbs got corrupted somehow. If only I had downloaded a 'CAR' file
:(

08.05.2025 14:39 โ€” ๐Ÿ‘ 4    ๐Ÿ” 0    ๐Ÿ’ฌ 1    ๐Ÿ“Œ 0

I'm guessing there's *probably* a way to migrate the DID to a new pds? But none of the guides cover this type of situation and/or are way over my head. Anyway I can't even see my old acct anymore using 'pdsadmin account list'.

The dangers of early adoption without the technical know-how, I guess!

08.05.2025 06:49 โ€” ๐Ÿ‘ 4    ๐Ÿ” 0    ๐Ÿ’ฌ 2    ๐Ÿ“Œ 0

And all of a sudden I could not refresh my feed.

I genuinely don't know what I did wrong!

I still have my pds' secrets, it looks like I have all the image file blobs. But I tried running SELECT * FROM [sqlite db table] on a few of the sqlite dbs and got nothing.

3/

08.05.2025 06:49 โ€” ๐Ÿ‘ 2    ๐Ÿ” 0    ๐Ÿ’ฌ 1    ๐Ÿ“Œ 0

the custom instructions I was using said to do a 'git pull' and then a 'pnpm install' command. Then I think 'systemctl daemon-reload' and restart the PDS service. There's a curl command that 'checks the PDS health' and returns the version number (which updated successfully).

2/

08.05.2025 06:49 โ€” ๐Ÿ‘ 3    ๐Ÿ” 0    ๐Ÿ’ฌ 1    ๐Ÿ“Œ 0

I mean, the thing is, I think it *might* be technically possible to save the account? But it's so beyond my level of know-how.

I was running it behind nginx alongside other stuff on my server, hadn't updated the pds in a few months, and stupidly didn't do a backup before the update either ๐Ÿซ 

1/

08.05.2025 06:49 โ€” ๐Ÿ‘ 3    ๐Ÿ” 0    ๐Ÿ’ฌ 1    ๐Ÿ“Œ 1

As many have been saying: Big Tech is in bed with Big Oil, determined to boil the planet.

"(AI) proponents have begun talking up the idea that AI and data centers can drive a surge in fossil fuel demand, prolonging the fossil fuel era โ€“ big techโ€™s earlier climate pledges notwithstanding."

08.05.2025 01:56 โ€” ๐Ÿ‘ 5    ๐Ÿ” 3    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0

new food idea: pizza pillow. itโ€™s basically a giant totinos pizza roll that you heat up in the oven and then use like a pillow except when you lay down to sleep your head is immediately submerged in piping hot cheese and tomato sauce. you have to do it within the first 30 min or so or it congeals

08.05.2025 02:17 โ€” ๐Ÿ‘ 128    ๐Ÿ” 14    ๐Ÿ’ฌ 5    ๐Ÿ“Œ 3

trump: "if you are going to get upset about not being able to afford things then you are a spoiled little crying baby girl"

07.05.2025 17:53 โ€” ๐Ÿ‘ 0    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Preview
24 Sussex officially becomes Brookfield Property OTTAWA - Brookfield Property Partners (TSX: BPYPP) a real estate company of Brookfield Asset Management Inc., proudly announced today their new acquisition of marquee Ottawa heritage property 24 Susse...

24 Sussex officially becomes Brookfield Property

07.05.2025 16:00 โ€” ๐Ÿ‘ 191    ๐Ÿ” 17    ๐Ÿ’ฌ 8    ๐Ÿ“Œ 2

Thanks! I hate computers about as much as I love them!

07.05.2025 14:29 โ€” ๐Ÿ‘ 2    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0

That is really nice of you to say, thank you ๐Ÿฅฒ

Anyway, we can lose it together, it'll be fun

07.05.2025 14:03 โ€” ๐Ÿ‘ 1    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0

Oof. That sucks :(

Yeah I was using nginx, so also an 'edge case' as far as the people in the PDS discord are concerned.

I dunno. I've been routinely breaking all kinds of fediverse server software, but don't recall ever having a failure this quick and catastrophic - this was different!

07.05.2025 04:39 โ€” ๐Ÿ‘ 1    ๐Ÿ” 0    ๐Ÿ’ฌ 1    ๐Ÿ“Œ 0

Yeah wait - I was fairly convinced the update messed up my db files too! But I had updated just before 0.4.135 - I got the .107 at first and something broke, I think with the pnpm install.

Urgghhh I know I should have done backups but still

07.05.2025 04:27 โ€” ๐Ÿ‘ 2    ๐Ÿ” 0    ๐Ÿ’ฌ 1    ๐Ÿ“Œ 0

Anyway I'll try to follow as many of the wonderful folks that I was following before, but feel free to boost this thread for reach :)

And if you know lots about #PDS stuff and want a technical challenge, feel free to hit me up lol

07.05.2025 04:12 โ€” ๐Ÿ‘ 3    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Post image

Hello friends (and enemies),

I broke my Bluesky PDS. This is my new account.

You can verify that it's actually me b/c I updated the bsky links on my blog: thedabbler.patatas.ca

For now, my old acct @its.small.patatas.ca is cached by the network, but I cannot access it.

#HamOnt #CdnPoli

1/

07.05.2025 04:12 โ€” ๐Ÿ‘ 8    ๐Ÿ” 3    ๐Ÿ’ฌ 5    ๐Ÿ“Œ 0

@patatas.ca is following 20 prominent accounts