Database Installation Requirements

Owned by Former user (Deleted)
Last updated: Aug 27, 2019 by Maciej Chochla (Deactivated)
2 min read

(Applicable to ViaWorks 2.6-2.8 and Locator 2.9 or later)


Locator supports two different types of databases for storing its data: PostgreSQL, and Microsoft SQL Server 2012.  Each requires a unique set of prerequisites.


PostgreSQL

As of version 2.6, Locator only supports installing the included PostgreSQL database on the local machine.  Because of this, the main requirement is that the disk space on the machine installed to is sufficient in size enough to satisfy the data that is required from the Locator Application as well as the database.  Locator requires the drive where the Program Data is installed to have at least 60 GB of available space.  See the "Planning & Pre-Installation - Hardware Requirements" section in the Installation Guide for more information.


Installing with the included PostgreSQL can be done by either choosing "Typical Install", or by choosing the PostgreSQL option in the Database Information page of the installer when "Custom Install" is chosen in the Install Options page (more information below).  Choosing this option will cause the installer to both create the database and configure it with all the necessary tables, schemas, and starting data for the application to run effectively.


If "Custom Install" is chosen in the Install Options page of the installer, then the user is also able to update the name of the database that will be installed on the local machine.  This is designed so the database can comply with any naming conventions the company may have.  Note that this method will install the database on the local machine, and start the Locator application services under a local service account that is created by the application at install time.

Microsoft SQL Server

Prerequisites

Microsoft SQL Server is not installed by the Locator  installer. The following tasks must be completed before installing Locator :

  • Microsoft SQL Server must be installed
  • A database with the proper settings for Locator must be created
  • An application service account with the proper access must be created

The steps are described here.


ayfie