patatas backup acct
@patatas.ca
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
Craftsperson, artist, labourer in #HamOnt
Luddite & tech tinkerer
website:
thedabbler.patatas.ca
also:
blundervalley.ca
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?
May 20, 2025 at 5:03 PM
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?
Reposted by patatas backup acct
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...
May 20, 2025 at 4:26 PM
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...
To be fair, it's probably hard mostly because I don't really know what I'm doing 😂
May 8, 2025 at 5:40 PM
To be fair, it's probably hard mostly because I don't really know what I'm doing 😂
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?
this feels so close to working. Is it a permissions/chown issue? What's the proper structure there?
May 8, 2025 at 5:30 PM
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?
this feels so close to working. Is it a permissions/chown issue? What's the proper structure there?
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/
I unzipped them and i can once again see my acct with 'sudo pdsadmin account list'
1/
May 8, 2025 at 5:30 PM
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/
I unzipped them and i can once again see my acct with 'sudo pdsadmin account list'
1/
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
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
May 8, 2025 at 4:44 PM
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
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
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
Wondering if you still have those or not. I unzipped the .gz on my local machine so as not to disturb
1/2
May 8, 2025 at 4:44 PM
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
Wondering if you still have those or not. I unzipped the .gz on my local machine so as not to disturb
1/2
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
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
May 8, 2025 at 3:58 PM
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
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
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
> "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
May 8, 2025 at 3:58 PM
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
> "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
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
:(
Even if I knew though, it looks like the dbs got corrupted somehow. If only I had downloaded a 'CAR' file
:(
May 8, 2025 at 2:40 PM
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
:(
Even if I knew though, it looks like the dbs got corrupted somehow. If only I had downloaded a 'CAR' file
:(
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!
The dangers of early adoption without the technical know-how, I guess!
May 8, 2025 at 6:49 AM
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!
The dangers of early adoption without the technical know-how, I guess!
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/
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/
May 8, 2025 at 6:49 AM
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/
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/
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/
2/
May 8, 2025 at 6:49 AM
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/
2/
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/
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/
May 8, 2025 at 6:49 AM
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/
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/
Thanks! I hate computers about as much as I love them!
May 7, 2025 at 2:29 PM
Thanks! I hate computers about as much as I love them!
That is really nice of you to say, thank you 🥲
Anyway, we can lose it together, it'll be fun
Anyway, we can lose it together, it'll be fun
May 7, 2025 at 2:03 PM
That is really nice of you to say, thank you 🥲
Anyway, we can lose it together, it'll be fun
Anyway, we can lose it together, it'll be fun
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!
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!
May 7, 2025 at 4:39 AM
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!
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!
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
Urgghhh I know I should have done backups but still
May 7, 2025 at 4:27 AM
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
Urgghhh I know I should have done backups but still
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
And if you know lots about #PDS stuff and want a technical challenge, feel free to hit me up lol
May 7, 2025 at 4:12 AM
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
And if you know lots about #PDS stuff and want a technical challenge, feel free to hit me up lol