NoPublic, bureaucrat, administrator
1,068
edits
Changes
no edit summary
</ol>
<li>Right-click on newly created (or already available) staging database, and choose '''Restore...'''</li>
{{Note|If you have an existing database (e.g. the staging area from last month), it needs to be dropped and recreated, otherwise the restore will only issue errors saying that the tables already exist. As an alternative to manually dropping and recreating a database, scripts can be provided for the restore that allow to specify several options. Please contact your [[Management_Consulting_Team|GICHD IM adviser]] if you wish to implement such scripts.}}
<li>In the restore window, choose '''Custom or Tar''' as the Format, select the path and filename of the .backup file, and choose '''imsma''' (if available) or '''postgres''' (or any other custom-defined user) as the Role.</li>
<li>Click on '''Restore''' and wait for the restore process to finish. Depending on the size of the database, this can take some time.</li>