In case of database damage, it can be restored from previous database backup. It is required to have valid database copy. To restore the database:
1. Make sure, that the application is stopped:
stop Xopero Backup&Restore service
2. Run cmd with administrator rights:
cd C:\Program Files\Xopero Software\Xopero Backup&Restore\pgsql\bin
3. Connect with database:
psql -U postgres -p 5433 -d opero21
4. Verify that the database opero21 is empty:
SELECT count(id) FROM public.versions; SELECT count(id) FROM public.files;
empty base should return a 0 value
5. Return to catalog:
\q
6. Drop database:
dropdb -U postgres -p 5433 opero21
7. Create empty database:
createdb -U postgres -p 5433 opero21
8. Import database backup:
psql -U postgres -p 5433 -f name_dumpbase opero21