diff options
| -rw-r--r-- | .times | 38 | ||||
| -rw-r--r-- | served/bits/ramen-bowl.html | 5 | ||||
| -rw-r--r-- | served/bits/sillygifs/sillygifs.html | 3 | ||||
| -rw-r--r-- | served/bits/smoems.html | 5 | ||||
| -rw-r--r-- | served/bits/touching-grass/touching-grass.html | 10 | ||||
| -rw-r--r-- | served/words/akkoma-postgres-migration.html | 26 |
6 files changed, 45 insertions, 42 deletions
diff --git a/.times b/.times index 4367377..72b32e2 100644 --- a/.times +++ b/.times @@ -1,28 +1,28 @@ ,1710325922,1710325922,1711506795 .times-ignore,1708577778,1708577778,1711506775 -.times,1710326012,1713001756,1711506775 +.times,1710326012,1713003601,1713001756 readme.md,1708577778,1708577778,1711506775 -.gitignore,1710325679,1710325679,1711506775 +.gitignore,1710325679,1713003359,1713003428 updateTimes.sh,1708577778,1708577778,1713001756 support,1709368202,1709368202,1711506795 support/keeplinks,1708577778,1708577778,1711506795 support/.times,1708577778,1708577778,1711506794 -support/atom.conf,1710984963,1713000406,1713000409 -support/atom.xml,1709463716,1709463716,1711506794 +support/atom.conf,1710984963,1713001913,1713003428 +support/atom.xml,1709463716,1713003381,1713003428 support/redirects,1708577778,1708577778,1711506795 templates,1709378595,1709378595,1711506795 -templates/post.html,1709194328,1712922787,1712922787 +templates/post.html,1709194328,1712922787,1713003428 templates/base.html,1709459819,1709459819,1711506794 templates/minimal.html,1708593919,1708593919,1711506794 served,1710488994,1712950507,1712950508 served/home.html,1709310292,1709310292,1711506775 served/.DS_Store,1708577778,1708577778,1711506775 served/valid-atom.png,1709295369,1709295369,1711580013 -served/atom.xml,1712950507,1712999579,1713001756 +served/atom.xml,1712950507,1713001925,1713002191 served/words,1710725237,1712999283,1712999312 -served/words/words.html,1709201376,1712921946,1713001493 -served/words/akkoma-postgres-migration.html,1709458342,1712999241,1712999252 -served/words/writing.css,1709378432,1712925255,1712925265 +served/words/words.html,1709201376,1712921946,1713003428 +served/words/akkoma-postgres-migration.html,1709458342,1712999241,1713003538 +served/words/writing.css,1709378432,1712925255,1713003428 served/words/words.css,1712487345,1713001531,1713001533 served/words/statement-of-intent.html,1710331092,1710331092,1711506794 served/words/weeknotes,1710725592,1713000660,1713000739 @@ -30,21 +30,21 @@ served/words/weeknotes/weeknotes-14.html,1710726062,1712999515,1712999515 served/words/weeknotes/weeknotes-15.html,1713000660,1713001121,1713001121 served/styles,1709378278,1709378278,1711506795 served/styles/home.css,1709310339,1709310339,1711506778 -served/styles/post.css,1709309810,1713001421,1713001433 -served/styles/common.css,1709310038,1713001364,1713001375 +served/styles/post.css,1709309810,1713001421,1713003428 +served/styles/common.css,1709310038,1713001364,1713003428 served/bits,1710067313,1713001696,1713001699 -served/bits/bits.css,1709309896,1713001560,1713001571 +served/bits/bits.css,1709309896,1713001560,1713003428 served/bits/poem.css,1709308779,1709308779,1711506776 -served/bits/smoems.html,1709461948,1712999085,1712999090 -served/bits/atom.xml,1712950507,1712999579,1713001756 +served/bits/smoems.html,1709461948,1712999085,1713003428 +served/bits/atom.xml,1712950507,1713001925,1713002191 served/bits/bits.html,1709310176,1709310176,1711506775 -served/bits/ramen-bowl.html,1709458561,1712999034,1712999039 +served/bits/ramen-bowl.html,1709458561,1712999034,1713003428 served/bits/touching-grass,1708602571,1708602571,1711506795 served/bits/touching-grass/grass_poster_alternate.jpg,1708602542,1708602542,1711579986 served/bits/touching-grass/grass.mp4,1708602542,1708602542,1711506776 served/bits/touching-grass/grass_poster.jpg,1708602542,1708602542,1711579967 served/bits/touching-grass/grass_720p.mp4,1708602542,1708602542,1711506776 -served/bits/touching-grass/touching-grass.html,1709463806,1712999119,1712999127 +served/bits/touching-grass/touching-grass.html,1709463806,1712999119,1713003428 served/bits/touching-grass/grass.vtt,1708602542,1708602542,1711506776 served/bits/touching-grass/touching-grass.css,1708605900,1708605900,1711506776 served/bits/scrap,1708608183,1708608183,1711506795 @@ -70,9 +70,9 @@ served/bits/scrap/aeropostale-prehistory/dramatic_third.jpg,1708608052,170860805 served/bits/sillygifs,1708606021,1708606021,1711506795 served/bits/sillygifs/0123456789.gif,1708605998,1708605998,1711579993 served/bits/sillygifs/100_000.gif,1708605998,1708605998,1711579994 -served/bits/sillygifs/sillygifs.css,1708763451,1708763451,1711506795 +served/bits/sillygifs/sillygifs.css,1708763451,1708763451,1713001756 served/bits/sillygifs/1000.gif,1708605998,1708605998,1711579993 -served/bits/sillygifs/sillygifs.html,1708763356,1708763356,1711506794 +served/bits/sillygifs/sillygifs.html,1708763356,1713001831,1713003428 served/bits/sillygifs/100.gif,1708605998,1708605998,1711579993 served/bits/sillygifs/1_000_000.gif,1708605998,1708605998,1711580002 served/bits/sillygifs/10_000.gif,1708605998,1708605998,1711579995 @@ -87,7 +87,7 @@ served/colorsquash/v0.1.0/squash-v0.1.0_macos-x64.tar.gz,1710067376,1710067376,1 served/colorsquash/v0.1.0/squash-v0.1.0_linux-aarch64.tar.gz,1710067376,1710067376,1711506776 served/colorsquash/v0.1.0/squash-v0.1.0_linux-x64.tar.gz,1710067376,1710067376,1711506776 served/things,1709311271,1713001696,1713001710 -served/things/things.html,1709311581,1713001176,1713001183 +served/things/things.html,1709311581,1713001176,1713001756 served/minecraft,1710493895,1710493895,1711506795 served/minecraft/minecraft.css,1710494694,1710494694,1711506776 served/minecraft/minecraft.html,1710551040,1710551040,1711506776 diff --git a/served/bits/ramen-bowl.html b/served/bits/ramen-bowl.html index 1820f74..61d596b 100644 --- a/served/bits/ramen-bowl.html +++ b/served/bits/ramen-bowl.html @@ -3,9 +3,8 @@ template=post title=Ramen Bowl style=/styles/post.css style=poem.css -publish=December 21st, 2023 -#Category poetry -#Tags writing + +published=2023-12-21 23:00 --- [@paragraphs off] <pre> diff --git a/served/bits/sillygifs/sillygifs.html b/served/bits/sillygifs/sillygifs.html index 1fe7b85..cdcf64b 100644 --- a/served/bits/sillygifs/sillygifs.html +++ b/served/bits/sillygifs/sillygifs.html @@ -3,7 +3,8 @@ template=post title=Sillygifs style=sillygifs.css style=/styles/post.css -#Category gif + +published=2022-12-24 --- <section style="width: 100%; text-align: center; padding: 1rem 0"> diff --git a/served/bits/smoems.html b/served/bits/smoems.html index 2c52476..7aec94e 100644 --- a/served/bits/smoems.html +++ b/served/bits/smoems.html @@ -3,9 +3,8 @@ template=post title=Small Poems style=/styles/post.css style=poem.css -publish=June 16th, 2023 -#Category poetry -#Tags writing + +published=2023-07-15 19:59 --- [@paragraphs off] <p> diff --git a/served/bits/touching-grass/touching-grass.html b/served/bits/touching-grass/touching-grass.html index a57cbd2..b5dcdea 100644 --- a/served/bits/touching-grass/touching-grass.html +++ b/served/bits/touching-grass/touching-grass.html @@ -3,10 +3,8 @@ template=post title=Touching Grass style=touching-grass.css style=/styles/post.css -#Publish 2023-07-29 17:46 -0500 -#Category video -#Tags writing -#QuarkedUp + +published=2023-07-29 17:46 --- [@paragraphs off] <section style="width: 100%; text-align: right; padding: 8px 0"> @@ -71,10 +69,10 @@ Thanks bricks :) The accidental camera movement is nice, too. I like the angle the camera is at and the way it wobbles. It's clearly hand-held. At <span class="mark" data-time="1.3">1.3-ish-seconds</span> you can see I gently sway forward, but seem to be less wobbly. <i>I'm braced; -I'm stable! I have-three-points-of-contact-with-the-ground!</i> Then, at roughly + I'm stable! I have-three-points-of-contact-with-the-ground!</i> Then, at roughly <span class="mark" data-time="1.9">2 seconds</span> when the grass finally yields, I get rocked back and wobbles resume. [#the-sound] The sound! And the sound. The ripping of the grass. That planty matter finally giving way. The fibrous tearing. -I just like it; I enjoy it! I greatly appreciate it. +I just like it; I enjoy it! I greatly appreciate it. \ No newline at end of file diff --git a/served/words/akkoma-postgres-migration.html b/served/words/akkoma-postgres-migration.html index e7c804b..ea2f671 100644 --- a/served/words/akkoma-postgres-migration.html +++ b/served/words/akkoma-postgres-migration.html @@ -3,8 +3,8 @@ template=post title=Akkoma Postgres Migration style=/styles/post.css style=writing.css -#Summary A retelling of how I migrated my Akkoma instance's Postgres database and the troubles I faced. -#Publish 2023-10-18 + +published=2023-10-18 23:16 --- \<i>(i'm going to say Pleroma a lot here where Akkoma might @@ -21,7 +21,7 @@ style=writing.css </p> </details> -<hr/> +<hr /> Recently I went about trying to get the services running on my VPS to be happy in a gig of RAM. I did not achieve this, @@ -47,7 +47,8 @@ to give me the right config lines for 100M. It worked well! This was all for naught, though, because I couldn't get my disk to fit under 25G, which was also a requirement of nanodeisation that I'd forgotten about. The database itself was 9.9G! You can -<a href="https://docs.akkoma.dev/stable/administration/CLI_tasks/database/#prune-old-remote-posts-from-the-database">Prune old remote posts</a> +<a href="https://docs.akkoma.dev/stable/administration/CLI_tasks/database/#prune-old-remote-posts-from-the-database">Prune + old remote posts</a> but I didn't really want to do that yet. It seems like the right way to go, but I had one more trick. @@ -60,7 +61,7 @@ certainly put this on the same server as all my things, but I like having the separation. This does mean that I pay for almost an entire Nanode to do -very nearly nothing. +very nearly nothing. By putting Postgres on it I'd lose the different-machine aspect of the separation, but gain so much disk space and memory. The @@ -69,7 +70,8 @@ good enough for me! <h3 id="setup-postgres">Postgres Migration</h3> -<i>(more of a recount of events than a guide, but written guidlike? just pay mind to the commands and you'll be fine)</i> +<i>(more of a recount of events than a guide, but written guidlike? just pay mind to the commands and you'll be + fine)</i> Install Postgres on the new server. It doesn't have to be the same major version since we're going to dump and restore the @@ -84,7 +86,8 @@ these have to match the database you're migrating from. I followed the <a href="https://docs.akkoma.dev/stable/administration/backup/#restoremove">Akkoma database restore/move</a> docs and ended up using psql, again under the postgres user, to run <code>CREATE USER akkoma WITH ENCRYPTED PASSWORD '<database-password>';</code> and -<code>CREATE DATABASE akkoma OWNER akkoma;</code>. <i>(well, i replaced akkoma with pleroma and later used alter queries to change them, but that's because my database is old)</i> +<code>CREATE DATABASE akkoma OWNER akkoma;</code>. <i>(well, i replaced akkoma with pleroma and later used alter queries + to change them, but that's because my database is old)</i> After that was ready, I used my firewall of choice (ufw) to allow the servers to talk using their private IPs <i>(yay same datacenter)</i>. After that was done, I ran @@ -92,7 +95,7 @@ this command <code>pg_dump -U akkoma -C akkoma | ssh dynamo "sudo psql -U akkoma and waited. <i>dynamo</i> being the host of the new postgres server and owner of a spot in my .ssh/config. -A Note:<br/> +A Note:<br /> you can directly do <code>pg_dump ... | psql ...</code> but the Postgres upgrade docs say you need to use the new psql version to upgrade, and the old server was missing that binary. Instead of seeing if psql 13 would work or if I could get psql 15 working there, I @@ -138,10 +141,13 @@ does someone like me do when out of luck? Past the error into Google of course! Maybe I should've done that from the start, right, but I don't get many results for Akkoma or Pleroma normally. -So to google I went! And pasted <q>timed out because it queued and checked out the connection for longer than 15000ms</q> +So to google I went! And pasted <q>timed out because it queued and checked out the connection for longer than + 15000ms</q> and then I read -<a href="https://elixirforum.com/t/timed-out-because-it-queued-and-checked-out-the-connection-for-longer-than-15000ms/34793/4">a comment from al2o3cr</a> that said: +<a + href="https://elixirforum.com/t/timed-out-because-it-queued-and-checked-out-the-connection-for-longer-than-15000ms/34793/4">a + comment from al2o3cr</a> that said: <blockquote> <p>Usually that's an indication of database issues, from missing indexes to queries that need optimization.</p> |