Database restore

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 database is stopped:

   stop OperoAllInOne 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