Changes

Jump to: navigation, search

Sharing an IMSMA Staging Area

224 bytes added, 09:30, 16 July 2014
no edit summary
{{Note|On a computer with IMSMA V6 installed, the executable for starting pgAdmin3 is C:\IMSMAng\pgsql\bin\pgAdmin3.exe}}
In order to create a backup of the staging area database, these steps are required:
# <ol><li> In pgAdmin3, connect to the PostgreSQL server hosting the staging area -- typically, this server will be localhost, and the port is 5432.</li># <li> Open the staging area database by clicking on it# [[Image:backup_staging_area_step1.png|center]]</li><li>Right-click on the database (e.g. staging) and choose '''Backup...'''</li># [[Image:backup_staging_area_step2.png|center|250px]]</li><li>In the backup window, choose a destination folder and a filename, and the other options as shown in the screenshot below.</li>[[Image:backup_staging_area_step3.png|center|400px]]</li># <li>Click on '''Backup''' and wait for the backup to finish. Depending on the size of the database, this can take some time. When finished, click '''Done'''.</li># <li>In the chosen destination folder, there is now a file with the chosen name and the extension .backup (e.g. staging_area_backup.backup).</li># <li>This file can now be sent to whoever should receive it.</li></ol>
=== Restore of the staging area ===__NOEDITSECTION__
1,068
edits

Navigation menu