Prerequisites

1. iShare installers, iShare3rdPartySetup and iShareSetup
2. SDW scripts, available from https://bitbucket.org/astuntech/spatial_data_warehouse

Installation of PostgreSQL 9.0 and Studio

Studio is the recommended tool for managing the SDW. User administration tasks and data transfers are handled through Studio's Workflow module so it's a common requirement to have Studio on the same server as SDW. If Studio is installed elsewhere on the network then this section can be skipped. 

If Studio is being installed just for SDW then consider reducing Studio's modules to just Data Share Connections and Workflow.

To install follow these /wiki/spaces/ISHAREHELPSTAGING/pages/53215260 but with the following amendments

• Include Postgres when running the Astun 3rd Party Installer.
• SSL enabled OGR libraries will not be necessary unless using SSL connections are required for external connections

Installation of SDW

1. Using pgAdmin3 create a database called sdw owned by the postgres user, template template_postgis
2. Run AstunPGInstaller.
   1. Uncheck Astun Databases only.
   2. Enter the correct postgres password.
   3. Hit Refresh.
   4. Select 'sdw' as the database.
   5. Select Start
   6. Install all four prerequisistes - TSearch, PostGIS, TableFunc, FuzzyStrMatch
   7. Click Ok and then click Start.
   8. Decline option to backup.
   9. Deselect all components leaving Astun Core component as the only component to install. Include GPT (thematics) and GIS too if those functions will be used.
   10. Click Start and click Yes.
   11. Click Ok and quit AstunPGInstaller.
3. Run the sdw_build.sql in pgAdmin3.
4. Run the sdw_build_mapinfo.sql in pgAdmin3 if mapinfo support is required.

Post-Installation

You can now examine the user documentation. First steps would be to create some admin login roles and then look to creating schemas & migrating data. All tasks are carried out using Studio and pgAdmin3.