# I am the Watcher. I am your guide through this vast new twtiverse.
#
# Usage:
# https://watcher.sour.is/api/plain/users View list of users and latest twt date.
# https://watcher.sour.is/api/plain/twt View all twts.
# https://watcher.sour.is/api/plain/mentions?uri=:uri View all mentions for uri.
# https://watcher.sour.is/api/plain/conv/:hash View all twts for a conversation subject.
#
# Options:
# uri Filter to show a specific users twts.
# offset Start index for quey.
# limit Count of items to return (going back in time).
#
# twt range = 1 12
# self = https://watcher.sour.is/conv/vyjlb3q
Familiarising myself with pgbackrest. Need to make sure this extended service outage isn't repeated.
@jlj who not just simply:
pg_dump -F t DB_NAME > /backups/DB_NAME
Of course, using timestamps or something similar in names, and using *find*, or similar, to keep the backups under control.
@bender It's a valid question. I just didn't do it regularly? I was confused by the different formats? I read conflicting advice about whether things could still be running? Databases, writ large, are a bit of a boogeyman for me? End of the day, so far, this seems to be just enough validation / certification plus automation to get me over the line; _seems_ to be. We shall see.
Tell you what: this demo is _just_ my speed; exactly what I need to get a feel for it, and, more importantly, to build up my confidence.
Anyway, that's enough for tonight. Daughter's still poorly, and'll be up afore the hour's done, I'm sure. 😪
Same, @jlj, hope she gets well soon!
@bender Thanks, both. She was still coughing a lot last night, but she's been full o' beans today; already been out to a friend's party this morning, and showing no signs of slowing down this afternoon. Kids, eh? ;)
Latest attempt is using pg_dumpall; that and the restore will be done using 13.9 binaries (for different architectures, of course). Can't say I'm feeling particularly optimistic...
Well, _I'll be_. Didn't that just sort it. Amazing. matrix.nfld.uk rides again! With a much whizzier, if remote, database. Time to start building back the rest of these database backed services then, eh, @bender? ;)
@jlj congratulations! Woot! That was some perseverance there! :-)
@bender Thanks! :) Learned loads along the way as well, to where I was able to recover another database dump (for a different service) just by changing the locale in the dump file and creating the associated user ahead of the restore.