Failed restore of Mastodon

[JfmbLinux]

Consider making a backup of the Mastodon database and configuration files.
If you’re interested, I’ll show you what I put in place?

[Bumble]

What is it you want me to do?

[JfmbLinux]

Back up the Mastodon database and configuration files.
Create a backup of the Mastodon database and configuration files

BACKUP :

mkdir /var/www/backups/mastodon_backup

cd /var/www/mastodon/live
pg_dump -U mastodon -W -F t mastodon > /var/www/backups/mastodon_backup/mastodon_backup.dump

The password is found in the .env.production file, on the line:

nano /var/www/mastodon/live/.env.production
PostgreSQL
DB_PASS=”xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx”

Back up the following folders:

cd /var/lib
cp -R -v redis /var/www/backups/mastodon_backup

cd /var/log
cp -R -v mastodon /var/www/backups/mastodon_backup

cd /var/www/mastodon/live/public
cp -R -v packs /var/www/backups/mastodon_backup

cd /var/www/mastodon/live/public
cp -R -v system /var/www/backups/mastodon_backup

RESTORE :

cd /var/www/mastodon/live
pg_restore -U mastodon -d mastodon < /var/www/backups/mastodon_backup/mastodon_backup.dump

cd /var/www/backups/mastodon_backup
cp -R -v redis /var/lib

cd /var/www/backups/mastodon_backup
cp -R -v mastodon /var/log

cd /var/www/backups/mastodon_backup
cp -R -v packs /var/www/mastodon/live/public

cd /var/www/backups/mastodon_backup
cp -R -v system /var/www/mastodon/live/public

Restart Mastodon services:

systemctl restart mastodon-web.service
systemctl restart mastodon-sidekiq.service
systemctl restart mastodon-streaming.service

Or in a single command:

systemctl restart mastodon-web.service mastodon-sidekiq.service