NoPublic, bureaucrat, administrator
1,068
edits
Changes
no edit summary
</ol>
== Hosting the staging area on a server ==__NOEDITSECTION__
The staging area may be hosted on a server allowing clients from within or outside of the network to connect. The following steps are required to achieve this:
# If required, install the [[Staging_Area_Generator|Staging Area Generator]] on the server - this will automatically install PostgreSQL and PostGIS.
# If you have not installed the [[Staging_Area_Generator|Staging Area Generator]], install PostgreSQL and the PostGIS extension on the server.
# Access the database server with e.g. pgAdmin, Navicat, or any other SQL tool.
# Create a new PostgreSQL database.
# Restore the staging area backup as described [[Sharing_an_IMSMA_Staging_Area#Restore of the staging area|above]].
# OR, instead of the previous two steps, if the [[Staging_Area_Generator|Staging Area Generator]] is installed and the IMSMA installation is accessible, then the staging area can directly be generated from a remote IMSMA. In this case, in the window in which the parameters for the [[Staging_Area_Generator|Staging Area Generator]] are entered, specific the machine name or IP address on which the source database (IMSMA) is running.
# Ensure that port 5432 (default PostgreSQL port) is open on the server, for the machines having to access it.
# Ensure that PostgreSQL is configured to allow remote connections. This configuration is done via the attribute '''listen_addresses''' in the file named '''postgresql.conf''' that can be found in the '''data''' directory of the PostgreSQL installation (e.g., if IMSMA is installed, then that file can be found in C:\IMSMAng\pgsql\data). If any changes are made to the configuration, the pgSQL service needs to be restarted (Control Panel → Administrative Tools → Services).
The staging area can then be accessed from the specified machines/IP addresses/networks via a JDBC connection.
{{NavBox Business Intelligence}}
[[Category:VIE]]