NoPublic, bureaucrat, administrator
1,068
edits
Changes
no edit summary
The first step of option 1 is to create a backup of the staging area database. This is different from taking a backup of IMSMA, because the staging area is not part of the IMSMA application, but a stand-alone PostgreSQL database. A backup can be created using any tool that can connect to the PostgreSQL database (e.g. Navicat). The guide below details the steps using pgAdmin3, a tool that comes for free with every PostgreSQL installation, thus also with an IMSMA installation.
{{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 the following 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>
</ol>
=== Restore of the staging area ===__NOEDITSECTION__
Those having received the .backup file can then restore it on their PostgreSQL installation. If it is restored on a computer where IMSMA is installed, a PostgreSQL server is available and the staging area can be hosted on the same database server as IMSMA. If IMSMA is not installed, then PostgreSQL first needs to be installed manually.In order to restore a backup of the staging area database, the following steps are required:<ol><li>Connect to the PostgreSQL server with a user who has permission to create a new database and restore a database. The '''imsma''' user has these permissions. On a computer where IMSMA is not installed, the '''postgres''' user could be used, or any custom-created one with enough permissions.</li><li>If no staging area database has been created yet, a new one has to be created. If it already exists, skip this step.<ol><li>Create a new database by right-clicking on the root '''Databases''' object in the object tree</li><li>Provide a name and an owner for the database. The owner can be chosen from a drop-down list of all database users. If '''imsma''' is available, choose it, otherwise choose '''postgres''' or any custom-defined user.</li><li>On the '''Definition''' tab, choose '''UTF8''' as the encoding, and '''template_postgis20''' as the template.</li><li>Click '''OK'''</li></ol></li></ol>
== Hosting the staging area on a server ==__NOEDITSECTION__