INSTALLING THE SERVER

If you are unable to begin installation after starting the Windows Installer file (.msi file) and you are running version of MS Windows older than XP then it is likely that you need to update the Windows Installer before continuing. Proceed to the prerequisite section to download and install the necessary files from Microsoft.

Database Server Installation Instructions

The server installation consists of installing the backend database server called PostgreSQL. Checked and verified installation files may be downloaded from http://www.galacticasoftware.com/postgresql

 

  1. Download PostgreSQL installation zip file from http://www.galacticasoftware.com/postgresql/postgresql-8.3.9-1.zip and save it.
  2. Extract the zip file into a temporary location. After successful installation, you may delete all of these files as well as the zip file downloaded in Step 1
    If you are installing on MS Windows 2000 or older, you will need a compression utility to extract the zip file. If you do not have one installed, we would recommend 7-zip. You may download version 4.23 from here.
  3. Go to the location where you have extracted the files and click on the postgresql-8.3.msi file.
  4. This is the first window of the installation. Select the language for the installation and click Start button.
  5. On the introduction screen that follows, click the Next button to proceed.
  6. The following window will display the Installation Notes. You may read them! The most important bit here is to install PostgreSQL on a computer with a NTFS file system. All modern computers that came with pre-installed versions of Windows 2000 or XP will be running on an NTFS. Click the Next button to proceed.
  7. In this window as seen here, don't change anything. Just click the Next button to proceed.
  8. Here, you do not need to change anything. Just hit the Next button.

    A number of dialog boxes may appear about creating a user account. Just click OK to accept. When a random password is presented to you, you do not need to write it down. You will never need to use it.
  9. After the server account was setup, you are now ready to configure the database server. The next step should look like the window here.

    In this window, before continuing, you will need to specify a password you will remember. You will need this password so don't forget it (If you do forget it, there is a way to recover it. DO NOT reinstall PostgreSQL or you may lose data that was already entered).

    Another important thing to note here is the "Accept connections on all address, not just localhost" checkbox. If you are only going to be using PHMS on the computer where you are installing PostgreSQL, leave this unchecked. If you plan to access the database from other computers (ie. install the client on computers other then the server), make sure that you check this checkbox.

    After you entered the password, click Next button.
  10. In the next window, make sure that PL/pgsql is selected (it should be by default) and click the Next button.
  11. In the contrib. modules window, leave the defaults and click the Next button.
  12. Click Next to start the installation.
  13. After the installation is complete, you may click the Finish button to close the installer. Congratulations, you have now installed PostgreSQL database server.

 

Database Initialization Instructions

After installing the database server, you need to create the empty database to store the data.

  1. Go to the folder where you have unpacked the zip file in the Database Installation Instruction section.
  2. Start InitializeDatabase.bat and follow the prompts.

Now you may go to the Installing the Client section to install your client software.

[table of contents]