Login
You're viewing the techdon.dev public feed.

Replies

  • Nov 20, 2026, 5:50 PM

    Postgresql upgrade failed (will have to look at it later, seems that some ERROR: index row size 2712 exceeds btree version 4 maximum 2704 for index "index_preview_cards_on_url" so it was rolled back.

    I've reverted to v18, and upgraded Mastodon to 4.6.12 now, rolling post-upgrade database updates ..

    Image attached toot
    💬 1🔄 0⭐ 0
  • Nov 20, 2026, 6:01 PM

    Nice - v4.7.6 post-deployment mgirations are running now and checking the release notes on keys.

    Image attached toot
    💬 1🔄 0⭐ 0
  • Nov 20, 2026, 6:16 PM

    Now attempting the PostgreSQL v18 -> v19 migration again, I've found and removed ~20 status previews with url length > 2048 bytes. None of them were particularly useful, so I'm purging them, then I'll bring down ublog.tech while I do the migration again.

    💬 1🔄 0⭐ 0
  • Nov 20, 2026, 6:26 PM

    Awesome!

    root@ublog:~# pg_lsclusters
    Ver Cluster Port Status Owner Data directory Log file
    18 main 5433 down postgres /var/lib/postgresql/18/main /var/log/postgresql/postgresql-18-main.log
    19 main 5432 online postgres /var/lib/postgresql/19/main /var/log/postgresql/postgresql-19-main.log

    \o/

    💬 0🔄 0⭐ 0