Upgrade a Data Share Database

Owned by Kim Stimpson
Last updated: 23 Oct, 2014
1 min read

If you wish to upgrade your Data Share database to the latest version of PostgreSQL then you need to follow these steps.

  1. Backup your existing database
  2. Install the latest Astun 3rd Party applications to install the latest version of PostgreSQL and PostGIS.
  3. Create a new Data Share database using the latest PGAdmin.
  4. Run the AstunPGInstaller to install the latest Astun scripts onto the new Data Share database.
  5. Configure Studio to point to the new Data Share database via the Data Share Settings.
  6. Populate the new Data Share database using one of the following methods.
    1. If you have not made any bespoke changes / additions to your Data Share database then you can now simply run each of the Jobs in the Workflow in Studio to populate your database with the latest information. Simply right click on a Job and select Run... or leave the Scheduler to update the data overnight.
    2. Alternatively you can restore the backup of your old database into the new one using the latest PGAdmin. Note: You will see various errors and warnings regarding existing functions etc. which can be ignored.