Woozle: Woozle moved page Mastodon/admin/backups to software/Mastodon/admin/backups: disambiguate from band (eventually)

2025-03-12T19:12:42Z

Woozle moved page Mastodon/admin/backups to software/Mastodon/admin/backups: disambiguate from band (eventually)

← Older revision	Revision as of 19:12, 12 March 2025
(No difference)

Woozle: Created page with "==About== Backing up a Mastodon instance requires backing up the following: * media files (may be on another server) * database ===Database=== For reasons unknown to humma..."

2021-12-26T01:05:34Z

Created page with "==About== Backing up a Mastodon instance requires backing up the following: * media files (may be on another server) * database ===Database=== For reasons unknown to humma..."

New page

==About==
Backing up a [[Mastodon]] instance requires backing up the following:
* media files (may be on another server)
* database
===Database===
For reasons unknown to hummankind, Mastodon is hard-wired to use [[PostgreSQL]] for its main database engine, despite the fact that Mastodon uses [[Ruby on Rails]] which provides a database-agnostic framework. The most obvious way to back up Mastodon's data is to use the <code>pg_dump</code> client utility, preferably running on the machine where the backup data will be stored.

Steps:
* Get the PostgreSQL connection credentials. These should be in <code>{{arg|public html}}/.env.production</code> (<code>DB_*</code> settings).
* If the PostgreSQL server is directly accessible:
** Create the <code>~/.pgpass</code> file (or modify it) so it has the password for the user you want to connect as. Details are [https://www.postgresql.org/docs/9.3/libpq-pgpass.html here].
** [{{hilite|NOT TESTED}}] From the backup target machine, run: <code>pg_dump -U {{arg|DB_USER}} -h {{arg|host}} -p {{arg|DB_PORT}} {{arg|DB_NAME}} > {{arg|output_filename}}</code>
* If it's not directly accessible, you'll have to tunnel via ssh and I haven't worked out how to do that via CLI.

software/Mastodon/admin/backups - Revision history

Woozle: Woozle moved page Mastodon/admin/backups to software/Mastodon/admin/backups: disambiguate from band (eventually)

Woozle: Created page with "==About== Backing up a Mastodon instance requires backing up the following: * media files (may be on another server) * database ===Database=== For reasons unknown to humma..."