Restore database (need urgent help)

Kobo On Your Own Server
1

Guys, I need immediate help. I’m desperate. Please help me to restore the database from backups. I made backups as shown on github.
docker-compose -f docker-compose.frontend.yml -f docker-compose.frontend.override.yml exec kobocat /srv/src/kobocat/docker/backup_media.bash

etc.

Then it happened that I installed the server again and need to restore all bases from backups, but koboform base is not restored. It gives these errors.

postgres
postgres1634×552 139 KB

mongo database restored with the message that files are restored. The kobocat and redis databases did not show any messages when restoring, so it is not known whether they were restored or not.
I restored the databases by entering the containers with these commands

Mongo
mongorestore -u root -p 12345678 --archive=/srv/backups/mongo-5.0-kobo.local-2024.04.28.16_00.gz --gzip

PostgreSQL

pg_restore -U kobo -d kobocat -c “/srv/backups/postgres-kobocat-14-kobo.cx.ua-2024.04.27.19_46.pg_dump”

pg_restore -U kobo -d koboform -c “/srv/backups/postgres-koboform-14-kobo.cx.ua-2024.04.27.19_46.pg_dump”

Redis
gunzip /srv/backups/redis-6.2.14-kobo.cx.ua-2024-04-27-19_46.gz && mv /srv/backups/redis-6.2.14-kobo.cx.ua-2024-04-27-19_46 /data/enketo-main.rdb

2

Update. All the backups put something in the databases. Since the databases are filled with my information. And the server and web interface even started. Mongo database contains information about projects and completed questionnaires. The kobocat database contains information about users and attachments. It is even possible to log in under all previously created users in kobo. But all users have no projects created by them or shared with them. Maybe someone has encountered this ?

4

@Rahul, pinging @stephenoduor and @ks_1 for your support.