Restore From Backup PSQL Error

[lehitoskin]

Describe the bug

I am restoring the mastodon app from a tarball backup, but it fails because it doesn't believe psql is running, even though it definitely is.

Context

• Hardware: amd64 device
• YunoHost version: 11.2.30.2
• I have access to my server: Through SSH
• Are you in a special context or did you perform some particular tweaking on your YunoHost instance?: No

Steps to reproduce

• Uninstall broken app

   sudo yunohost app remove mastodon

• Restore from backup

  sudo yunohost backup restore mastodon-timestamp.tar.gz

• PSQL not running error occurs

Expected behavior

The app is restored from the backup that YunoHost itself made.

Logs

https://paste.yunohost.org/raw/igeqanevor

[lehitoskin]

After looking a little further, this bit at the end of the log stood out to me:

WARNING - psql: error: could not connect to server: No such file or directory
WARNING - 	Is the server running locally and accepting
WARNING - 	connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

The postgresql service seems to fail during the backup restore process and, sure enough, when I run sudo yunohost service status postgresql the it says "status: failed" and needs to be manually restarted.

[lehitoskin]

I don't know why, but after attempting a fresh install of the mastodon app --- which failed --- I ran the restore command again and it went through successfully. 😭