Posts tagged with “Postgres”
Upgrading Mastodon from PostgreSQL 15 to PostgreSQL 17
Upgrading Mastodon’s database from PostgreSQL 15 to 17 on Ubuntu 24.04 is fast and easy using `pg_upgradecluster` with link mode. Here’s a quick guide with steps, tips, and cleanup.
Clearing up the Mastodon Database using pg_repack
Running pg_repack regularly on your Mastodon instance can stop the database from growing too large.
Tweaking Postgres for Mastodon
I had to increase Postgres' max_connections settings to resolve issues with my Mastodon instance.