Steps for total recovery

TakadaGuna

Hello,
I am trying to restore from a rei3-made integrated backup to a different server (already installed with postgres and new empty database). I'm a newbie on database, so please be patient with me if my question is a bit silly. I tried pg_restore but there are always errors no matter what i do.

So this is basically what i did:

I made integrated backup in rei3 to my local database server.
I copied the backup folder to a folder in my new server (which has postgresql and new empty database)
I unzipped the files.zip and transfer.zip files, and copied the files to the corresponding folders in rei3 data folder
I restore the database using pg_restore -h localhost -p 5432 -U <username> -d <database_name> -v </path/to/backupsource>
The pg_restore seem to happen, but says there are 1000+ errors.

However, after I open rei3 again, it's still empty without any applications or data.

Could you give me some pointers on the correct steps? I cannot find any help in the documentation about the restore process steps other than about pg_restore format.

Thank you in advance.

gabriel

Hello again :)

Sorry that you are having issues. The full documentation for how to recover r3 is here:
https://rei3.de/en/docs/admin#backup-and-recovery

The big issue must be with the database as this is the only thing required for r3 to start. Some basic things that can go wrong:

Did you use the same owner ("role" in Postgres terms) for the old/new database? The default is called app. If you want to use a different owner, you can use the option --no-owner in pg_restore. This can be the cause for the 1000+ errors as it tries to assign the non existing app as an owner 1000+ times.
Did you update your DB connection details in your config.json file before starting r3 on the new server?
Is r3 registered as a service on the new server? If yes, what are the error messages being shown in the service log? (systemctl if most linux distros, Windows application events otherwise).

TakadaGuna

Thank you for the pointers. It turns out that your first suggestion was correct, I did use different owner for the database. There is also another silly mistake, that after creating new database, I login rei3 to check if it already uses the new database. When I did, it turns out it create initial tables, etc. so the database was no longer empty. That also creates errors during pg_restore.

After correcting those, I successfully restore the database from the backup. It's simple actually 😊

Thanks for your help. And thank you for this wonderful platform. 👍🏻